Lead Data Integration Engineer (Snowflake/Python)

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.

DTCC Digital Assets is at the forefront of driving institutional adoption of digital assets technology with a steadfast commitment to innovation anchored in security and stability. As the financial services industry’s trusted technology partner, we pride ourselves on empowering a globally interconnected and efficient ecosystem. Our mission is to provide secure and compliant infrastructure for digitalassets, enabling financial institutions to unlock the full potential of blockchain technology

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

Provides technical expertise and may coordinate some day to day deliverables for a team. Assists in the technical design of large business systems; builds applications, interfaces between applications, understands data security, retention, and recovery. Can research technologies independently and recommend appropriate solutions. Contributes to technology-specific best practices & standards; contributes to success criteria from design through deployment, including, reliability, cost-effectiveness, performance, data integrity, maintainability, reuse, extensibility, usability and scalability; contributes expertise on significant application components, vendor products, program languages, databases, operating systems, etc., and guides less experienced staff during the build and test phases.

Specific Responsibilities

• Act as a technical guide on one or more applications utilized by DTCC.
• Work with the Business System Analyst to ensure designs satisfy functional requirements.
• Work with large, complex data sets and high throughput data pipelines that meet business requirements.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources.
• Build data and analytics tools that utilize the data pipeline to provide actionable insights to operational efficiency and other key business performance metrics.
• Work with internal and external stakeholders to assist with data-related technical issues and support data infrastructure needs.
• Collaborate with data scientists and architects on several projects.
• Solve various complex problems.
  
  

Qualifications

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

Key Skills

• 6+ Years of Experience as Data Engineer or in similar role
• 4+ Years Cloud Datawarehouse Snowflake experience with Stream, Snowpipe ,Task, Snowpark etc
• 4+ years of Python development experience is necessary.
• Experience in distributed processing frameworks like spark, databricks, apache iceberg, data lakehouse architecture patterns
  
  

Talents Needed For Success

• Experience in a cloud-based environment.
• Experience with asynchronous processing using Python.
• Hands-on experience with database technologies (e.g. SQL and NoSql) with performance tuning.
• Technical expertise with data technologies and/or machine learning techniques
• Great numerical and analytical skills
• Ability to write reusable code components.
• Open-minded to the new technologies, frameworks
  
  

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.