Business Intelligence (BI) Developer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Business Intelligence (BI) Developer with a 6-month contract, offering a pay rate of "$XX/hour". Required skills include 5+ years in BI development using Kimball methodology, Power BI, T-SQL, and Azure services. A Bachelor's degree in Computer Science is mandatory.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
August 16, 2025
🕒 - Project duration
Unknown
-
🏝️ - Location type
Unknown
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
Villa Park, IL
-
🧠 - Skills detailed
#Dimensional Data Models #Data Warehouse #Documentation #SQL Queries #Data Modeling #EDW (Enterprise Data Warehouse) #Azure #Computer Science #Data Lake #Datasets #Big Data #Scala #DAX #Synapse #Microsoft Power BI #"ETL (Extract #Transform #Load)" #SSIS (SQL Server Integration Services) #Data Bricks #Data Pipeline #Data Extraction #SQL (Structured Query Language) #BI (Business Intelligence)
Role description
Job Description
Responsibilities
• Design and build relational and dimensional data models using the Kimball methodology, including hierarchies.
• Develop and maintain Power BI reports, dashboards, and datasets with advanced DAX and Tabular models.
• Create and manage data pipelines in Azure to move data from Data Lakes to Azure Synapse.
• Write and optimize T-SQL queries for ETL processes and reporting.
• Use SSIS for data extraction and integration into the Enterprise Data Warehouse (EDW).
• Collaborate with stakeholders to translate reporting requirements into BI solutions.
• Optimize BI solutions for performance and scalability.
• Maintain documentation of data models, ETL processes, and reporting structures.
Requirements
• 5+ years of experience in data modeling and BI development using Kimball methodology.
• 4+ years of hands-on experience with Power BI and DAX.
• Strong knowledge of Azure services (Synapse, Data Lake) and data pipelines.
• 5+ years of experience with T-SQL and SSIS for ETL processes.
• Ability to design Tabular models in Power BI Premium.
• Experience working with an Enterprise Data Warehouse.
• Bachelor's degree in Computer Science or a related field.
Preferred
• Familiarity with Data Bricks or other big data tools.
Job Description
Responsibilities
• Design and build relational and dimensional data models using the Kimball methodology, including hierarchies.
• Develop and maintain Power BI reports, dashboards, and datasets with advanced DAX and Tabular models.
• Create and manage data pipelines in Azure to move data from Data Lakes to Azure Synapse.
• Write and optimize T-SQL queries for ETL processes and reporting.
• Use SSIS for data extraction and integration into the Enterprise Data Warehouse (EDW).
• Collaborate with stakeholders to translate reporting requirements into BI solutions.
• Optimize BI solutions for performance and scalability.
• Maintain documentation of data models, ETL processes, and reporting structures.
Requirements
• 5+ years of experience in data modeling and BI development using Kimball methodology.
• 4+ years of hands-on experience with Power BI and DAX.
• Strong knowledge of Azure services (Synapse, Data Lake) and data pipelines.
• 5+ years of experience with T-SQL and SSIS for ETL processes.
• Ability to design Tabular models in Power BI Premium.
• Experience working with an Enterprise Data Warehouse.
• Bachelor's degree in Computer Science or a related field.
Preferred
• Familiarity with Data Bricks or other big data tools.
