Brooksource - ETL Developer

Data Scientist is needed in Charlotte, United States.

Client: Brooksource

Location: Charlotte, NC

Contract: Contract

Job Description

Brooksource is seeking a Data Integration Developer to join the Data Activation team within our Fortune 100 Telecommunications client’s Advertising & Media organization. This team builds and maintains the data pipelines that prepare and activate customer audiences, enabling large‑scale marketing and advertising use cases. This is a hands‑on development role focused on building, optimizing, and troubleshooting data pipelines across AWS, Airflow, and Snowflake. No leadership or management responsibilities are required.

Requirements

Experience Requirements

3–5 years of professional experience in:

• SQL development
• Python scripting
• ETL/ELT development
• Airflow or similar orchestration tools
• Cloud data platforms (Snowflake preferred)
• MPP systems such as Teradata, Oracle, or Informatica

Key Responsibilities

• Develop and maintain ETL/ELT workflows supporting audience activation, segmentation, and downstream marketing data.
• Build and enhance Airflow DAGs that move data from AWS into Snowflake.
• Write and optimize SQL for transformations and activation‑ready datasets.
• Support data ingestion and processing within MPP environments like Teradata, Oracle, or Informatica.
• Perform data validation, reconciliation, and quality checks on activation datasets.
• Maintain automation scripts and reusable components for CI/CD pipelines.
• Collaborate with Product Owners, Architects, and other developers within an Agile Scrum team.
• Troubleshoot and resolve pipeline failures, improve performance, and increase reliability.

Required Skills

• Strong experience with SQL
• Hands‑on Python development
• Experience developing workflows in Airflow
• Working knowledge of Snowflake (queries, transformations, modeling)
• Experience with MPP systems like Teradata, Oracle, or Informatica
• Strong understanding of ETL/ELT concepts
• Exposure to AWS or other cloud platforms
• Unix/Linux commands or scripting familiarity
• Experience with data validation and quality checks

Nice-to-Have Skills

• Experience with marketing/advertising data, audience activation, or CDP workflows
• AWS tools such as S3, Lambda, Glue, or Step Functions
• Experience with customer segmentation or media measurement data

Additional Information

Employment Type: Longterm Contract (renewed in 6 mo intervals)

Pay: $65.00 - $68.00 per hour

Work Location: Hybrid remote in Charlotte, NC 28217

Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.

Disclaimer: Brooksource, Medasource, and Calculated Hire are part of the Eight Eleven Group family of companies and operate under Eight Eleven Group, LLC. All employees receive the same benefits, policies, and terms of employment.

EEO: We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, ancestry, age, disability, genetic information, marital status, military or veteran status, citizenship, pregnancy (including childbirth, lactation, and related conditions), or any other protected status in accordance with applicable federal, state, and local laws.

Pay Disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.