Principal Business Intelligence Engineer

Description

THE DEPOSITORY TRUST & CLEARING CORPORATION SEEKS:

Title: Principal Business Intelligence Engineer

Job Duties

This role will be in the Enterprise Intelligence team within the department Platform Engineering and Reliably Services (PERS). The team maintains the firm’s reporting and analytics platform (Claw) for centralized IT data, KPIs and metrics. The Principal BI Engineer is responsible for working on and leading engineering and development focused projects from start to finish with minimal supervision.

Responsibilities

• Lead engineering and development focused projects from start to finish with minimal supervision.
• Provide technical and operational support for our customer base as well as other technical areas within the company that utilize Claw.
• Review and supervise the system design and architecture.
• Interacting with stakeholder to understand requirements and providing solutions.
• Risk management functions such as reconciliation of vulnerabilities, security baselines as well as other risk and audit related objectives.
• Refine and prioritize the backlog for the team.
• Groom and guide the team of employees and consultants.
• Responsible for employee appraisals and their growth.
• 24x7 on-call L3 support on a rotational schedule with other team members.
• Participate in user training to increase awareness of Claw.
• Ensure incident, problem and change tickets are addressed in a timely fashion, as well as escalating technical and managerial issues.
• Follow DTCC’s ITIL process for incident, change and problem resolution.
  
  

Job Requirements: Bachelor’s degree in Computer Science, Information Technology, Engineering (any) or related field and 8 years of experience in the job or related position. Prior experience to include:

• 5 years of experience in managing data warehouses in a production environment. This includes all phases of lifecycle management: planning, design, deployment, upkeep, and retirement.
• 5 years leading development teams from with mix of onshore and offshore members.
• Experience designing and architecting data warehousing applications.
• Warehousing concepts involving fact and dimensions.
• Star/snowflake schemas and data integration methods and tools.
• Designing ETL pipelines.
• SQL and relational databases.
• Development in agile scrum teams.
• Development following CI/CD processes.
• Optimize/Tune source streams, queries, and Power BI Dashboards
  
  

LOCATION: Jersey City, NJ. Telecommuting may be permitted a few days a week. When not telecommuting, must report to DTCC’s office in Jersey City, NJ.

SALARY: $155,542 - $184,000per year.

APPLY: Please e-mail resume with cover letter to DTCC at TalentAcquisition@dtcc.com, reference Job Code 8176434 / Principal Business Intelligence Engineer/ Jersey City, NJ