Data Architecture Engineering, Power BI - Manager - Financial Services

Location: New York, Charlotte, Dallas

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world.

Manager – Financial Services – Power BI

EY is the only professional services firm with a separate business unit ("FSO") that is dedicated to the financial services marketplace. Our FSO teams have been at the forefront of every event that has reshaped and redefined the financial services industry. If you have a passion for rallying together to solve the most complex challenges in the financial services industry, come join our dynamic FSO team! Data has yet to be utilized to its fullest potential. Financial institutions are looking to build smarter and more efficient ways to operate their business, through new opportunities uncovered by their data. Our clients look to us as trusted advisors to provide insights on how to ingest, interpret, and manage their data. We specialize in Data Products Management (DPM), Data Architecture and Engineering (DAE), Data Governance and Controls (DGC), and Analytics and Insights (A&I).

The opportunity

We provide constant room for growth through client engagements and personal development. Our practitioners develop and lead innovative data techniques and methods, supporting both business and technology leaders. This role provides the unique opportunity to build a professional network, tackle complex data issues, and drive cutting edge approaches across industry leading clients and domains. The experiences you gain here will be more valuable than anywhere else.

Your key responsibilities

You will be part of diverse teams of professionals across different geographies to deliver a wide range of data and analytics services. You will be solving complex issues and driving growth across financial services.

Skills and attributes for success

• Fostering an innovative and inclusive team-oriented work environment
• Leading and coaching diverse teams of professionals with different backgrounds
• Providing subject matter expertise in defining technical and business approaches
• Building strong relationships with the clients and cultivating business opportunities
• Initiating and building thought leadership through white papers, point of views, and proof of concepts
• Working in an entrepreneurial environment to pave your own career path

To qualify for the role, you must have

• 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 space
• Good communication (verbal and written) with the ability to effectively advocate technical solutions and results to technology and business audiences at all levels and disciplines within EY and client organizations
• Experience working independently, efficiently, and effectively under extreme time constraints and delivering results by critical deadlines
• Strong analytical and problem-solving skills
• Experience with client-facing activities such as requirements gathering, facilitating meetings, presentation creation, and ability to prepare 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

BI Responsibilities

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

Ideally, you’ll also have

• Master’s degree in Business Administration (MBA) or Science (MS) preferred
• Prior consulting experience

What we offer you

At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more .

Are you ready to shape your future with confidence? Apply today.

To help create the best experience during the recruitment process, please describe any disability-related adjustments or accommodations you may need.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

What we offer you
At EY, we’ll develop you with future-focused skills and equip you with world-class experiences. We’ll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more .

• We offer a comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business. The base salary range for this job in all geographic locations in the US is $125,500 to $230,200. The base salary range for New York City Metro Area, Washington State and California (excluding Sacramento) is $150,700 to $261,600. Individual salaries within those ranges are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and geography. In addition, our Total Rewards package includes medical and dental coverage, pension and 401(k) plans, and a wide range of paid time off options.
• Join us in our team-led and leader-enabled hybrid model. Our expectation is for most people in external, client serving roles to work together in person 40-60% of the time over the course of an engagement, project or year.
• Under our flexible vacation policy, you’ll decide how much vacation time you need based on your own personal circumstances. You’ll also be granted time off for designated EY Paid Holidays, Winter/Summer breaks, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.

Are you ready to shape your future with confidence? Apply today.
EY accepts applications for this position on an on-going basis.

For those living in California, please click here for additional information.

EY focuses on high-ethical standards and integrity among its employees and expects all candidates to demonstrate these qualities.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, age, sex, sexual orientation, gender identity/expression, pregnancy, genetic information, national origin, protected veteran status, disability status, or any other legally protected basis, including arrest and conviction records, in accordance with applicable law. 

EY is committed to providing reasonable accommodation to qualified individuals with disabilities including veterans with disabilities. If you have a disability and either need assistance applying online or need to request an accommodation during any part of the application process, please call 1-800-EY-HELP3, select Option 2 for candidate related inquiries, then select Option 1 for candidate queries and finally select Option 2 for candidates with an inquiry which will route you to EY’s Talent Shared Services Team (TSS) or email the TSS at [email protected] .