EY is seeking a Manager for its Financial Services Office to specialize in Data Architecture & Engineering with a focus on Power BI. In this role, you will lead teams to solve complex data challenges for financial institutions, providing insights on data ingestion, interpretation, and management. You will help shape the future for our clients and yourself within a globally connected powerhouse of diverse teams.
What You'll Do
- Be part of diverse, geographically dispersed teams to deliver a wide range of data and analytics services.
- Solve complex issues and drive growth across financial services.
- Foster an innovative and inclusive team-oriented work environment.
- Lead and coach diverse teams of professionals with different backgrounds.
- Provide subject matter expertise in defining technical and business approaches.
- Build strong relationships with clients and cultivate business opportunities.
- Initiate and build thought leadership through white papers, point of views, and proof of concepts.
- Work in an entrepreneurial environment to pave your own career path.
- Own BI solution architecture across enterprise environments.
- Design and implement Power BI solutions, including advanced data modeling, DAX, Power Query M, and semantic model design.
- Manage BI governance and DevOps, including RLS/OLS, deployment pipelines, CI/CD, and SDLC.
What We're Looking For
- Undergraduate or master's degree in a quantitative field (e.g., engineering, computer science, business, economics, finance, statistics, and/or analytics).
- Around 6 or more years of related work experience in banking, capital markets, insurance, or asset management.
- Strong communication skills with the ability to effectively advocate technical solutions to technology and business audiences.
- Experience working independently and delivering results under extreme time constraints.
- Strong analytical and problem-solving skills.
- Experience with client-facing activities such as requirements gathering, facilitating meetings, and preparing client-ready deliverables.
- Prior experience in project management and client serving roles.
- Excellent leadership and teaming skills.
- Strong organizational and time-management skills.
- Ability to integrate new knowledge and adapt to change with a natural curiosity and desire to learn.
- A willingness and ability to travel to meet client needs; travel is estimated at 60%.
- Valid passport.
- 10+ years in BI, Data Warehousing, and Analytics with strong hands-on solution architecture ownership across enterprise environments.
- Deep expertise in Power BI, including advanced data modeling, DAX, Power Query M, semantic model design, and large-scale enterprise deployment.
- Expert in Tabular modeling concepts such as star schema, conformed and role-playing dimensions, and slowly changing dimensions (SCD).
- Proven experience with Import, DirectQuery, Composite models, Aggregations, Incremental Refresh, Partitions, and Hybrid Tables.
- Strong command of advanced DAX (evaluation context, filter propagation, iterator vs. aggregator functions, and optimization patterns).
- Proficient with DAX Studio, VertiPaq Analyzer, Tabular Editor (scripting, BPA rules, deployment), and ALM Toolkit for full ALM lifecycle.
- Skilled in Power Query M, including query folding, parameterization, function authoring, and source system performance tuning.
- Extensive knowledge of BI governance and DevOps, including RLS/OLS, sensitivity labels, tenant/workspace controls, deployment pipelines, CI/CD, SDLC.
- Experience with Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2, OneLake), Azure Synapse, Databricks, Snowflake, AWS analytics, timeseries and semi-structured data (Parquet/Delta), near real-time patterns, and BI capacity FinOps.
Nice to Have
- Master’s degree in Business Administration (MBA) or Science (MS) preferred.
- Prior consulting experience.
Technical Stack
- Power BI, DAX, Power Query M
- Tabular Editor, DAX Studio, VertiPaq Analyzer, ALM Toolkit
- Microsoft Fabric, Azure Synapse, Databricks, Snowflake, AWS analytics
- Parquet, Delta Lake
Team & Environment
You will be part of diverse teams of professionals across different geographies.
Work Mode
This is a hybrid role based in New York, Charlotte, or Dallas.
EY is an equal opportunity employer committed to building a better working world.
