Note: The job is a remote job and is open to candidates in USA. Madison-Davis, LLC is seeking an experienced Data Analytics Engineer to join an established Analytics Engineering team within a large media and entertainment organization. The role focuses on building and maintaining data models, datasets, and production pipelines that support reporting, analytics, and downstream applications, while contributing to deployment, production support, troubleshooting, and documentation.
Responsibilities
- Build, enhance, and maintain production data models using dbt
- Develop and optimize complex SQL transformations across large datasets
- Extend dimensional models and support structured and semi-structured data
- Support production data pipelines and troubleshoot operational failures
- Investigate data quality problems and implement reliable fixes
- Collaborate with upstream and downstream engineering teams on dependencies
- Participate in testing, code reviews, deployment, and documentation
- Develop maintainable solutions that align with existing architecture and engineering practices
Skills
- • 5+ years of Analytics Engineering, Data Engineering, or engineering-focused analytics experience
- • Expert SQL skills, including complex querying, optimization, and data modeling
- • Extensive hands-on experience developing production dbt projects
- • Experience with cloud-based data platforms
- • Experience with Databricks, Snowflake, Unity Catalog, or comparable modern data technologies
- • Production data pipeline support and troubleshooting experience
- • Ability to independently investigate unfamiliar systems and codebases
- • Strong analytical and problem-solving abilities
- • Strong communication and cross-functional collaboration skills
- • Databricks experience
- • PySpark or another distributed processing framework
- • CI/CD experience using GitHub Actions or similar tooling
- • Dimensional modeling and medallion architecture experience
- • Experience supporting business-critical reporting environments
Company Overview
Company H1B Sponsorship