Business Intelligence Analyst

The Ascent Group LLC

$80K — $110K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Business Analytics, or 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, including Power Query, DAX, Power BI Service, and Dataflows
  • Strong SQL skills and data modeling knowledge (star/snowflake schemas)
  • Hands-on experience with cloud-based and on-prem data platforms like Azure Synapse and SQL Server
  • Familiarity with ETL processes and tools such as SSIS and ADF
  • Strong analytical, critical thinking, and communication skills

Responsibilities

  • Collaborate with stakeholders to define business data requirements
  • Design and document data models and business logic in Data Warehouses
  • Build and maintain interactive dashboards, reports, and visualizations in Power BI
  • Translate business questions into SQL and DAX queries
  • Profile, cleanse, and validate data for quality assurance
  • Develop KPIs and performance metrics to support business objectives
  • Automate reporting processes to enhance efficiency

Benefits

  • Opportunity to work in a collaborative environment
  • Chance to develop technical skills with Power BI and SQL
  • Engagement with diverse stakeholders across the business
  • Opportunity for professional growth in a data-driven landscape
  • Gain experience with both cloud and on-premises data solutions
Full Job Description
Title : Business Intelligence Analyst - Contractor
Must be authorized to work in the U.S. without sponsorship
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.
Requirements
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). Strong analytical and critical thinking skills. Excellent communication and stakeholder management skills.

Similar Jobs

More Information Technology Jobs

Find similar Business Intelligence Analyst jobs: