Architect and build a RESTful JSON API that queries from a complex, highly relational database schema and a massive analytics engine using C#, .NET 6, and Microsoft SQL Server.
Design and create a single-page, frontend web application, including elaborate data visualizations and interactive user interfaces, using TypeScript and React
Build out a reusable component library of bespoke React components using the latest tools and best practices, including custom hooks, significantly decreasing time-to-market for new features
Optimize speed of fetching and size of data transfers for large datasets by intelligently designing SQL queries and employing object-oriented programming techniques
Design and create well-organized SQL schemas to store complex datasets of highly relational data using best practices, including one-to-many and many-to-many relationships, foreign keys, join tables, and indexes
Communicate concisely and effectively with technical and non-technical remote coworkers using agile methodologies
Given minimal, flexible business requirements, design, build, test, and deploy code to meet those requirements and quickly move new features from concept to production
Expertly use advanced git techniques, including branching, merging, interactive rebasing, resolving conflicts, and making, reviewing, and approving pull requests to collaborate with other developers, maintain high code quality, and minimize bugs in our codebase