Epicor Data Warehouse Developer

Our client is seeking an experienced Epicor Data Warehouse Developer to support enterprise reporting analytics and data integration initiatives across nine business units. The organization currently operates Epicor ERP 10 (on-premise) and is preparing for a future migration to Epicor Kinetic Cloud creating an exciting opportunity to help shape the companys data architecture and analytics strategy.

This role will be responsible for designing and maintaining data warehouse solutions developing Power BI reporting and dashboards building ETL processes supporting enterprise integrations and enabling data-driven decision making across the organization. The ideal candidate combines strong technical expertise with the ability to collaborate closely with business stakeholders and IT teams.

Key Responsibilities

Data Warehouse Development & Architecture

• Design develop and maintain enterprise data warehouse solutions supporting multiple business units.
• Create scalable data models that support reporting analytics and business intelligence initiatives.
• Develop and optimize data structures dimensional models and data marts.
• Ensure data quality integrity governance and consistency across enterprise systems.
• Support ongoing modernization efforts as the organization transitions to cloud-based platforms.

Power BI Development & Analytics

• Design and develop interactive Power BI dashboards reports and executive scorecards.
• Create advanced DAX calculations KPIs measures and performance metrics.
• Develop self-service reporting solutions for business users.
• Partner with leadership and functional teams to identify reporting and analytics requirements.
• Optimize Power BI performance and data refresh processes.

ETL & Data Integration

• Develop and maintain Talend ETL processes and data pipelines.
• Design and support integrations between Epicor ERP Salesforce and other enterprise applications.
• Build automated workflows to move transform and validate data across systems.
• Troubleshoot integration issues and improve data reliability and performance.
• Support API development and integration strategies.

Epicor ERP & Data Management

• Develop solutions leveraging Epicor ERP data structures and business processes.
• Create and optimize SQL queries views and datasets supporting reporting initiatives.
• Support data extraction transformation and reporting requirements for Epicor ERP.
• Collaborate with ERP administrators and developers on enterprise reporting and analytics projects.
• Assist with future Epicor Kinetic Cloud reporting and data architecture initiatives.

Data Migration & Conversion Projects

• Participate in data migration and conversion efforts related to ERP upgrades and cloud initiatives.
• Perform data cleansing validation transformation and reconciliation activities.
• Develop migration processes and tools to ensure data accuracy and completeness.
• Support testing and post-migration validation efforts.

Cloud Data Strategy

• Support cloud data platform initiatives and modernization efforts.
• Assist in defining API strategies and enterprise integration standards.
• Contribute to cloud reporting analytics and data governance initiatives.
• Evaluate emerging technologies and recommend improvements to enterprise data architecture.

Required Qualifications

• 3 years of experience in data warehouse development business intelligence or data engineering.
• Experience designing and supporting enterprise data warehouse architectures.
• Strong Power BI development experience including advanced DAX and data modeling.
• Hands-on Talend ETL development experience.
• Strong SQL Server and T-SQL development skills.
• Experience integrating data from ERP CRM and third-party business applications.
• Experience with data migration conversion and validation projects.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.

Preferred Qualifications

• Experience working with Epicor ERP 10 and/or Epicor Kinetic data structures.
• Experience supporting manufacturing and distribution organizations.
• Experience integrating Salesforce with ERP and enterprise applications.
• Knowledge of REST APIs and enterprise integration architecture.
• Experience with Azure Microsoft Fabric Data Lake or other cloud data platforms.
• Understanding of data governance master data management and data quality frameworks.
• Experience supporting multi-business-unit environments.

Technical Skills

Required

• Epicor ERP 10 / Kinetic

• Power BI
• Advanced DAX
• Talend ETL
• SQL Server
• T-SQL
• Data Warehouse Design
• Data Modeling
• Data Integration
• Data Migration & Conversion

Preferred

• Salesforce
• REST APIs
• Azure Data Services
• Microsoft Fabric
• Data Lake Technologies
• SSIS
• Python or Data Automation Tools
• Cloud Analytics Platforms

Desired Soft Skills

• Strong communicator capable of working with both technical and business stakeholders.
• Team-oriented and collaborative mindset.
• Ability to translate business requirements into scalable data solutions.
• Self-motivated with strong organizational and prioritization skills.
• Passion for analytics process improvement and data-driven decision making.