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

Ernst & Young LLP
New York, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 230K

Job location

New York, United States of America

Tech stack

Amazon Web Services (AWS)
Data analysis
Continuous Integration
Data Architecture
Data Warehousing
DevOps
Performance Tuning
Presentation Programs
Systems Development Life Cycle
Power BI
Parquet
Scripting (Bash/Python/Go/Ruby)
Delivery Pipeline
Snowflake
Powerquery
Microsoft Fabric
Semi-structured Data
Information Technology
Star Schema
Azure
Databricks

Requirements

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., * 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

Benefits & conditions

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.

About the company

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

Apply for this position