At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

 
JOB DESCRIPTION

Job Title: Lead Business Intelligence Engineer

Corporate Title: Senior Associate

FLSA Code (US Only): N/A

People Manager: No

Position Summary 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:

This role will be in the Claw Team within Enterprise Data & Corporate Technology (EDCT). The Business Intelligence team maintains the firm’s business intelligence tools and data warehouse.  As part of the Claw team, the candidate is responsible for:

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
24×7 on-call L3 support on a rotational schedule with other team members
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

Qualifications/Knowledge/Skills

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. Do not edit this bullet

Leadership Competencies for this level include 

Accountability: Demonstrates reliability by taking necessary actions to continuously meet required deadlines and goals.
Global Collaboration: Applies global perspective when working within a team by being aware of own style and ensuring all relevant parties are involved in key team tasks and decisions.
Communication: Articulates information clearly and presents information effectively and confidently when working with others.
Influencing: Convinces others by making a strong case, bringing others along to their viewpoint; maintains strong, trusting relationships while at the same time is comfortable challenging ideas.
Innovation and Creativity: Thinks boldly and out of the box, generates new ideas and processes, and confidently pursues challenges as new avenues of opportunity.

Qualifications

Minimum of 7 years of related experience
Bachelor’s degree preferred equivalent experience

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
About DTCC  Do not edit this section
With over 40 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From operating facilities and data centers around the world, DTCC automates, centralizes, and standardizes the processing of financial transactions across the trade lifecycle and mitigates risk for thousands of institutions worldwide.
At DTCC we value on our clients’ interests and partner to deliver superior results with excellence and innovation and lead with integrity. We proactively develop your potential and invest in your career.

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.