Business Intelligence Senior Associate

About the role

Are you ready to make an impact at DTCC? Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

What you'll do

• Design, develop, and maintain database solutions across cloud and on-premise environments
• Write and optimize complex SQL queries, stored procedures, views, and database objects
• Build and support ETL/ELT pipelines using tools such as DBT, Snowpipe, and COPY INTO
• Develop and maintain data models, including relational, dimensional, star, and snowflake schemas
• Manage and optimize databases on platforms such as Snowflake, SQL Server, Oracle, PostgreSQL, Databricks, and AWS

What you need

• 6–11 yrs of experience
• SQL
• ETL
• Snowflake
• Data warehousing
• Git
• SQL Server
• Any graduate

Good to have

• PostgreSQL
• AWS
• JIRA
• Databricks
• dbt
• Reconciliation