Highlights
Collaborative environment, competitive compensation, comprehensive benefits package.
Description
Job Summary
pWe are seeking a skilled Software Engineer to join our dynamic Information Technology group at DTCC. This role involves designing and implementing data infrastructure solutions that support critical business processes. You will work closely with cross-functional teams to deliver high-quality systems and improve operational efficiency.
Responsibilities
- Design, develop, and maintain data infrastructure solutions using Snowflake and other relevant technologies
- Analyze query profiles and execution plans to optimize performance and reduce costs
- Collaborate with cross-functional teams to ensure alignment with organizational goals
- Implement governance, risk, and compliance standards in line with industry best practices
- Provide actionable insights through data analysis and trend identification
Required Skills
- Data engineering concepts (ETL/ELT pipelines)
- Snowflake architecture and query optimization
- SQL performance tuning and query execution plans
- Experience with cloud platforms like AWS or Azure
- Strong analytical skills for data interpretation and insights generation
Required Skills Explained
- Strong understanding of Snowflake architecture, including warehouses, clustering, partitioning, and query execution concepts.
- Hands-on experience or foundational knowledge in SQL query optimization and performance tuning.
- Ability to analyze query profiles, execution plans, and warehouse usage to identify performance and cost improvement opportunities.
- Awareness of FinOps principles, including cost monitoring, resource utilization, and optimization strategies.
- Proficiency in data engineering concepts such as ETL/ELT pipelines, data modeling, and batch/stream processing.
- Exposure to cloud platforms (AWS/Azure) and data ecosystem tools (e.g., Python, Snowpark, Kafka, or similar technologies).
- Strong analytical mindset with the ability to interpret data trends, identify anomalies, and provide actionable insights.
- Experience or awareness of data governance, security, and regulatory compliance requirements (especially in financial services environments).
- Effective collaboration skills to work across platform teams, product teams, and business stakeholders.
- Strong ownership, attention to detail, and ability to drive execution in a fast-paced, delivery-oriented environment.
- Continuous learning mindset to stay current with Snowflake features, performance optimization techniques, and cloud best practices.
Who is this for
pThis role is ideal for individuals with a passion for data infrastructure, strong technical skills in SQL and Snowflake, and experience collaborating across teams. A background in financial services or regulatory compliance is a plus.
Why This Job is a Good Opportunity
ulliWork on innovative projects that contribute to the global capital markets infrastructure.liJoin a dynamic and supportive team dedicated to fostering professional growth.liPotential for comprehensive health and life insurance, as well as pension benefits.liEnjoy a flexible work model with options for remote and onsite work.liBe part of an organization committed to diversity and inclusivity in the workplace.
Interview Preparation Tips
- Review Snowflake architecture fundamentals thoroughly.
- PRACTICE SQL queries and performance tuning exercises.
- Analyze past projects related to data governance and regulatory compliance.
- Prepare examples of successful collaboration with cross-functional teams.
- Discuss your experience or knowledge in FinOps principles, especially cost optimization strategies.
- Showcase your ability to interpret complex data trends and provide actionable insights.
Career Growth in This Role
pThis role provides a solid foundation for career advancement within the Information Technology sector. As you develop expertise in Snowflake architecture, SQL performance tuning, and cloud platform management, you can move into more specialized positions such as senior data engineer or system architect. Continuous learning opportunities within DTCC support your growth and ensure that you remain at the forefront of industry trends.pThe collaborative environment at DTCC encourages professional development, offering numerous chances to take on leadership roles and mentor junior team members. This role is ideal for individuals looking to build a robust career in data engineering with a focus on financial services.
Explore More Opportunities
Skills
Frequently Asked Questions
What kind of projects will I work on?You'll be involved in designing and implementing critical data infrastructure solutions that support business processes.
What benefits are included in the package?Competitive compensation, comprehensive health and wellness programs, and flexible working options including a hybrid model of 3 onsite and 2 remote days per week.
How does DTCC support professional development?We offer investment in your professional growth through various training opportunities and continuous learning initiatives.
