Search Open Jobs
All GTN W2 consultants get full benefits. Learn more.
Epicor Data Warehouse Developer
Posted: 06/16/2026
Employment Type:
Direct Hire
Job Number: 28135
Pay Rate: $110000 - $125000
Remote Friendly?: Fully Remote (can be located anywhere)
Job Description
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 company's 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 ResponsibilitiesData 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Epicor ERP 10 / Kinetic
- Power BI
- Advanced DAX
- Talend ETL
- SQL Server
- T-SQL
- Data Warehouse Design
- Data Modeling
- Data Integration
- Data Migration & Conversion
- Salesforce
- REST APIs
- Azure Data Services
- Microsoft Fabric
- Data Lake Technologies
- SSIS
- Python or Data Automation Tools
- Cloud Analytics Platforms
- 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.
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Boston, MA
Ready to take your career to new heights? Explore our job opportunities in the vibrant Boston, Massachusetts area! Known for its rich history, world-class universities, and thriving tech and healthcare sectors, Boston offers a unique blend of opportunity and charm. Imagine working near iconic landmarks like the Freedom Trail, indulging in delicious clam chowder, catching a show at the Boston Opera House, or cheering on the beloved Red Sox at Fenway Park. With renowned art galleries, theaters, and the stunning Boston Common right at your doorstep, there’s no shortage of ways to enjoy work-life balance in this dynamic city. Discover your next career move in Boston today!