Sign upLog in
See more jobs

Epicor Data Warehouse Developer

GTN Technical Staffing
  • Boston, MA
  • Quick Apply
30+ days ago

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.
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 SkillsRequired
  • 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.

Numbers & Facts

LocationBoston, MA

Skills

  • Analysis Skillsunmatched
  • Application Programming Interface (API)unmatched
  • Architectural Analysisunmatched
  • Automationunmatched
  • Business Intelligenceunmatched
  • Business Processesunmatched
  • Business Skillsunmatched
  • Business Solutionsunmatched
  • Business Supportunmatched
  • Cloud Computingunmatched
  • Communication Skillsunmatched
  • Customer Relationship Management (CRM)unmatched
  • Data Analysisunmatched
  • Data Lakeunmatched
  • Data Managementunmatched
  • Data Martunmatched
  • Data Migrationunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Setsunmatched
  • Data Structuresunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Dimensional Modelingunmatched
  • Distribution Servicesunmatched
  • ERP (Enterprise Resource Planning)unmatched
  • Emerging Technologyunmatched
  • Enterprise Applicationsunmatched
  • Enterprise Architectureunmatched
  • Enterprise Data Integrationunmatched
  • Establish Prioritiesunmatched
  • Identify Issuesunmatched
  • Leadershipunmatched
  • Master Data Management (MDM)unmatched
  • Microsoft Product Familyunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Transact-SQL (T-SQL)unmatched
  • Microsoft Windows Azureunmatched
  • Organizational Skillsunmatched
  • Performance Metricsunmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Problem Solving Skillsunmatched
  • Process Developmentunmatched
  • Process Improvementunmatched
  • Python Programming/Scripting Languageunmatched
  • Query Optimizationunmatched
  • REST (Representational State Transfer)unmatched
  • Reconciliationunmatched
  • Reliability Engineeringunmatched
  • Reporting Dashboardsunmatched
  • Requirements Managementunmatched
  • SQL (Structured Query Language)unmatched
  • SQL Server Integration Services (SSIS)unmatched
  • Salesforce.comunmatched
  • Scorecardingunmatched
  • System Validationunmatched
  • Team Playerunmatched
  • Warehousingunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder