Business Intelligence Developer

On-Demand Group is currently seeking for a Data Engineer / Business Intelligence Developer for a 3-month contract engagement to start.

Title: Data Engineer / Business Intelligence Developer

Duration: 3 months contract

Location Remote

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 background in SSRS, SSIS, SQL, and Power BI. 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.

Preferred 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) 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 $50 to $60.

On-Demand Group (ODG) provides employee benefits which includes healthcare, dental, and vision insurance. ODG is an equal opportunity employer that does not discriminate on the basis of race, color, religion, gender, sexual orientation, age, national origin, disability, or any other characteristic protected by law.