Senior Epicor & PowerBi Developer

Overview:

We are seeking a highly experienced Senior Epicor & Power BI Developer (remote opportunity) with a strong background in ERP development and data analytics. The successful candidate will be responsible for delivering robust, scalable solutions within the Epicor ERP environment and building advanced Power BI reporting frameworks to drive data-led decision-making across the business.

This role requires hands-on expertise in ERP customisation, integration, SQL development, and business intelligence, with a strong focus on technical execution and system optimisation.

Key Responsibilities:

Epicor ERP Development:

• Design, develop, and support customisations in Epicor ERP (preferably Epicor Kinetic or v10+), including:

• BAQs (Business Activity Queries)

• BPMs (Business Process Management workflows)

• User-Defined Tables (UDTs) & Fields

• Custom Forms, Dashboards, and Embedded Queries

• SSRS report development

• Develop and maintain Epicor data integrations using REST API, Service Connect, and/or external middleware tools.

• Implement system enhancements, data workflows, and automation to improve efficiency across modules such as Manufacturing, Finance, Inventory, Sales, and Purchasing.

• Perform technical root cause analysis and troubleshoot system and data-related issues.

• Support system upgrades and patch testing with a focus on regression testing and customisation integrity.

• Maintain detailed technical documentation for all developments, configurations, and integrations.

  Power BI Development:

  • Design and develop Power BI solutions, including:

  • Data models, relationships, and calculated columns/measures using DAX

  • Power Query (M) scripting for data transformation

  • Interactive reports and dashboards tailored to department-specific KPIs

• Connect Power BI to Epicor and other enterprise systems (e.g., SQL Server, flat files, REST APIs).

• Implement row-level security, parameterised reports, and dynamic visualisation techniques.

• Optimise report performance through data reduction strategies and query tuning.

  Database & Integration Work:

  • Write and optimise SQL Server scripts, stored procedures, views, and functions to support reporting, automation, and integrations.

  • Design and manage ETL processes for structured data flows across systems.

  • Maintain and troubleshoot data integrity and performance across transactional and reporting databases.

  • Implement version control, deployment pipelines, and test procedures where appropriate.

  Skills & Experience Required:

  • 7+ years of hands-on development experience with Epicor ERP or other Tier II ERP systems (e.g., Infor, IFS, SYSPRO, Dynamics).

  • Advanced knowledge of:

  • Epicor data architecture and module interdependencies

  • BAQs, BPMs, UD methods, SSRS reporting, and dashboard development

  • SQL Server (T-SQL) for querying, performance tuning, and stored procedure creation

• Extensive experience developing in Microsoft Power BI, including:

• DAX and Power Query (M)

• Advanced data modelling techniques

• Designing intuitive and performant dashboards for end users

• Proficient in using Epicor REST API, JSON/XML structures, and web services for system integrations.

• Familiarity with .NET / C# programming for Epicor customisation (desirable but not essential).

• Comfortable with data warehousing concepts, ETL pipelines, and working with complex data sources.

• Experience working in structured development environments, with change control and documentation best practices.

  Qualifications:

  • Degree in Computer Science, Information Systems, Engineering, or equivalent practical experience.

  • Microsoft certifications in Power BI or SQL (desirable).

  • Epicor Technical Certification or Epicor ERP training (preferred).