Data Engineer

Blue State Digital, DC

See jobs at Blue State Digital

 The role

As a Data Engineer at Blue State, you’ll play an integral role on a smart and vibrant analytics team servicing a wide range of progressive organizations. You’ll design, build, and manage the systems and processes which form the underpinning of Blue State’s analytics work, supporting and working alongside data analysts and campaign strategists. But you’ll also work directly with Blue State’s clients to help solve their data integrity and integration challenges, serving as a trusted advisor to your counterparts within client organizations.

Day-to-day responsibilities:

  • Create and support systems and processes for managing, compiling, manipulating, and analyzing data for client and internal projects
  • Work with Blue State’s client organizations to solve difficult data migration, management, and integration challenges 
  • Build data pipelines, data warehouses, reporting dashboards, automated exports, and synchronization processes
  • Automate workflows and look for further opportunities to improve efficiency in our work
  • Always maintain a high level of data security and privacy

The team

You will be a part of the global Web and Product Development team working primarily with our creative agency on client projects. You’ll work in either the NY or DC office.

Top things we’re looking for 

  • Good foundational understanding of statistical analysis
  • Extensive experience working with SQL databases in an analytics or business intelligence context
  • Familiarity with common marketing technology platforms like Google Analytics, Google Ads, Facebook Ads, email marketing tools, and other marketing automation tools
  • Experience with ETL/ELT tools, processes, and best practices
  • Strong Python experience:
  1. Python should be your go-to tool for solving problems. If the first thing you want to do when you have to do the same thing twice is write a Python script to automate it - we want you!
  2. Experience with task automation in a Python context - experience with AirFlow, Prefect, Dask a big plus
  3. Experience working with restful APIs - you can competently navigate unfamiliar API documentation and figure out how to accomplish tasks
  • Strong working knowledge of Google BigQuery and the Google Cloud Platform data product ecosystem including:
    1. Designing data warehouse schemas for cross-channel marketing analytics
    2. Utilizing the suite of Google Cloud Platform tools for the purposes of extracting, processing, manipulating and analysing data
    3. Building and running automated tasks within the GCP environment - e.g. Cloud Compute, Cloud Functions, Cloud Run, Cloud Scheduler
    4. Comfortable managing GCP IAM policies across projects and teams
  • Comfortable working within a spreadsheet (even if you prefer a database) - preferably in Google Sheets - bonus points if you’ve extended Google Sheets using Google Apps Script
  • Familiarity with Git and maintains good habits around code maintenance
  • Able to build repeatable and well-documented processes and tools that can be used by other technically-savvy but non-Python developer analytics team members (think easy to use command-line scripts - not GUIs) 
  • Good at teaching others what you know.
  • At Blue State, diversity is a necessity, not a nice-to-have. We encourage those from underrepresented communities — women, people of color, LGBTQIA+, immigrants, indigenous folks, those with disabilities and people at all the intersections in between — to apply. Even if you don’t think your current skill set checks every box below, but this role seems to align with your strengths, we want to hear from you.

    The company

    Blue State is a values-led creative and campaigns agency that partners with leading causes, companies, and campaigns to build better organizations for a better world. We drive real change, make good trouble, put people first and are constantly curious.

    We believe that there is no force more powerful than people taking collective action on the things they care about. We don’t pretend to have all the answers, but we know where to find them: in people. We listen, learn, and uncover new insights that often surprise us and our clients — and move us toward better results. Across clients including UNHCR, Amnesty International, Google, Tesco, Nesta, and Tate. We have offices in New York City, Washington DC, London, Oakland and Chicago.


    About Blue State Digital

    We got our start on the campaign trail, pioneering the use of digital to open up the democratic process. But people don’t just vote on Election Day—they vote every day with their wallets, with their time, with their clicks and posts and tweets. By reimagining organizations’ relationships with their most important supporters and customers, we help our clients transform their businesses and scale their impact. For us, this isn’t just work. The campaigns we create, insights we unravel, the platforms we build—it’s all about real impact for real people. To bridge differences and inspire advocates. To redefine how business is done. To defend civil and human rights. To challenge ourselves and our partners to put people first.

    Want to learn more about Blue State Digital? Visit Blue State Digital's website.