Lead BI Engineer - Power BI, Data Analytics & Visualization

As a Lead BI Engineer, you will drive the design and delivery of enterprise analytics and reporting solutions that empower business and technology teams to make data-driven decisions. Leveraging Power BI, SQL, Snowflake, and modern data technologies, you will transform complex data into actionable insights, lead high-impact analytics initiatives, build scalable data models, and influence reporting strategy across the organization. You will partner with cross-functional stakeholders, provide technical leadership, mentor team members, and play a key role in advancing DTCC's data modernization journey.

Your Primary Responsibilities:

• Own the design, development, and optimization of enterprise Power BI dashboards, reports, and analytics solutions.
• Partner with business, product, and technology stakeholders to translate complex requirements into actionable insights.
• Develop scalable data models, DAX measures, Power Query transformations, and SQL-driven reporting solutions.
• Lead BI initiatives through the full development lifecycle, from requirements gathering to deployment and ongoing enhancements.
• Optimize Power BI performance, troubleshoot issues, and improve report usability, scalability, and reliability.
• Collaborate with offshore teams to deliver high-quality solutions on time.
• Mentor junior team members and champion BI development standards, best practices, and reusable design patterns.
• Support modernization initiatives while enhancing and maintaining existing reporting platforms.
• Align risk and control practices with day-to-day responsibilities to appropriately monitor and mitigate risk.

• Bachelor's degree preferred or equivalent practical experience
• 6-8 years of Business Intelligence, Data Analytics, Reporting, or related technology roles.

Talent Needed for Success

• 5+ years of hands-on experience with Microsoft Power Platform, with deep expertise in Power BI.
• Advanced knowledge of DAX, Power Query (M), and Power BI data modeling.
• Strong data modeling fundamentals, including star schema design, relationships, and performance optimization.
• Strong SQL skills with the ability to write, analyze, troubleshoot, and explain complex queries.
• Experience with Snowflake or similar cloud data platforms.
• Experience managing Power BI deployments across Development, QA, and Production environments.
• Hands-on experience with Power BI performance tuning, including Performance Analyzer and report optimization techniques.
• Proven ability to lead projects, influence technical decisions, and mentor junior team members.
• Strong communication and stakeholder management skills with the ability to engage effectively across business and technology teams.
• Strong analytical, problem-solving, planning, and execution skills.
• Ability to manage multiple priorities and thrive in a fast-paced, collaborative environment.

Preferred Skills

• Experience with Sigma Computing, Amazon QuickSight, or other BI and analytics platforms.
• Experience with AWS or cloud-based analytics environments.
• Experience supporting data modernization, transformation, or enterprise reporting initiatives.
• Experience with process mapping, business analysis, and process improvement.
• Experience working with enterprise data platforms and large-scale analytics environments.
• Financial services, capital markets, post-trade processing, clearing, or settlement experience.

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve. The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance., With over 50 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 20 locations around the world, DTCC, through its subsidiaries, automates, centralizes, and standardizes the processing of financial transactions, mitigating risk, increasing transparency, enhancing performance and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm innovates purposefully, simplifying the complexities of clearing, settlement, asset servicing, transaction processing, trade reporting and data services across asset classes, bringing enhanced resilience and soundness to existing financial markets while advancing the digital asset ecosystem. In 2024, DTCC's subsidiaries processed securities transactions valued at U.S. $3.7 quadrillion and its depository subsidiary provided custody and asset servicing for securities issues from over 150 countries and territories valued at U.S. $99 trillion. DTCC's Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes more than 25 billion messages annually. To learn more, please visit us at www.dtcc.com or connect with us on LinkedIn, X, YouTube, Facebook and Instagram. DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you'll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It's the chance to make a difference at a company that's truly one of a kind. Learn more about Clearance and Settlement by clicking here. Serves as a dedicated technology resource for advancing DTCC's business opportunities and providing industry thought leadership for leveraging new technology. The goal of this new department is to partner internally with IT, our business and regulatory divisions and externally with clients, regulators, and fintech vendors, to help build new platforms and business models to advance DTCC's mission to support the financial markets.