Published: Tue, 18 Mar 2025 06:51:04 GMT
Position: Associate Data Engineer at Spring & Bond
Company Overview:
Spring & Bond is a leading digital media agency and consultancy, specializing in providing comprehensive services to pharmaceutical and medical device manufacturers. Our mission is to empower our clients through transparency and strategic planning, creating robust, omnichannel media strategies for healthcare professionals (HCPs) and consumer audiences.
We offer a range of services, including customer journey planning, media strategy and activation, technology evaluation, in-house capability development, and training.
Job Description:
We are seeking a highly motivated Associate Data Engineer to join our team. The ideal candidate will be responsible for building and maintaining our data infrastructure, ensuring data quality and accessibility for our analytics and media operations teams. This individual will play a critical role in supporting data-driven decision-making across the organization and will report to the Data Engineering Manager.
Key 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.
Qualifications:
– 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.
We understand that not all candidates will meet all of the qualifications listed above. If you believe you would be a great fit for our team, we encourage you to apply. Apply link
