Company
Cox Enterprises
Engineering / Product Development
Sr Data Engineer
Individual Contributor
Hybrid - Ability to work remotely part of the week
Yes, 5% of the time
Day
Compensation
Compensation includes a base salary of $99,000.00 - $165,000.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate’s knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.
We are seeking a highly skilled and experienced Sr. Data Engineer who can help our team structure and optimize our data for powerful analytics & reporting. In this role, you will focus on designing, building, and maintaining data pipelines and systems to ensure the accuracy, availability, consistency, and usability of our data for analysis. Our team leverages Snowflake as our primary Data Warehouse alongside dbt, AWS, GCP, and various other tools to maximize our data capabilities. Your work will require a strong background in data exploration, transformation, modeling and governance. This role provides an excellent opportunity to work in a fast-paced environment and leverage a growing technology stack to make a significant impact on our business operations and strategy.
Key Responsibilities:
- Lead the design, development, and maintenance of scalable dbt models, ensuring modularity and efficiency.
- Apply Kimball-style dimensional modeling techniques (star schema, slowly changing dimensions, fact and dimension tables) to structure data optimally for analysis and reporting.
- Explore, analyze, and validate data to ensure accuracy, consistency, and completeness of dbt models.
- Implement and maintain automated dbt tests to ensure data quality, including checks for anomalies, nulls, duplicates, and referential integrity.
- Investigate and troubleshoot data anomalies, pipeline errors, and model discrepancies, collaborating with teams to resolve issues promptly.
- Partner closely with data analysts to build reliable reporting models and ensure the data feeding reports is accurate, actionable, and aligned with business needs.
- Ensure the availability, consistency, and accessibility of data for analytics teams working with Tableau, PowerBI, Amplitude, Google Analytics, and other BI tools.
- Participate in code and PR reviews to maintain high-quality, consistent dbt models and data pipeline code.
- Monitor and optimize data pipeline performance, leveraging tools on AWS such as Lambda, SQS, Athena, EC2, and Kinesis.
- Implement and enforce data governance policies, ensuring data integrity, security, and compliance.
Qualifications:
- 4+ years of experience as a Data Engineer or in a similar role.
- Bachelor’s degree in a related discipline and 4 years’ experience in a related field. The right candidate could also have a different combination, such as a master’s degree and 2 years’ experience; a Ph.D. and up to 1 year of experience; or 16 years’ experience in a related field. Bachelor’s or Master’s degree in Computer Science, Statistics, Data Science, or related fields. An advanced degree is preferred.
- Extensive experience with dbt for building, testing, and maintaining reliable data models and transformations.
- Strong knowledge of data quality, validation, and governance best practices.
- Experience collaborating with data analysts to build accurate, actionable reporting models.
- Proficiency with Snowflake and building scalable data warehouses.
- Expertise in Kimball-style dimensional modeling (star schema, fact and dimension tables, slowly changing dimensions).
- Strong SQL skills for querying, automation, optimization and data validation.
- Proficient in Python for scripting and automation.
- Familiarity with AWS cloud tools (Lambda, SQS, Athena, EC2, Kinesis) and cloud-based data pipelines.
- Understanding of event and web analytics data from tools like Amplitude and Google Analytics.
- Experience with real-time data streams and troubleshooting data pipeline issues.
The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company’s needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.
As our primary divisions Cox Automotive and Cox Communications drive new waves of innovation, Cox Enterprises is entering spaces like cleantech, healthcare, esports and more. We're a family business guided by a legacy of bold innovation that’s driven by those who want to make their mark. Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page. Cox is an Equal Employment Opportunity employer – All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.