Senior Analytics Engineer, Emerging Leader

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