Sr Data Engineer

Job Description

Job Description

Description

Location : North America (remote)

ActiveState enables DevOps, InfoSec, and Development teams to improve their security posture while simultaneously increasing productivity and innovation to deliver secure applications faster.

We are the only solution in the market today that offers vulnerability-free open source language packages and containers and Intelligent Remediation, which identifies which vulnerabilities to prioritize, assesses the impact of updates causing breaking changes, prioritizes what to fix first, securely builds open source packages from source, and facilitates the build and deploy process to get fixes into production quickly and easily.

All from the trusted partner that pioneered and continues to lead enterprise adoption and use of open source software.

This position is open to experienced candidates with a track record in this area. We build our systems to find, understand, and secure all of the open source code on the planet, and we’re looking for someone who knows how to find, ingest, model, and manage this kind of data to help us secure the Internet’s source code!

Key Responsibilities

Our audacious goal is to build all of the open source software released on the internet completely from source, in an automated and repeatable way. As a Senior Data Engineer, you will design, build, and maintain data pipelines that ensure reliable and accessible information across the company. You will create and improve data models, enhance dashboards, and work closely with teams to drive a data-first culture.

Our data is our most powerful, most important asset. Your work will influence our decisions and our success at every level.

This position is a mixture of development and operations; good coding and communication skills are as essential as data management and modeling expertise.

Develop and Maintain Scalable Data Infrastructure. You will design, build, and optimize data pipelines using tools like Airflow and Athena, ensuring efficient data ingestion, transformation, and analysis while maintaining integrity and accessibility.

Enhance Data Models and Visualization. You will expand the company-wide data model to improve reporting accuracy and develop user-friendly dashboards in tools such as Tableau to provide meaningful insights across departments.

Ensure Data Quality and Documentation. You will implement monitoring systems to measure data quality, annotate ingestion feeds with accuracy metrics, and write documentation to help teams access and interpret data effectively.

Drive a Data-First Mindset Across Teams. You will collaborate with sales, marketing, product management, and engineering to uncover insights, answer complex business questions, and advocate for best practices in data usage and decision-making.

We rely on data from the systems we’ve built as well as everything we can discover about open source software in the world.

Skills, Knowledge and Expertise

• At least five years of experience working with ETL processes, data pipelines, and data infrastructure, demonstrating your ability to manage complex data systems.
• Proficient in Python (preferred) or another programming language such as Go, Perl, Ruby, or Java, using code to automate and streamline data processes.
• Experience working with Athena, Snowflake, Redshift, Luigi, or similar data management platforms, allowing you to build and optimize effective data storage solutions.
• Skilled in visualization tools such as Tableau, Power BI, or Google Data Studio, ensuring that you can present data in a clear and meaningful way.
• Strong analytical and problem-solving skills, with experience working with structured and unstructured datasets to uncover insights and trends.
• Excellent communicator, both in writing and in speech, able to translate technical concepts into understandable information for non-technical audiences.
• Practical approach to data ownership, ensuring that stakeholders have the resources and guidance they need to access and interpret data effectively.

If you have experience with any of the following please make sure to highlight it in your cover letter :

Benefits