About BlueLabs
BlueLabs is a leading provider of analytics services and technology for a variety of industry clients: including government, business, and political campaigns. We help our clients optimize their engagements with individual customers, supporters, and stakeholders to achieve their goals. Simply put: we help our partners do the most good by getting the most from their data.
Today, our team of data analysts, scientists, engineers, and strategists come together from diverse backgrounds to share a passion for using data to solve the world’s greatest social and analytical challenges. We’ve served more than 400 organizations ranging from government agencies, advocacy groups, political campaigns, and businesses. Along the way, we’ve developed some of the most innovative tools available in analytics, media optimization, reporting, and influencer outreach-- serving a diverse set of industries, including the automotive, travel, consumer packaged goods, entertainment, healthcare, media, telecom, and more.
About the team:
The Insights division creates and manages the underlying data that drives our day-to-day work. This is a new team at BlueLabs, created to meet our organization’s evolving client base and business needs, to ensure that BlueLabs is providing the most innovative data and analysis to our clients, all while developing and coaching team members to grow and respond to our company’s goals.
The BlueLabs Insights practice works with non-profit, political, and private sector clients to provide them with high quality analysis to better understand the environment they operate in and inform future decision making.
The Data Department is all about creating efficiency in the analytical process. The team helps ensure data pipelines are up and running, breaks down data silos to ensure we aren’t duplicating acquisition efforts, and creates documentation to help the Insights team better understand the data they are working with. The Data Department is also the go to for analyzing the value of new data for acquisition and exploring how to better utilize our internal data.
About the role:
As an Analytics Engineer, you will support the Data Department and Insights project teams to create efficient data models, troubleshoot SQL issues, improve documentation, ensure data quality, and manage data automation. Your track record stepping into this role should reflect domain knowledge in data modeling and ingestion, including experience adapting to changing technologies and/or client priorities. The Analytics Engineer reports to the Director, Data.
In this position you will:
- Create data models using dbt. This includes refactoring existing code for dbt and working with analytics and data science team members to set up new data models in dbt
- Configure projects and environment in dbt
- Collaborate with the team to establish quality standards and metrics for data assets
- Be responsible for version control documentation for data assets
- Document final data assets in our data catalog
- Audit existing SQL code to find efficiencies and add documentation.
- Help build base tables for reporting, modeling, and client specific projects
- Complete such other reasonable tasks as may be assigned by management
What we are seeking:
- 4+ years of SQL experience; experience across multiple platforms e.g. Redshift, BigQuery, Vertica, etc is a plus
- 2+ years experience working in dbt to create data models
- Experience working with automated data pipelines and orchestration tool
- Ability to diagnose and improve database and query performance issues
- Some knowledge with object-oriented programming, preferably Python
- Familiarity with Git, or experience with other version control system
- A high attention to detail and ability to effectively manage and prioritize several tasks or projects concurrently
- Effective communication and collaboration skills when working with team members of varied backgrounds, roles, and functions
- Passion in applying your skills to our social mission to problem-solve and collaborate within a cross-functional team environment
You may also have experience:
- Working on political campaigns or in progressive advocacy
- Working with voter files or large consumer datasets
- Working with geospatial data
- Working with business intelligence software like Tableau, PowerBi, or Data Studio
Recruitment process
We strive to hire efficiently and transparently. We expect to hire this position in October 2022. To get there, we anticipate the successful candidate will complete three interviews (HR 15 minutes, technical interview + assessment 45 minutes, and team interview 60 minutes), all virtually. During the interview process, you will be asked questions to describe your background and experience relevant to the position. This may include providing examples of projects you worked on, tools or applications you've used, and knowledge you have applied. We often look for explanations of "how or why" so it's helpful to have details ready.
What We Offer:
BlueLabs offers a friendly work environment and competitive benefits package including:
- 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
- Macbook Pro laptop & tech accessories
- Bring Your Own Device (BYOD) stipend for mobile device
- Employee Assistance Program (EAP)
- Supportive & collaborative culture
- Flexible working hours
- Remote friendly (within the U.S.)
- Pre-tax transportation options for commuting to our office in Washington, DC
- Lunches and snacks
- And more!
The salary for this position is $85,000 annually.
While we have an office in Washington, DC, we are open to considering candidates from within the U.S.
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 (Link to external DOL site)