Business Intelligence Senior Associate

Job Description

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? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

Pay and Benefits:

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

The Impact you will have in this role:

We are seeking a skilled Database Engineer/ Snowflake Developer to design, develop, optimize, and maintain enterprise data solutions. The ideal candidate will have strong experience with SQL, database platforms, data modeling, ETL/ELT processes, cloud-based data environments, and performance tuning. This role involves working closely with cross-functional teams to ensure reliable, secure, and efficient data pipelines and database systems.

Your Primary Responsibilities:

• 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.
• Implement data integration solutions using APIs, SFTP, and batch processing methods.
• Ensure data quality through validation, reconciliation, and data profiling activities.
• Monitor database and pipeline performance, troubleshoot issues, and implement performance enhancements.
• Implement security controls including RBAC, database roles, and access management.
• Maintain version control using Git and GitHub.
• Support Agile delivery processes, including participation in Scrum ceremonies and Jira-based project management.

Qualifications:

• Minimum of 6 years of related experience
• Bachelor's degree preferred or equivalent experience.

Talents Needed for Success:

• Strong experience with SQL and database development.
• Hands-on experience with Snowflake and at least one major database platform (SQL Server, Oracle, PostgreSQL, or Databricks).
• Experience designing data models and data warehouse solutions.
• Knowledge of ETL/ELT frameworks and data transformation techniques.
• Experience with AWS cloud services and data platforms.
• Understanding of database security, monitoring, and performance tuning.
• Familiarity with Git, GitHub, Jira, and Agile/Scrum methodologies.
• Strong problem-solving and analytical skills with excellent communication abilities.
• Good communication skills with the ability to explain technical concepts to non-technical stakeholders.
• Experience working in Agile/Scrum delivery environments.

Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.