Power BI Analyst

$67,000 - $86,000/Yr

CHA Consulting - Albany, NY

Full-time

Albany, NY

Heavy and Civil Engineering Construction

About the position

The Power BI Analyst at CHA Consulting, Inc. is responsible for designing, developing, and maintaining Power BI dashboards and reports that align with business requirements. This role involves implementing row-level security on data, understanding application security layer models for Power BI, and leveraging Microsoft Fabric to enhance dashboard deployment and functionality. The analyst will collaborate with stakeholders to assess business needs, optimize existing BI systems, and document all reports and data models thoroughly. Additionally, they will assist in training users on BI reports and dashboards, contributing to enhanced data analytics capabilities and driving business success.

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports that meet business requirements.
• Implement row-level security on data and understand application security layer models for Power BI.
• Leverage Microsoft Fabric to enhance the deployment and functionality of dashboards.
• Develop DAX queries and calculations to ensure reports deliver meaningful insights.
• Collaborate with stakeholders to assess business needs and provide data-driven solutions.
• Optimize existing BI systems for performance and scalability.
• Document all reports, dashboards, and data models thoroughly for clarity and accessibility.
• Assist with training users on BI reports and dashboard releases.

Requirements

• Bachelor's degree from an accredited college/university in Data Science, Data Analytics, Computer Science, or related fields.
• Minimum of 5 years of progressive experience with computer applications programming and developing software applications.
• Minimum of 2 years recent experience in Power BI Development or Data Analytics.
• Ability to problem solve effectively and detail-oriented.
• Proficient in SQL and data model techniques; experience with DAX is a plus.
• Prior experience working in a Professional Services firm and with Deltek Vision is a plus.
• Expertise working with data lakes, data warehouses, relational databases, and data modeling techniques; experience with Microsoft Fabric and Azure Data Factory is a plus.
• Ability to interpret business requirements and translate them into technical requirements.
• Familiarity with other BI tools such as Tableau and data visualization best practices.

Nice-to-haves

• Experience with DAX queries and calculations.
• Familiarity with Deltek Vision.
• Experience with Microsoft Fabric and Azure Data Factory.
• Knowledge of data visualization best practices.

Benefits

• Competitive salary range of $67,000 - $86,000 based on qualifications and experience.