Associate Data Engineer

About us:

Spring & Bond is a digital media agency and consultancy specializing in helping pharmaceutical and medical device manufacturers create robust, omnichannel media strategies for both healthcare professionals (HCPs) and consumer audiences. We emphasize transparency and client empowerment through comprehensive services, including customer journey planning, media strategy and activation, technology evaluation, in-house capability development, and training.

What you’ll do:

We are looking for an Associate Data Engineer to help build and maintain our data infrastructure, ensuring data quality and accessibility for our analytics and media operations teams. Success in this position will involve creating efficient ETL pipelines, validating data accuracy, and collaborating with stakeholders to understand their data needs. This role is crucial in supporting data-driven decision-making across the organization and reports to the Data Engineering Manager.

Your Responsibilities:

• Design, develop, and maintain ETL pipelines to ingest and transform data from various sources.

• Implement data validation processes to ensure data accuracy and consistency throughout the data lifecycle, using tools like Regex.

• Write and optimize SQL queries for data extraction, aggregation, and analysis.

• Develop and maintain Python scripts and Pandas dataframes for data manipulation and analysis.

• Utilize AWS Lambda functions to automate data processing tasks.

• Manage code using Git for version control and collaborative development.

• Collaborate with data analysts, media strategists, and other stakeholders to understand their data requirements and provide solutions.

• Communicate technical concepts to non-technical stakeholders and translate business needs into technical specifications.

• Troubleshoot and resolve data-related issues, identifying areas for improvement and efficiency gains.

• Document data processes, pipelines, and transformations for knowledge sharing and maintainability.

• Work with vendors to ensure seamless data integration and resolve any data delivery issues.

• Apply critical thinking skills to analyze complex data problems and develop innovative solutions.

Your experience:

• Bachelor's degree in Computer Science, Data Science, or a related field preferred, but not required. Equivalent experience will be considered.

• 1+ years of experience in a data engineering or related role.

• Strong SQL skills, including the ability to write complex queries using JOINs and aggregate functions.

• Proficiency in Python and data manipulation libraries such as Pandas.

• Experience with data validation techniques and tools.

• Familiarity with AWS cloud services, particularly S3 and Lambda.

• Experience with Git for code version control.

• Detail-oriented with a focus on data accuracy and quality.

• Organized with a systematic approach to managing data workflows.

• Comfortable working in an ambiguous environment and able to independently drive projects forward.

• Nimble and able to adapt to changing priorities.

Benefits:

• Remote-first team environment

• Coverage for medical, dental, and vision insurance for you and your dependents

• Disability insurance plan 

• Matching 401K 

• Parental leave 

• Other fun health & wellness perks

Spring & Bond is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Spring & Bond is a woman-owned business.

Not everyone will match the above qualifications 100%. If your experiences don’t perfectly align, but you think you’d be a great addition to our team, we’d still love to hear from you.