What are the responsibilities and job description for the Power BI Analyst - Hartford, CT (Hybrid 1x ) position at MetaSense, Inc.?
About the Role
We are seeking (1) skilled Power BI Analyst. The Power BI Analyst will work with the Information Technology (IT) development team, in collaboration with Business Analysts, Quality Assurance Testers, Trainers, and the Production Support Information Technology team.
The Power BI Analyst will design, build, and manage data models, interactive dashboards, and reports in Power BI to turn raw data into clear business insights and analyses that support leadership in evaluating key performance metrics, modeling behaviors, and data.
Core Technical Skills
· Power BI proficiency: Ability to use Power BI Desktop and Service to clean, transform, and model data.
· DAX (Data Analysis Expressions): Master this formula language to build custom calculated columns, measures, totals, and complex filters.
· Power Query & ETL: Use Power Query to extract, transform, and clean raw data from multiple sources before loading it into your model.
· Data Modeling: Design relational schemas, connect data sources, and configure star schemas with proper fact and dimension tables.
· SQL & Excel: Write database queries in SQL and leverage Excel for preliminary data manipulation and fast ad hoc analysis.
Education and Experience
· A bachelor’s degree in a quantitative field; 2 or more years of data analysis experience, and strong technical proficiency in SQL, DAX, and data modeling.
· Generally, 2 years of prior experience in business intelligence, data analys8is or report writing.
· Supplementary tools: Familiarity with Excel, Python, or R for advanced data manipulation.
· Data preparation: Experience with Power Query M transformation and building star.