Data Engineer II

Key Skills

Data Modelling, Database, Effective communication skills, ETL/ELT technologies, Python Programming, R Programming, SQL

Job Description

About BlueLabs

BlueLabs is a leading provider of analytics services and technology dedicated to helping our partners do the most good with their data. Our team of analysts, scientists, engineers, and strategists hail from diverse backgrounds yet share a passion for using data to solve the world’s greatest social and analytical challenges. Since our inception we’ve worked with more than 400 organizations ranging from government agencies, advocacy groups, unions, political campaigns, and international groups. In addition, we service an ever-expanding portfolio of commercial clients in the automotive, travel, CPG, entertainment, healthcare, media, and telecom industries. Along the way, we’ve developed some of the most innovative tools available in analytics, media optimization, reporting, and influencer outreach.

About the team

The BlueLabs Civic Tech practice revolutionizes the way government agencies use data to reduce the friction between residents and the essential services they use. Our team develops deep expertise within the areas our clients care about most, then builds data programs that create impact at scale. We work closely with internal government innovation groups, and build on the analytics methodology pioneered in e-commerce, advocacy, politics, and consumer finance.

About the role:

As a Data Engineer, you will play a critical role in our database upgrade roadmap, in support of our work for a large federal healthcare program. The Data Engineer will work with complex and nuanced data pipelines and will be responsible for the continuous development, review, and documentation of data wrangling and pipeline solutions. You should have experience working in a rapid development team in the past in which you were responsible for significant contributions to client data pipeline solutions.

In this position you will:

• Develop, test, and operationalize the data pipelines that power our analytics.
• Provide visibility into data transformations by designing and implementing data tests throughout existing pipelines.
• Extract business logic (ETL/ELT, metrics, metadata) from current data systems into portable cloud-agnostic layers.
• Analyze, build, and deploy data models, including relational models for data warehousing.
• Plan and maintain data architectures that are aligned with business requirements.
• Produce scalable, replicable code and engineering solutions that help automate repetitive data management tasks.
• Work closely with data analysts to understand, identify and effectively respond to their specific needs.
• Partner with other engineers to deploy and troubleshoot pipeline-related tools, automations, and integrations.
• Work as part of a team to maintain a well documented, consistent codebase.

What we are seeking:

• 3+ years of experience as a contributor to technical projects, such as working with complex data pipelines or software applications.
• Experience working with production grade data warehouses using SQL queries and scripting languages (e.g., Python, R).
• Experience with SQL transformation tools like dbt.
• Strong background in database design and data modeling.
• Experience with Snowflake, implementing a modern data stack, and contributing to large scale data migration efforts.
• Effective communication skills when working with team members of varied backgrounds, roles, and functions.
• Ability to manage your individual priorities and comfortably context-switch between active development, client discussion, and issue response.
• Experience delivering on client priorities that operate on a regular deployment schedule.
• Passion in applying your skills to our social mission to problem-solve and collaborate within a cross-functional, client-facing team environment.
• The ability to successfully attain and maintain a Federal Public Trust background investigation that our government clients require; this includes a requirement that the individual has U.S. Citizenship or U.S. residency for three of the past five years.

What We Offer:

BlueLabs offers a friendly work environment and competitive compensation and benefits package including:

• Salary range: $95,000 - $120,000 annually
• Premier health insurance plan
• 401K matching
• Unlimited vacation leave
• Paid sick, personal, and volunteer leave
• 13 paid holidays
• 15 weeks paid parental leave
• Professional development stipend & tuition reimbursement
• Employee Assistance Program (EAP)
• Supportive & collaborative culture 
• Flexible working hours
• Remote friendly (within the U.S.)
• And more! 

The salary range for candidates who meet the minimum posted qualifications reflects the Company’s good faith understanding and belief as to the wage range, and is accurate as of the date of this job posting.

To protect the health and safety of our workforce, as a company policy, BlueLabs strongly encourages all employees to be fully vaccinated against COVID-19 prior to beginning employment. BlueLabs adheres to all federal, state and local COVID-19 vaccination regulations. Except where prohibited by law, applicants who receive a conditional offer of employment will be required to produce proof of vaccination status prior to their first day of employment; if not the offer may be rescinded or employment terminated. BlueLabs will evaluate requests for reasonable accommodations for applicants unable to be vaccinated due to a religious belief, disability, pregnancy, or on an individualized basis in accordance with applicable laws.

At BlueLabs, we celebrate, support and thrive on differences. Not only do they benefit our services, products, and community, but most importantly, they are to the benefit of our team. Qualified people of all races, ethnicities, ages, sex, genders, sexual orientations, national origins, gender identities, marital status, religions, veterans statuses, disabilities and any other protected classes are strongly encouraged to apply. As an equal opportunity workplace and an affirmative action employer, BlueLabs is committed to creating an inclusive environment for all employees. BlueLabs endeavors to make reasonable accommodations to the known physical or mental limitations of qualified applicants with a disability unless the accommodation would impose an undue hardship on the operation of our business. If an applicant believes they require such assistance to complete the application or to participate in an interview, or has any questions or concerns, they should contact the Director, People Operations. BlueLabs participates in E-verify. EEO is the Law.