Lead Business Intelligence Engineer

The Business Intelligence Lead will be responsible for building data pipelines using their deep knowledge of Talend, SQL and Data Analysis on the bespoke Snowflake data warehouse for Business Intelligence.

Specific Responsibilities:

• Working on and leading engineering and development focused projects from start to finish with minimal supervision
• Providing technical and operational support for our customer base as well as other technical areas within the company that utilize Claw
• Risk management functions such as reconciliation of vulnerabilities, security baselines as well as other risk and audit related objectives
• Administrative functions for our tools such as keeping the tool documentation current and handling service requests
• Participate in user training to increase awareness of Claw
• Ensuring incident, problem and change tickets are addressed in a timely fashion, as well as escalating technical and managerial issues
• Following DTCC's ITIL process for incident, change and problem resolution
  

• Self-starter, continually striving to improve the teams service offerings and one's own skillset
• Must have a problem-solving and innovative mindset to meet a wide variety of challenges
• Willingness and ability to learn all aspects of our operating model as well as new tools
• Ability to meet deadlines, goals and objectives
• Moderate to advanced competency of Windows and Unix-like operating system principles (power user functions)
• Developed competencies around essential project management, communication (oral, written) and personal effectiveness
• Working experience covering Microsoft Office tools such as Outlook, Excel, PowerPoint, Visio and Project
• Good SQL skills and good knowledge of relational databases, specifically, Snowflake
• Ability to manage agile development cycles within the DTCC SDLC (SDP) methodology
• Optimize/Tune source streams, queries, PowerBI Dashboards
• Good knowledge of the technical components of Claw (i.e. Snowflake, Talend, PowerBI, PowerShell, Autosys)
• Aligns risk and control processes into day to day responsibilities to monitor and mitigate risk escalates appropriately.

Specific Skills and Technologies

• Minimum of 5 years of related data warehousing work experience
• 5+ years managing data warehouses in a production environment. This includes all phases of lifecycle management: planning, design, deployment, upkeep and retirement
• 5+ years managing distributed teams with an employee/vendor mix
• 5+ years managing offshore vendors
• Strong understanding of star/snowflake schemas and data integration methods and tools
  

IT Architecture and Enterprise Services are responsible for enabling digital transformation of DTCC. The group manages complexity of the technology landscape within DTCC and enhances agility, robustness and security of the technology footprint. It does so by serving as the focal point for all technology architectural activities in the organization as well as engineering a portfolio of foundational technology assets to enable our digital transformation.