What are the responsibilities and job description for the Data Engineer/ Power BI Developer position at On-Demand Group?
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.
Qualifications
Preferred Qualifications
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 race, color, religion, gender, sexual orientation, age, national origin, disability, or any other characteristic protected by law.
Salary : $60 - $75