Data Engineer

BPI is an outcomes agency at the intersection of business, politics, and policy. We combine vision with powerful communication tools to drive change and deliver outcomes that shape today’s most important conversations. A growing firm with offices in DC, New York, Chicago, and San Francisco, our team is made up of strategists, data scientists, and artists alike. We make change possible.

The Impact You Will Make

Bully Pulpit International (BPI) is seeking a Data Engineer to help build a next generation data platform that powers our targeting, measurement, and competitive tracking offerings. In this role, you’ll leverage tools like dbt, dlt and Airflow to create ELT pipelines and business ready datasets for a wide variety of use cases and users.

The ideal candidate has experience with writing production SQL and Python code, and is excited to collaborate with internal stakeholders, data scientists and analysts to deliver value for our clients. We believe the best ideas come from the people closest to the work, and we are looking for an engineer with a product mindset that can identify the core problem and the best solution. We also believe that we can learn something new everyday – whether it’s new technologies like generative AI, engineering best practices, or gaining deeper domain expertise.

• Salary range - $75,000 - $90,000
• Expectation to work from one of our offices (Chicago, DC, NYC, SF) at least 3 days a week

Requirements

• Build and maintain data products from proof of concept to deployment, ensuring scalability, reliability, and performance optimization
• Work with stakeholders and end users to build new features and make current datasets easier to use and understand
• Own maintenance of analytics workflows by identifying and resolving issues and errors, staying up-to-date with latest developments
• Enrich datasets using internal and external APIs so that we can bring the most actionable data possible to our clients
• Bring product-focused thinking to the problems you solve and scale solutions up to our whole team

• 2-3 years of experience in the technical skillset mentioned below

• Proficiency in SQL, writing queries with complex logic
• Experience building data pipelines with Airflow and dbt (or similar frameworks)
• Knowledgeable in cloud data warehouses like Snowflake, Redshift, or BigQuery
• Familiarity with analytics data modeling (Star Schema, Data Vault, etc), and data intensive system design
• Familiarity building, testing, and deploying data applications with cloud provider offerings like AWS, GCP or Azure (Infrastructure as Code tools, like Cloudformation or Terraform, is a plus)
• Familiarity with MLOps and deploying batch prediction pipelines using tools like MLflow, Airflow, or ECS is a plus
• Great time management skills to prioritize between tasks
• Excited to collaborate with data analysts and subject matter experts alike
• Excellent attention to detail

Benefits

BPI offers a wide range of benefits to U.S.-based employees, including 100% company-paid medical, dental, and vision insurance, a 401(k) program with employer match up to 4%, generous time off for vacation, $50 monthly phone reimbursement, unlimited sick time, and 16 weeks of paid leave for new parents. BPI’s benefits prioritize employee wellness and progressive support to our diverse workforce.

We’re looking for all kinds of people.

BPI Group is an integrated public affairs agency that delivers outcomes for the top organizations and leaders around the world. With expertise in strategic communications, digital marketing, creative, research, and measurement, we offer a cohesive approach across corporate, policy, and public affairs strategy in today’s interconnected world. By combining incisive strategy and deep tactical expertise, we make change possible. Our transatlantic presence includes offices across eleven markets in the US and Europe.

We are an equal opportunity employer and make employment decisions based on individual commitment to excellence. We want to have the best qualified people in every job. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, religion or religious creed, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender, gender identity, gender expression, age, marital status, status as a protected veteran, physical or mental disability, medical condition, genetic information or characteristics (or those of a family member) or any other consideration made unlawful by applicable federal, state or local laws. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.

BPI is dedicated to building an inclusive, diverse, equitable, and accessible workplace that fosters a sense of belonging – so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to still consider submitting an application. We consider applications holistically and you may be just the right candidate for this role or another one of our openings!

Let’s keep in touch. Follow us on and at @bpimedia.com