Data Engineer II

About Cobalt Streamworks Cobalt Streamworks 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 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 role: As a Data Engineer II, you will be a key technical contributor working directly alongside the Director of Data to advance the vision and maturity of our data platform. This role is focused on elevating data quality, driving platform modernization, and leading the migration of existing data systems to a Kimball/star schema architecture. You will take ownership of complex, high-impact engineering work — moving from contributor to driving force on data modeling standards, hygiene practices, and the long-term scalability of our data infrastructure. In this position you will: Partner directly with the Director of Data to translate platform vision into engineering execution Lead the design and implementation of Kimball-style dimensional models and star schema architectures, migrating legacy data systems to a modern, scalable foundation. Own and enforce data hygiene standards across the platform — identifying, documenting, and remediating data quality issues proactively. Design, build, and maintain production-grade data pipelines with a focus on reliability, observability, and maintainability. Develop and champion best practices for data modeling, transformation, and testing across the engineering team. Drive the extraction and codification of business logic from existing systems into well-documented, portable, cloud-agnostic layers. Collaborate with analysts, engineers, and stakeholders to ensure data models meet both current reporting needs and future platform requirements. Provide technical guidance and mentorship to Data Engineer I team members. Contribute to architectural decisions and participate in design reviews, bringing a principled, opinionated perspective on platform direction. Support and improve documentation standards to ensure the codebase and data platform remain well-understood across the team. What we are seeking: 5+ years of experience in data engineering, with a demonstrated track record of owning and delivering complex data platform initiatives. Deep expertise in dimensional modeling, including Kimball methodology and star/snowflake schema design. Experience leading or significantly contributing to data warehouse migrations or platform modernization efforts. Advanced proficiency with SQL and Python; ability to write production-quality, well-tested, maintainable code. Strong command of dbt, including advanced features such as custom tests, macros, packages, and documentation generation. Hands-on experience with Snowflake & Redshift and modern data stack tooling. A systematic, principled approach to data quality — experience implementing data hygiene frameworks, validation pipelines, and monitoring. Ability to operate with autonomy and drive work forward in ambiguous or evolving problem spaces. Strong communication skills with the ability to articulate technical decisions to both engineering and non-engineering stakeholders. Passion for applying technical skills to social impact work and the ability to thrive in a cross-functional, mission-driven team. Other duties as assigned. What We Offer: Cobalt Streamworks offers a friendly work environment and competitive compensation and benefits package including: Salary: $95,000 - $125,000 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. At Cobalt Streamworks, 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. A