Data Engineer / Marketing Technology Developer

Genesis10; United States; Remote; USD 103,000 - 124,000; Full time

Benefits offered by this job

Medical, Dental, Vision

Health Savings Account

401K

Sick Pay

Commuter Benefits

Commuter Benefits (Dallas, NYC, SF, IL

Job summary

Genesis10 is seeking a Data Engineer / Marketing Technology Developer for a remote, 6-month contract with a leading retailer. The role focuses on ETL, data warehousing, and MarTech/personalization integrations, collaborating with business and technical teams to deliver reliable reporting data.

Responsibilities include building ETL pipelines, leveraging SSIS and Talend, integrating with Snowflake and PostgreSQL, and supporting BI tooling like Tableau and Power BI.

Qualifications

• 3 years' experience developing ETL and data integration solutions.

Responsibilities

• Design, develop, test, and maintain ETL processes for integrating data from multiple internal and external sources.
• Develop and maintain data integration solutions using Microsoft Visual Studio and SQL Server Integration Services (SSIS).
• Develop data pipelines and integration processes using Talend Management Studio.
• Work with Snowflake and Microsoft SQL Server databases to develop queries, stored procedures, views, and other database objects.
• Support the integration of data using Amazon AWS services, including S3 and SQS.
• Experience building the data layer for Personalization tools such as Insider One, BlueCore, Bloomreach etc
• Extract, transform, validate, and load data into data warehouse and reporting environments
• Develop and maintain source to target mappings, transformation rules, and technical documentation
• Perform data validation, reconciliation, and troubleshooting to identify and resolve data quality and integration issues
• Monitor ETL jobs and data pipelines and investigate failed processes, data discrepancies, and performance issues
• Support data warehouse and data mart development, including data modeling, dimensions, facts, and reporting structures
• Partner with business users and technical teams to gather requirements and translate business needs into data solutions
• Develop SQL queries and perform data analysis to support business reporting and operational requirements
• Support business intelligence reporting and dashboard development using tools such as Tableau and Power BI
• Perform database and query performance tuning to improve the efficiency of data processing and reporting
• Use pgAdmin to query, analyze, troubleshoot, and validate PostgreSQL databases
• Participate in application testing, implementation, production support, and ongoing enhancement of data solutions

Tools

Talend Management Studio

Talend Data Integration

Microsoft Visual Studio

SSIS

SQL Server

Snowflake

PostgreSQL

pgAdmin

Tableau

Power BI

Amazon AWS (S3, SQS)

InsiderOne

BlueCore

Bloomreach

Job description

Genesis10 is currently seeking a Data Engineer / Marketing Technology Developer - Remote position with a Leading Retailer located in Secaucus, NJ. This is a 6 month contract opportunity.

The Data Engineer / MarTech Developer will support the development and maintenance of data integration, data warehousing, and MarTech and Personalization solutions. This role will work with business and technical teams to understand data requirements, develop ETL processes, integrate data from multiple sources, and ensure data is accurate, reliable, and available for reporting and analysis.

Responsibilities:

• Design, develop, test, and maintain ETL processes for integrating data from multiple internal and external sources
• Develop and maintain data integration solutions using Microsoft Visual Studio and SQL Server Integration Services (SSIS)
• Develop data pipelines and integration processes using Talend Management Studio
• Work with Snowflake and Microsoft SQL Server databases to develop queries, stored procedures, views, and other database objects
• Support the integration of data using Amazon AWS services, including S3 and SQS
• Experience building the data layer for Personalization tools such as Insider One, BlueCore, Bloomreach etc
• Extract, transform, validate, and load data into data warehouse and reporting environments
• Develop and maintain source to target mappings, transformation rules, and technical documentation
• Perform data validation, reconciliation, and troubleshooting to identify and resolve data quality and integration issues
• Monitor ETL jobs and data pipelines and investigate failed processes, data discrepancies, and performance issues
• Support data warehouse and data mart development, including data modeling, dimensions, facts, and reporting structures
• Partner with business users and technical teams to gather requirements and translate business needs into data solutions
• Develop SQL queries and perform data analysis to support business reporting and operational requirements
• Support business intelligence reporting and dashboard development using tools such as Tableau and Power BI
• Perform database and query performance tuning to improve the efficiency of data processing and reporting
• Use pgAdmin to query, analyze, troubleshoot, and validate PostgreSQL databases
• Participate in application testing, implementation, production support, and ongoing enhancement of data solutions

Requirements:

• 3 years' experience developing ETL and data integration solutions
• Strong SQL skills with experience working with Microsoft SQL Server and Snowflake
• Hands on experience with Microsoft Visual Studio and SSIS
• Experience with Talend Management Studio and Talend data integration tools
• Experience working with Amazon AWS services, particularly S3 and SQS
• Experience with Personalization tools such as InsiderOne and BlueCore
• Experience working with PostgreSQL and pgAdmin
• Understanding of data warehousing, ETL processes, data mapping, and data transformation
• Experience troubleshooting data integration processes and resolving data quality issues
• Strong analytical and problem solving skills
• Ability to work with both technical teams and business stakeholders

Pay range: $49.40 - $59.40 per hour

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

Benefits of Working with Genesis10:

• Access to hundreds of clients, most who have been working with Genesis10 for 5-20 years.
• The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
• Access to an experienced, caring recruiting team (more than 7 years of experience, on average.)
• Behavioral Health Platform
• Medical, Dental, Vision
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401K
• Sick Pay (for applicable states/municipalities)
• Commuter Benefits (Dallas, NYC, SF, and Illinois)

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.