Sign upLog in

Epicor Data Warehouse Developer

GTN Technical Staffing

Boston, MA

Apply
JOB DETAILS
SKILLS
Analysis Skills, Application Programming Interface (API), Architectural Analysis, Automation, Business Intelligence, Business Processes, Business Skills, Business Solutions, Business Support, Cloud Computing, Communication Skills, Customer Relationship Management (CRM), Data Analysis, Data Lake, Data Management, Data Mart, Data Migration, Data Modeling, Data Processing, Data Quality, Data Sets, Data Structures, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Distribution Services, ERP (Enterprise Resource Planning), Emerging Technology, Enterprise Applications, Enterprise Architecture, Enterprise Data Integration, Establish Priorities, Identify Issues, Leadership, Master Data Management (MDM), Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Organizational Skills, Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Process Development, Process Improvement, Python Programming/Scripting Language, Query Optimization, REST (Representational State Transfer), Reconciliation, Reliability Engineering, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Salesforce.com, Scorecarding, System Validation, Team Player, Warehousing
LOCATION
Boston, MA
POSTED
23 days ago

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.

About the Company

G

GTN Technical Staffing

Resume Resources

Free Resume TemplatesFree Resume Builder