Job Description

We’d love you to join our growing product development team whose mission is to create people-centric software experiences that empower our local news and digital partners. True to our purpose, we help small teams play big!

Be part of a digital media landscape in the midst of rapid change; our team is at the center of a new content, marketing, operations, and revenue-sustainable experience that puts product, people and performance first. You will be a key member of our data warehouse agile team focused on building reliable, trusted applications that engage with customers across the many US media markets in our portfolio, such as the Denver Post, San Jose Mercury News, the Boulder Daily Camera and the St. Paul Pioneer Press, as well as our Adtaxi digital marketing agency. Check out our local news portfolio to see if we operate in a market near you.

As part of the broader Product Development team, you will contribute to a culture that prioritizes continuous learning, autonomous decision making, agility, and pragmatism. Join us to kick-start your career at a company that offers substantial personal and professional growth opportunities via a hands-on learning approach and a flexible working style.

Purpose statement / description

We are looking for a Software Engineer interested in working with Engineering and Product Development teams to build stable, scalable, and repeatable data-driven products for use in both the publishing and advanced digital advertising companies of MediaNews Group and affiliates. The right candidate will be a self-motivated engineer who has a passion for working with technologies including Amazon Redshift, Google Cloud Products, Python, SQL while staying current and curious about exploring the latest and greatest. This engineer will provide input into our product process and will have a real impact as part of a small, nimble team.

Responsibilities

• Build, monitor and maintain data ETL pipelines and SQL scripts used to populate a data warehouse.

• Design, create and optimize database schemas and tables.

• Collaborate on relational and dimensional data modeling and database design.

• Administer and maintain AWS Redshift and other data infrastructure.

• Implement systems that validate data, ensure quality and consistency as data moves from source systems to production.

• Troubleshoot data issues, validate result sets, recommend and implement process improvements, provide ad-hoc and scheduled reports and analysis.

• Collaborate to create data-driven products as a member of an Agile scrum team.

Required Experience

• BS in Computer Science/Engineering or completion of an intense software engineering curriculum (bootcamp)

• 2+ years of relevant software development experience

Required skills

• Writing and maintaining ETL processes for data warehouses

• Python

• Consuming or writing web APIs like REST, SOAP, or GraphQL, etc

• Reading and writing SQL queries

• Methodical testing of business logic

• Working with git or other version control systems (Subversion, etc)

• Working with Linux or OS X

• AWS Redshift or Google Cloud Platform operational knowledge

Desired skills or hands-on experience

• Apache Airflow

• Apache Spark

• Docker or Kubernetes

• ML libraries (examples: tensorflow, scikit-learn, etc.)

Working relationships / stakeholders

• Data engineers

• Data scientists

• Product owners

• Scrum masters

• Technical directors

The annual salary range for Colorado residents is $90,000-95,000. Pay is based on several factors including but not limited to education, work experience, time in role, certifications, etc. This role is eligible for a bonus based on performance. In addition to your salary, MediaNews Group offers a comprehensive benefits package, incentive and recognition programs, and a 401K plan (all benefits are based on eligibility).