Data Engineer/ Power BI Developer

Job Description

Job Title: Data Engineer / Power BI Developer


Location: Hybrid, Bloomington, MN

Job Summary


The Data Engineer / Business Intelligence Developer collaborates with users and IT team members to design, customize, implement, and maintain solutions around the Epicor Prophet 21 (P21) platform and supporting IIS Web Apps.

We are seeking a skilled and detail-oriented Data Engineer / Business Intelligence Developer with expertise in data integration, reporting, and visualization. The ideal candidate will have a strong SSRS, SSIS, SQL, and Power BI background. You will be responsible for designing and implementing robust data pipelines, creating dynamic visualizations, and building applications to support business processes.

Key Responsibilities


Design, develop, and deploy insightful reports and dashboards using Power BI and SQL Server Reporting Services (SSRS).


Develop and maintain ETL pipelines using SQL Server Integration Services (SSIS) to streamline data integration and transformation.


Write, optimize, and troubleshoot complex SQL queries, stored procedures, and database solutions for data analysis and application support.


Collaborate with stakeholders to understand reporting and data visualization requirements, ensuring solutions meet business needs.


Design interactive and visually compelling dashboards in Power BI, leveraging DAX and Power Query for advanced functionality.


Monitor, troubleshoot, and optimize the performance of databases, ETL pipelines, and Power BI solutions.


Ensure data accuracy, integrity, and security in all reporting and analytics workflows.


Stay current with advancements in Power BI, SQL Server, and other data technologies, recommending improvements as necessary.


Technical Support

Provide end-user support and troubleshooting of issues related to the P21 ERP system, ensuring timely and effective resolution and identifying proactive measures to prevent future issues.


Collaborate with other team members to provide escalated support and troubleshooting assistance.

Qualifications


4+ years of experience in SSRS, SSIS, advanced SQL development, and Power BI.


Bachelor's degree in Computer Science, Information Systems, or a related field.


Strong knowledge of Power BI development, including DAX, Power Query, and data modeling best practices.


Experience with relational databases, preferably Microsoft SQL Server.


Ability to analyze and transform data into actionable insights and visually compelling dashboards.


Familiarity with data warehousing concepts and BI tools.


Excellent analytical, problem-solving, and communication skills for collaborating with technical and business teams.


Qualifications


Experience in cloud-based data platforms (e.g., Azure Data Factory, Azure SQL, or Power BI Service).


Knowledge of Power BI governance, workspace management, and row-level security (RLS).


Knowledge of Software Development Lifecycle (SDLC) and methodologies such as Waterfall and Agile.


Familiar with Epicor Prophet 21 (P21) is a plus.


Critical Success Factors:


Highly motivated, self-directed, and results-driven with the ability to work independently and manage multiple tasks and priorities


Strong problem-solving skills, including demonstrated ability to analyze issues and to work effectively with cross-functional groups to craft solutions


Curiosity and passion for delivering high-quality and innovative technical solutions


The projected hourly range for this position is $60/Hour - $75/Hour.

On-Demand Group (ODG) provides employee benefits, including healthcare, dental, and vision insurance. ODG is an equal opportunity employer that does not discriminate based on , , , , , , , , or any other characteristic protected by law.