Software Engineer II - Enterprise Data Warehouse

Role Description

The Software Engineer II - EDW is responsible for building and maintaining the data pipelines and structures that power our enterprise analytics. Working within the EDW ecosystem, you will develop curated datasets, maintain semantic layer logic, and ensure the reliability of data products. You will work alongside senior engineers to implement architectural standards, helping to transform raw data into actionable insights while focusing on data integrity, performance, and scalability.

• Delivery and Execution (60%):
  • Collaborates and pairs with other product team members (UX, engineering, and product management) to create secure, reliable, scalable software solutions.
  • Documents, reviews and ensures that all quality and change control standards are met.
  • Works with Product Team to ensure user stories that are developer-ready, easy to understand, and testable.
  • Writes custom code or scripts to automate infrastructure, monitoring services, and test cases.
  • Writes custom code or scripts to do destructive testing to ensure adequate resiliency in production.
  • Program configuration/modification and setup activities on large projects using HD approved methodology.
  • Configures commercial off the shelf solutions to align with evolving business needs.
  • Creates meaningful dashboards, logging, alerting, and responses to ensure that issues are captured and addressed proactively.
• Learning (20%):
  • Actively seeks ways to grow and be challenged using both formal and informal development channels.
  • Learns through successful and failed experiment when tackling new problems.
• Plans and Aligns (20%):
  • Collaborates with other team members in agile processes.
  • Assists in creating new and better ways for the team to be successful.
  • Relates openly and comfortably with diverse groups of people.
  • Builds partnerships and works collaboratively with others to meet shared objectives.

Qualifications

• Must be eighteen years of age or older.
• Must be legally permitted to work in the United States.

Requirements

• 1–3 years of experience in data engineering or a backend-heavy technical role.
• Proficiency in SQL & Python for complex data transformation and automation.
• Hands-on experience with Cloud Data Warehouses (BigQuery preferred).
• Experience in Data Modeling, specifically building curated or ADS (Analytical Data Store) layers.
• Exposure to Orchestration & CI/CD tools such as Airflow, Jenkins, and Git.
• Experience in Data Validation, including unit testing and root cause analysis for pipeline failures.

Benefits

• The pay range for this position is between $90,000.00 - $170,000.00 for California, Colorado, Connecticut, Rhode Island, Nevada, New York City, Ithaca (NY), Westchester County (NY), and Washington residents.

Minimum Education

• The knowledge, skills and abilities typically acquired through the completion of a bachelor's degree program or equivalent degree in a field of study related to the job.

Competencies

• Global Perspective
• Manages Ambiguity
• Nimble Learning
• Self-Development
• Collaborates
• Cultivates Innovation
• Situational Adaptability
• Communicates Effectively
• Drives Results
• Interpersonal Savvy