D

DTCC

Clears and settles securities trades for financial firms

Business Intelligence Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeHyderabad, Telangana, India

About the Job

Requirements

  • Minimum of 5 years of related experience.
  • A bachelor's degree is preferred, or equivalent experience.
  • Minimum of 5 years of related data warehousing work experience.
  • At least 4 years managing data warehouses in a production environment, including planning, design, deployment, upkeep, and retirement.
  • At least 4 years managing distributed teams with an employee/vendor mix.
  • Experience optimizing and maintaining complex SQL queries and stored procedures.
  • Knowledge of modern data warehousing principles and practices.
  • Understanding of star and snowflake schemas, data integration methods, and data integration tools.
  • Working experience with Snowflake data warehouses, including writing queries, loading data, and basic performance tuning.
  • Understanding of dimensional and relational data modeling concepts, including star and snowflake schemas.
  • Strong SQL skills, including complex queries, joins, common table expressions, window functions, and basic query optimization.
  • Experience with CI/CD pipelines for code or data deployments, such as Jenkins, Bitbucket, or Autosys.
  • Experience working in Agile/Scrum delivery environments.

Responsibilities

  • Develop and maintain data models to support analytics and reporting requirements.
  • Write and optimize SQL queries, stored procedures, and data transformations within Snowflake.
  • Support building and maintaining data pipelines and ELT/ETL workflows on the Snowflake platform.
  • Assist in implementing and maintaining CI/CD pipelines using Jenkins for automated testing and deployment.
  • Manage code changes and collaborate with the team through Bitbucket, following established branching strategies and code review practices.
  • Work with analysts and product teams to understand business requirements and translate them into data solutions.
  • Follow data quality standards and contribute to documentation and governance practices.
  • Participate in code reviews, knowledge sharing, and continuous improvement initiatives.
  • Build data pipelines using Talend, SQL, and data analysis for the Enterprise Intelligence Snowflake data warehouse.

Desired Qualifications

  • Familiarity with dbt, Airflow, or similar data transformation or orchestration tools.
  • Experience with Power BI, including building dashboards, datasets, DAX measures, and row-level security.
  • Background in reporting and analytics, including creating executive-level reports and self-service reporting solutions.

About the Company

DTCC

Clears and settles securities trades for financial firms

DTCC provides the systems financial firms use to complete securities trades after buyers and sellers agree a transaction. Broker-dealers, banks and asset managers use its services to match trade details, calculate obligations, move securities and report transactions. Its NSCC and FICC subsidiaries clear equity and fixed-income trades, while DTC holds securities and handles settlement and payments such as dividends. By offsetting obligations between firms, its clearing services reduce the securities and cash that must change hands, and its repositories maintain derivatives transaction records for regulatory reporting. The parent was established in 1999 and is headquartered in Jersey City, New Jersey.

Company size
5,001-10,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Jersey City, NJ
Founded
1999

Recently Posted Jobs

Explore more opportunities at DTCC

See more jobs