SQL Developer - Sr Analyst
Core
Enhance risk reporting data warehouses, tools, and technologies by designing efficient data models, schemas, and pipelines.
Role type
Senior IC SQL Developer (Data Engineering)
Builds
Risk reporting data warehouses and data pipelines
Domain
Financial services / Banking / Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL (stored procedures, views, triggers, functions), Data warehousing principles, Dimensional modelling, Star schema design, Large data warehouse performance tuning, SSIS development, Reporting tools (SSRS, Power BI)
Preferred skills
Python, PowerShell, Risk systems experience, Multi-platform database experience (SQL Server, Oracle, Snowflake), Control-M, Agile methodologies, DevOps practices
Technologies
SSIS, SSRS, Power BI, SQL Server, Oracle, Snowflake, Control-M
Responsibilities
Design and develop efficient data models, schemas, and pipelines; Write complex SQL queries, stored procedures, and functions; Optimize query performance; Implement data security measures and access controls; Monitor and troubleshoot data pipelines; Participate in code reviews; Implement and maintain CI/CD pipelines
Seniority
Senior, hands-on IC
