MediaNews Group is looking to optimize audience engagement and revenue across their digital media landscape by designing, building, and maintaining robust data pipelines and analytics frameworks.
Requirements
- Advanced knowledge of SQL (writing queries, optimizing performance, working with relational databases, etc.)
- Experience with scripting languages like JS for data manipulation and automation
- Familiarity with data pipeline tools (e.g., Airflow, dbt, or similar) and concepts of data orchestration
- Proficiency with Tableau, Looker Studio, Power BI, or similar tool
- Experience with web analytics platforms such as Google Analytics
- Familiarity with statistical concepts and experimental methods is a plus
- Familiarity with GitHub (or similar) and best practices for branching, pull requests, and code reviews
Responsibilities
- Design, build, and maintain data pipelines (ETL/ELT) to capture audience engagement and revenue data from multiple sources (e.g., Google Analytics, internal systems)
- Implement data transformations and validations to ensure data quality and reliability
- Develop and maintain intuitive, scalable reporting and dashboards in business intelligence tools such as Tableau and Looker Studio
- Optimize the existing reporting structure and back-end code to improve performance and data fidelity
- Optimize SQL queries, manage database schemas, and implement data modeling best practices
- Provide technical expertise on big data technologies, cloud-based data warehousing, and analytics tool integrations as needed
- Perform advanced analyses to identify trends, correlations, and opportunities within large, complex datasets
Other
- A degree in Information Systems, Data Science, Computer Science, or a related field is preferred, but not required
- Equivalent work experience will be considered
- 3 years of experience in analytics, data engineering, or business intelligence role (or relevant training/portfolio)
- Strong verbal and written communication skills, with the ability to distill technical concepts for non-technical audiences
- Team player with solid interpersonal skills; able to collaborate effectively across functional groups in a fast-paced, Agile environment
