What are the responsibilities and job description for the Data Engineer / Business Intelligence Developer position at All Surfaces?

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, coupled with experience in developing custom applications using C#. You will be responsible for designing and implementing robust data pipelines, creating dynamic visualizations, and building applications to support business processes.

This position will work Hybrid out of our HQ in Bloomington, MN.

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.
Develop and maintain custom applications and tools using C# and the .NET framework.
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.

Proficiency in C# and the .NET framework, with the ability to develop and maintain custom applications.

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.

Apply for this job

Receive alerts for other Data Engineer / Business Intelligence Developer job openings

Data Engineer / Business Intelligence Developer

What are the responsibilities and job description for the Data Engineer / Business Intelligence Developer position at All Surfaces?

What is the career path for a Data Engineer / Business Intelligence Developer?

Job openings at All Surfaces

Not the job you're looking for? Here are some other Data Engineer / Business Intelligence Developer jobs in the Bloomington, MN area that may be a better fit.

We don't have any other Data Engineer / Business Intelligence Developer jobs in the Bloomington, MN area right now.

AI Assistant is available now!