BI Developer

Overview

Hybrid
Depends on Experience
Contract - W2
75% Travel

Skills

Business Intelligence
DAX
Dashboard
Data Analysis
Microsoft Power BI
Microsoft Azure
SQL
Reporting
Python
R
Microsoft SSIS
Microsoft SQL Server
Database

Job Details

Job Title: BI Developer

Location: Cincinnati, OH (Hybrid)

Employment Type: W2 Contract Only (NO C2C)

Duration: 12+ Months

Job Summary

We are looking for an experienced BI Developer to design, develop, and maintain data analytics solutions, interactive dashboards, and reporting systems. The ideal candidate will have strong expertise in SQL, data modeling, ETL processes, and BI tools (Power BI, Tableau, or Looker). You will work closely with business stakeholders to transform raw data into actionable insights that drive decision-making.

Key Responsibilities

  • Develop interactive dashboards, reports, and visualizations using Power BI, Tableau, or Looker.
  • Write complex SQL queries for data extraction, transformation, and analysis.
  • Perform data profiling, cleansing, and validation to ensure accuracy.
  • Optimize report performance for large datasets.
  • Design and maintain ETL processes (SSIS, Azure Data Factory, or similar).
  • Extract data from SQL databases, APIs, or cloud data warehouses (BigQuery, Snowflake, Redshift).
  • Implement incremental data loads and automate refreshes.
  • Design star/snowflake schemas for efficient reporting.
  • Optimize data models for BI tools (Power BI datasets, Tableau extracts).
  • Work with Dimensional Modeling (Kimball methodology).
  • Translate business requirements into technical BI solutions.
  • Train end-users on self-service BI tools.
  • Document data definitions, report logic, and ETL workflows.
  • Optimize SQL queries, DAX measures, and report rendering.
  • Monitor and improve dashboard load times.

Qualifications:

  • 10+ years of exeprience in BI development, data analysis, or reporting.
  • BI Tools Expertise: Proficiency in Power BI (DAX, Power Query), Tableau, or Looker.
  • SQL Expertise: Advanced querying skills, including joins, common table expressions (CTEs), and window functions.
  • ETL Expertise: Experience with ETL tools such as SSIS, Azure Data Factory, or similar.
  • Data Warehousing Expertise: Knowledge of data warehousing platforms like Snowflake, BigQuery, Redshift, or SQL Server.
  • Data Modeling Skills: Strong skills in dimensional modeling and normalization.
  • Methodologies: Experience with Agile/Scrum methodologies.
  • Education: Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.

Nice to Have

  • Power BI Premium/Service or Tableau Server administration.
  • Knowledge of Python/R for advanced analytics.
  • Cloud experience (Azure, AWS, Google Cloud Platform).
  • Certifications (Microsoft PL-300, Tableau Certified Associate).

 

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.