All Surfaces
Data Engineer / Business Intelligence Developer
All Surfaces, Bloomington, Minnesota, United States
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 can work out of our Bloomington, MN HQ or remotely in the central and/or east coast time zones.
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.
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 can work out of our Bloomington, MN HQ or remotely in the central and/or east coast time zones.
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.