Job Description [Power BI Sr. Eng.] – 4 to 6 years

• The Senior Power BI Engineer position is an integral part of the analytics & reporting team at Mercatus.

• The primary goal of the PBI resource is to support the existing team of PBI while learning and improving their existing analytics skills.

Power BI Developer Roles and Responsibilities:

• 3 to 6 years of relevant experience as a detail-oriented Business Intelligence or Data analyst Experience working with data visualization tools such as Power BI (Dashboard Layout / Formatting, DAX, Power Query) Perform DAX queries and functions in Power BI along with the transformation of data using POWER QUERY functions.

• Excellent in analytical thinking for translating data into informative visuals and reports Create relationships between data and develop tabular and other multidimensional data models Experience with data analysis using Excel and other tools.

• Experience working as part of a cross-functional team Familiarity with data warehouses and database concepts Eagerness to learn new topics and explore opportunities to identify and improve process inefficiencies.

• The ability to build strong relationships across the organization at all levels and are a team player Excellent communication and presentation skills, with the ability to translate sophisticated analytical concepts to a non-data-fluent audience.

• Good exposure to PBI REST APIs and power BI embed Good to have knowledge and skills in secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc.

• Able to implement row-level security on data and understand application security layer models in Power BI.

Person should have great knowledge and work experience of the tools and techniques below:

• Extensive hands-on experience on Power BI Desktop

• Data Modelling Power Query Transformation Fair Understanding of M-Query Create and Invoke Functions RLS Services Side Features Deployment Pipeline Share and Collaborate Features Power BI REST APIs Data Gateways

• Direct vs Import Data Storage Mode

• Should have good knowledge of data modelling techniques

• Should have a good understanding of the Performance analyzer using DAX studio

Good to know tools and skills:

SQL Query Writing ETL Understanding Power Automate MS Flow Power BI Report Builder OR SSRS

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement