Analytics Engineer - Senior Associate

The Power BI Engineer position is an integral part of the analytics & reporting team at CRPM. 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:

• 2 to 4 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 for 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
• Good to have experience on Power Automate and MS Flows

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

• 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

Good to know tools and skills:

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

State Street's Speak Up Line