ASC Engineered Solutions
Power BI Developer
ASC Engineered Solutions - Oak Brook, Illinois, United States, 60523
Work at ASC Engineered Solutions
Overview
- View job
Overview
Join to apply for the
Power BI Developer
role at
ASC Engineered Solutions Join to apply for the
Power BI Developer
role at
ASC Engineered Solutions Department:
Information Technology
Location:
Oak Brook, IL
Compensation:
$105,000 - $130,000 / year
Description
We are seeking a skilled and motivated
Power BI Developer
to join our Data & Analytics team. This role involves managing and optimizing our Power BI environment to support business intelligence and data analytics across the organization. You will collaborate with cross-functional teams, including technical and business units, to develop insightful data solutions that enhance data-driven decision-making.
How You Will Help
Report & Dashboard Development
Design and develop interactive, user-friendly Power BI dashboards and reports that provide actionable insights. Implement row-level security (RLS), DAX calculations, and performance optimization for efficient dashboard functionality. Lead BI projects from requirements gathering to deployment, ensuring alignment between business needs and technical execution. Build optimized data models (star/snowflake schemas) and integrate with diverse data sources, including Snowflake, SharePoint, D365 (CE/FO/BC), Azure, Microsoft One Lake, Microsoft Fabric (Lakehouse, Warehouse), SQL Server, and external APIs. Connect to and transform Dynamics 365 data (e.g., Dataverse, OData feeds, APIs) for analytics consumption in Power BI. Maintain and enhance existing dashboards, ensuring they meet current business needs.
Power BI Administration
Manage user access to Power BI resources, including workspaces, datasets, reports, and apps. Monitor and optimize Power BI and Fabric capacity for peak performance and efficient resource utilization. Enforce security policies, data governance standards, and best practices to maintain a secure and scalable Power BI and Fabric environment.
User Support & Engagement
Troubleshoot and resolve user access, security, connection, data errors, and report rendering issues. Investigate and clarify KPI and metric-related queries in existing dashboards. Provide continuous guidance and support to users, promoting self-service analytics adoption. Gather user feedback to ensure Power BI adapts to evolving organizational needs.
Training & Documentation
Develop and deliver training materials and workshops to educate users on Power BI capabilities. Create and maintain user documentation, including FAQs, how-to guides, and best practices for effective Power BI utilization. Document and promote modern data practices within Microsoft Fabric, including the usage of One Lake and workspace governance.
What You Will Bring
Excellent communication and collaboration skills to engage effectively with end-users, BI teams, and cross-functional stakeholders. Bachelors degree, in Computer Science, Information Technology, or a related field; advanced degree preferred. 5+ years of experience in Power BI development and administration. Strong proficiency in Power BI Desktop, Power BI Service, Power Query, DAX, and data gateway management. SQL expertise with experience working in Snowflake, Azure Synapse, AWS Redshift, or other cloud data warehouses. Solid understanding of data modeling, ETL processes, and data warehousing concepts. Strong problem-solving skills with keen attention to detail. Experience working with Microsoft Fabric, including Lakehouse, Data Warehouse, Data Factory, and Notebooks. Experience with Microsoft SSRS, Microsoft Copilot, Power Automate, and Power Apps is a plus. Familiarity with Direct Query and Import strategies for D365 data sources. Knowledge of Microsoft Fabric governance, security roles, and deployment of pipelines is a plus. Microsoft Power BI certification or related credentials are a plus. Prior experience in the manufacturing industry is a plus.
Compensation
The base salary range for this position is $105,000.00 - $130,000.00 USD annually*.
The salary range for this position reflects a reasonable estimate of the range of compensation for this role. ASC Engineered Solutions philosophy on compensation is based on careful consideration of additional factors such as (but not limited to) an individuals education, training, work experience, job-related skill set, location, and industry knowledge, as well as the scope and responsibilities of the position and market considerations. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Wholesale Building Materials Referrals increase your chances of interviewing at ASC Engineered Solutions by 2x Sign in to set job alerts for Business Intelligence Developer roles.
Business Intelligence Architect | BI Architect (W2 Only)
Chicago, IL $149,760.00-$216,320.00 1 month ago Chicago, IL $61,500.00-$162,500.00 3 weeks ago Chicago, IL $61,500.00-$162,500.00 1 month ago Oak Brook, IL $97,700.00-$184,175.00 6 days ago Sr. Mortgage Analytics Data Analyst (CHICAGO)
Business / Data Analyst (Assistant Vice President)
Chicago, IL $120,000.00-$185,000.00 1 week ago VP, Senior Commercial Business Intelligence Analyst
Chicago, IL $95,000.00-$105,000.00 1 week ago watsonx BI - Cognos: Delivery Consultant
Business Analyst/Enterprise Data Management
Senior Data Management Analyst, Statistical Reporting Team
Information Management Analyst, Data Enablement
Chicago, IL $90,000.00-$120,000.00 2 weeks ago Sr. Analyst, Global Supply Chain Data -- NA/LATAM
Oakbrook Terrace, IL $81,600.00-$108,900.00 4 days ago Senior Analyst, Data Integrity Procure to Pay
Chicago, IL $177,000.00-$208,000.00 1 week ago Business Analyst with Knowledge in Financial Data Exchange - FDX /DDA API .
Senior Data Security Analyst - Data Classification & Governance
Human Resources Information Systems HRIS Data Analyst II
Chicago, IL $95,000.00-$100,000.00 5 days ago Configuration/Data Management Analyst - R10198337
DoD Skillbridge Configuration/Data Management Analyst - R10198329
Chicago, IL $100,000.00-$150,000.00 7 hours ago Senior Business Analyst / Business Data Analyst
Chicago, IL $132,500.00-$302,400.00 1 week ago Technology Senior Manager, Insurance Advisory
Chicago, IL $170,000.00-$215,000.00 6 days ago Chicago, IL $104,832.00-$142,272.00 1 month ago Business Intelligence Developer (BI Developer)
Chicago, IL $100,000.00-$130,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Power BI Developer
role at
ASC Engineered Solutions Join to apply for the
Power BI Developer
role at
ASC Engineered Solutions Department:
Information Technology
Location:
Oak Brook, IL
Compensation:
$105,000 - $130,000 / year
Description
We are seeking a skilled and motivated
Power BI Developer
to join our Data & Analytics team. This role involves managing and optimizing our Power BI environment to support business intelligence and data analytics across the organization. You will collaborate with cross-functional teams, including technical and business units, to develop insightful data solutions that enhance data-driven decision-making.
How You Will Help
Report & Dashboard Development
Design and develop interactive, user-friendly Power BI dashboards and reports that provide actionable insights. Implement row-level security (RLS), DAX calculations, and performance optimization for efficient dashboard functionality. Lead BI projects from requirements gathering to deployment, ensuring alignment between business needs and technical execution. Build optimized data models (star/snowflake schemas) and integrate with diverse data sources, including Snowflake, SharePoint, D365 (CE/FO/BC), Azure, Microsoft One Lake, Microsoft Fabric (Lakehouse, Warehouse), SQL Server, and external APIs. Connect to and transform Dynamics 365 data (e.g., Dataverse, OData feeds, APIs) for analytics consumption in Power BI. Maintain and enhance existing dashboards, ensuring they meet current business needs.
Power BI Administration
Manage user access to Power BI resources, including workspaces, datasets, reports, and apps. Monitor and optimize Power BI and Fabric capacity for peak performance and efficient resource utilization. Enforce security policies, data governance standards, and best practices to maintain a secure and scalable Power BI and Fabric environment.
User Support & Engagement
Troubleshoot and resolve user access, security, connection, data errors, and report rendering issues. Investigate and clarify KPI and metric-related queries in existing dashboards. Provide continuous guidance and support to users, promoting self-service analytics adoption. Gather user feedback to ensure Power BI adapts to evolving organizational needs.
Training & Documentation
Develop and deliver training materials and workshops to educate users on Power BI capabilities. Create and maintain user documentation, including FAQs, how-to guides, and best practices for effective Power BI utilization. Document and promote modern data practices within Microsoft Fabric, including the usage of One Lake and workspace governance.
What You Will Bring
Excellent communication and collaboration skills to engage effectively with end-users, BI teams, and cross-functional stakeholders. Bachelors degree, in Computer Science, Information Technology, or a related field; advanced degree preferred. 5+ years of experience in Power BI development and administration. Strong proficiency in Power BI Desktop, Power BI Service, Power Query, DAX, and data gateway management. SQL expertise with experience working in Snowflake, Azure Synapse, AWS Redshift, or other cloud data warehouses. Solid understanding of data modeling, ETL processes, and data warehousing concepts. Strong problem-solving skills with keen attention to detail. Experience working with Microsoft Fabric, including Lakehouse, Data Warehouse, Data Factory, and Notebooks. Experience with Microsoft SSRS, Microsoft Copilot, Power Automate, and Power Apps is a plus. Familiarity with Direct Query and Import strategies for D365 data sources. Knowledge of Microsoft Fabric governance, security roles, and deployment of pipelines is a plus. Microsoft Power BI certification or related credentials are a plus. Prior experience in the manufacturing industry is a plus.
Compensation
The base salary range for this position is $105,000.00 - $130,000.00 USD annually*.
The salary range for this position reflects a reasonable estimate of the range of compensation for this role. ASC Engineered Solutions philosophy on compensation is based on careful consideration of additional factors such as (but not limited to) an individuals education, training, work experience, job-related skill set, location, and industry knowledge, as well as the scope and responsibilities of the position and market considerations. Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Wholesale Building Materials Referrals increase your chances of interviewing at ASC Engineered Solutions by 2x Sign in to set job alerts for Business Intelligence Developer roles.
Business Intelligence Architect | BI Architect (W2 Only)
Chicago, IL $149,760.00-$216,320.00 1 month ago Chicago, IL $61,500.00-$162,500.00 3 weeks ago Chicago, IL $61,500.00-$162,500.00 1 month ago Oak Brook, IL $97,700.00-$184,175.00 6 days ago Sr. Mortgage Analytics Data Analyst (CHICAGO)
Business / Data Analyst (Assistant Vice President)
Chicago, IL $120,000.00-$185,000.00 1 week ago VP, Senior Commercial Business Intelligence Analyst
Chicago, IL $95,000.00-$105,000.00 1 week ago watsonx BI - Cognos: Delivery Consultant
Business Analyst/Enterprise Data Management
Senior Data Management Analyst, Statistical Reporting Team
Information Management Analyst, Data Enablement
Chicago, IL $90,000.00-$120,000.00 2 weeks ago Sr. Analyst, Global Supply Chain Data -- NA/LATAM
Oakbrook Terrace, IL $81,600.00-$108,900.00 4 days ago Senior Analyst, Data Integrity Procure to Pay
Chicago, IL $177,000.00-$208,000.00 1 week ago Business Analyst with Knowledge in Financial Data Exchange - FDX /DDA API .
Senior Data Security Analyst - Data Classification & Governance
Human Resources Information Systems HRIS Data Analyst II
Chicago, IL $95,000.00-$100,000.00 5 days ago Configuration/Data Management Analyst - R10198337
DoD Skillbridge Configuration/Data Management Analyst - R10198329
Chicago, IL $100,000.00-$150,000.00 7 hours ago Senior Business Analyst / Business Data Analyst
Chicago, IL $132,500.00-$302,400.00 1 week ago Technology Senior Manager, Insurance Advisory
Chicago, IL $170,000.00-$215,000.00 6 days ago Chicago, IL $104,832.00-$142,272.00 1 month ago Business Intelligence Developer (BI Developer)
Chicago, IL $100,000.00-$130,000.00 2 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr