Overview
We want to be the best. That’s why we hire the best. We thrive on challenging, rewarding, purpose-driven work. We’re looking for skilled individuals like you - for professionals full of talent, but not of themselves.
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. The right candidate will be a self-motivated engineer who has a passion for working with technologies including Amazon Redshift, 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.
#LI-SC1
Responsibilities
Main accountabilities:
- Build, monitor, and maintain data ETL pipelines and SQL scripts used to populate 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 clusters 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.
Qualifications
Certifications, experience, training, education required
- 3+ years of experience in the following:
- ETL processes
- Python
- SQL
- Working with web service APIs
- Version control system such as Git
- Linux and/or OS X
- AWS Redshift, PostgreSQL or other RDBMS data stores
- Knowledge of database design and architecture principles, including in the data
warehousing space
- Bachelor’s degree in Computer Science, Engineering, in a related field or 3+ years of relevant Software Engineer experience
Applications / platform knowledge desired (but not required)
- Apache Airflow
- Apache Spark
- Docker
- Jira
Working relationships / stakeholders
- Data engineers
- Data scientists
- Product owners
- Scrum masters
- Technical directors