Business Intelligence Analyst

Overview

On Site
$65 - $80 per hour
Contract - W2

Skills

Business Intelligence Analyst

Job Details



Job Title: Business Intelligence Analyst

Job Location: Marlborough MA 01752

Onsite Requirements: Hybrid



  • 3+ years of experience in Business Analysis or BI roles, with a focus on Data Warehousing and Power BI.

  • Proficient in Power BI (Power Query, DAX, Power BI Service, and Dataflows).

  • Strong SQL skills and understanding of data modeling (star/snowflake schemas).


Job Description:

Responsibilities:



  • Collaborate with stakeholders to gather and understand business data requirements.

  • Design, document, and validate data models and business logic within Data Warehouses.

  • Build and maintain interactive dashboards, reports, and visualizations in Power BI.

  • Translate business questions into technical queries using DAX and SQL.

  • Perform data profiling, cleansing, and validation to ensure high data quality.

  • Develop KPIs, metrics, and performance indicators aligned with business goals.

  • Automate reporting and analysis processes to increase efficiency and accuracy.

  • Conduct user training and provide ongoing support for Power BI users.

  • Work closely with data engineers and architects to ensure optimal data structure and ETL performance.

  • Monitor and troubleshoot data refresh issues and data integrity concerns in Power BI Service.


Required Qualifications:



  • Bachelor's degree in computer science, Information Systems, Business Analytics, or a related field.

  • 3+ years of experience in Business Analysis or BI roles, with a focus on Data Warehousing and Power BI.

  • Proficient in Power BI (Power Query, DAX, Power BI Service, and Dataflows).

  • Strong SQL skills and understanding of data modeling (star/snowflake schemas).

  • Hands-on experience working with cloud-based and on-prem data platforms (e.g., Azure Synapse, SQL Server or similar).

  • Knowledge of ETL processes and tools (SSIS, ADF, or similar)




  • **3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply.

  • This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future**

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.