Location: Remote
Experience: 7+ Years
Domain: Sports Analytics / Customer Data Platform
Job Summary
We are seeking a hands-on Senior Data Engineer to design and build modern cloud-based data platforms supporting customer, product, marketing, and analytics initiatives. The ideal candidate will have strong expertise in DBT, advanced SQL, dimensional modeling, and AWS, with experience building scalable, reusable, and production-ready data assets.
Key Responsibilities
- Design and develop scalable data transformation pipelines using DBT, SQL, and Jinja.
- Build dimensional data models serving as a single source of truth for analytics.
- Develop and maintain data architecture, data models, and warehouse solutions using DBT and Amazon Redshift.
- Own end-to-end DBT data models supporting analysts, data scientists, and BI teams.
- Develop and maintain DBT models, packages, macros, SQL code, and ERD documentation.
- Collaborate with business and technical stakeholders to gather requirements and translate them into data solutions.
- Implement data quality, governance, and operational requirements across data pipelines.
- Apply software engineering best practices including version control and CI/CD.
- Support code reviews, technical design reviews, and collaboration with distributed/offshore teams.
Required Qualifications
- Bachelor's or Master's degree in Computer Science, Mathematics, Statistics, Engineering, Information Technology, or related field.
- 5+ years of experience in Data Engineering, Analytics Engineering, or modern data platforms.
- 5+ years of advanced SQL experience, including joins, CTEs, partitioning, pivoting, and aggregations.
- 4+ years of hands-on DBT experience, including complex models, packages, and macros.
- Strong expertise in dimensional modeling and data warehousing.
- Experience designing and maintaining enterprise data models.
- Understanding of Change Data Capture (CDC) concepts.
- Experience with AWS data services, preferably Lambda, Step Functions, S3, Glue, Athena, and Redshift.
- Understanding of Python, Jinja, or PySpark.
- Knowledge of software development lifecycle, DevOps, version control, and CI/CD.
- Agile experience and ability to work with distributed/offshore teams.
Preferred Qualifications
- Experience supporting Sports, Media, Customer, or Marketing Analytics platforms.
- Strong data quality and data governance experience.
- Experience creating reusable data products and analytics assets.
- Strong documentation and ERD development experience.
- Experience participating in customer-facing design and code reviews.
Key Skills
DBT, Advanced SQL, Data Modeling, Dimensional Modeling, Data Warehousing, Amazon Redshift, AWS, Jinja, Python, PySpark, Data Architecture, Data Transformation, Data Quality, Data Governance, CDC, CI/CD, Version Control
One-Line Summary
DBT Advanced SQL Dimensional Modeling Redshift AWS Jinja Python/PySpark Data Architecture Data Warehousing Data Quality CDC CI/CD