Collaborate with analytics 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 out new integrations to support continuing increases in 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 in managing and communicating data warehouse plans to team members
Experience designing, building and maintaining databases in AWS