Data Architecture & Engineering, Power BI - Manager - Financial Services

EY • Charlotte, NC

10d • $125,500 - $230,200 • Hybrid

About The Position

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.

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.

Requirements

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

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

Responsibilities

• 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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Manager