Ernst & Young

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 Title: Lead Business Intelligence Engineer

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
• 24x7 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.

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 5 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

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.