Back to Remote jobs >
Data Analysis
ETL/ELT Data Integration Engineer
@McFadyen Digital
[Hiring] ETL/ELT Data Integration Engineer @McFadyen Digital
Apr 01, 2025 - McFadyen Digital is hiring a remote ETL/ELT Data Integration Engineer. 💸 Salary: unspecified. 📍Location: Northern America, Americas, India.
This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.
Role Description
McFadyen Digital is seeking an experienced ETL Integration Engineer to design, build, and optimize data pipelines that support our eCommerce marketplace solutions. This role will be responsible for integrating multi-source data from ERP, CRM, PIM, and eCommerce platforms into cloud-based data warehouses and analytics tools. The ideal candidate will have expertise in ETL/ELT processes, data modeling, and cloud platforms such as AWS, Azure, Google Cloud, and Snowflake.
The ETL Integration Engineer will collaborate closely with data architects, engineers, and analysts to ensure data integrity, security, and efficiency in large-scale commerce-driven data environments.
Responsibilities
- Data Pipeline Development & Maintenance
- System & API Integration
- Data Synchronization & Orchestration
- Data Consistency & Integrity Assurance
- Performance Monitoring & Optimization
Additional Responsibilities:
- Design, develop, test, and optimize ETL/ELT workflows for data ingestion, transformation, and delivery.
- Implement real-time and batch processing pipelines for efficient data movement.
- Integrate APIs and external vendor systems with TSN data services.
- Support data exchange between ERP platforms (SAP, Oracle) and third-party applications.
- Implement bi-directional data sync processes to ensure accurate data flow between interconnected systems.
- Develop workflow automation for streamlined data orchestration.
- Enforce data validation, error handling, and logging mechanisms.
- Ensure compliance with data governance and quality standards.
- Continuously monitor ETL pipelines to identify and resolve performance bottlenecks.
- Improve system scalability and efficiency for high-volume data transactions.
- Hands-on experience in ETL/ELT development, data integration, and pipeline monitoring.
- Proficiency in working with APIs, databases, and data transformation tools.
- Strong knowledge of ERP systems (SAP, Oracle) and vendor platforms (e.g., AeroXchange).
- Expertise in handling large-scale data sets while ensuring integrity and consistency.
- Ability to troubleshoot and optimize integration workflows for performance and reliability.
Qualifications
- 6+ years of hands-on experience with ETL/ELT tools such as dbt, Apache Airflow, Informatica, Talend, or Fivetran in a cloud or hybrid environment.
- Expertise in SQL and database technologies (SQL, NoSQL, Graph databases) with experience in data modeling, schema design, and query optimization.
- Strong cloud experience with platforms like AWS Redshift, Snowflake, Google BigQuery, and Azure Synapse for large-scale data integration.
- Understanding of data security measures, including role-based access control (RBAC), row-level security (RLS), column-level security (CLS), and dynamic data masking (DDM).
- Experience integrating enterprise applications, including ERP, CRM, OMS, and PIM systems, into a centralized data ecosystem.
Requirements
- Knowledge of big data and streaming technologies such as Apache Kafka, Spark, or Hadoop is a plus.
- Familiarity with BI and analytics tools (Power BI, Tableau, Looker, Google Analytics, Adobe Analytics).
- Understanding of AI/ML-driven data pipelines for predictive analytics and personalized customer insights.
- Experience with data governance, metadata management, and MDM frameworks.
- Excellent problem-solving skills, communication, and stakeholder management to work across multiple teams.
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related field.
- Certifications such as AWS Certified Data Analytics, Google Professional Data Engineer, or Snowflake Data Architect are a plus.
Benefits
- A career with thought leaders who literally wrote the book on Marketplace Best Practices.
- A career in the fast-paced world of retail eCommerce, digital marketplaces, and platform businesses.
- A career with first movers who are deploying new business models and strategies worldwide.
- A career in a flat management structure without a rigid hierarchy and bureaucracy.
- A career in a culture that rewards creativity and innovation, risk-taking, and teamwork.
Similar Remote Jobs
More jobs at McFadyen Digital
-
Project Management unspecified Northern America, Latin America (LATAM), India +1 moreApr 04, 2025
-
Software Development unspecified USA, India, BrazilApr 04, 2025
-
Data Analysis unspecified USAApr 04, 2025
More Data Analysis jobs
-
Data Analysis $27.44-$38.41 USAApr 04, 2025
More jobs in Northern America
-
Sales / Business $129,100 - $206,300 usd Northern AmericaApr 04, 2025
-
Design $104,040 - $139,310 Northern AmericaApr 04, 2025
-
Project Management unspecified Northern America, Latin America (LATAM), India +1 moreApr 04, 2025
Kickstart Your Job Search
Need advice to apply?
Join our free
Webinar « 3
Mistakes to Avoid When Looking For A Remote Startup Job (And What To Do Instead) »
Register for free
Unlock 54,960 additional remote jobs, advanced search & email notifications
Get Access Now
Too many emails? Declutter your inbox with Meco
Your home for reading newsletters
Try for free - no card required.
️
| 📍 | Be aware of the location restriction for this remote position: Northern America, Americas, India |
| ‼ | Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more. |
Back to Remote jobs >
Data Analysis
Data Analysis
|
Salary
💸
unspecified
|
Remote
Location
Northern America, Americas, India
|
|
Job Type
full-time
|
Posted
Apr 01, 2025
|
️
| 📍 | Be aware of the location restriction for this remote position: Northern America, Americas, India |
| ‼ | Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more. |
