We are looking for self-motivated and data-driven engineers, architects, and designers who desire to find solutions and make an impact at scale while collaborating with a distributed team of like-minded and highly skilled professionals.
-
Collaborate with database, engineering, and business teams to improve and modernize the organization's Financial Data Product
-
Research legacy systems followed by an approach to design, implement and deploy new data models.
-
Experience designing data models and data warehouses and using SQL (Microsoft SQL and PostgreSQL)
-
Develops and maintains scalable database structures and schemas and builds new integrations to support increasing data volume and complexity.
-
Implements processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
-
Performs data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.
-
Defines company data assets and data models and how to best structure queries for performance
-
Designs data integrations and data quality framework.
-
At least four years of experience with MSSQL and SQL
-
Strong knowledge of SQL Server internals to troubleshoot, suggest, or implement improvements for database performance gains.
-
Expertise in ingesting, transforming, and making data available to multiple organizational systems in MS SQL Server
-
Comfortability in working with Complex SQL
-
Experience working in C# and .NET
-
Experience with schema design and dimensional data modeling
-
Recent experience working within AWS
-
Financial Services industry experience is a plus.
-
Ability to manage and communicate data warehouse plans to team members
-
Experience designing, building, and maintaining databases in AWS