Software Engineer II - Enterprise Data Warehouse (Remote)

Position Purpose:

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.

Key Responsibilities:

• 60% Delivery and Execution - 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

• 20% Learning - 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

• 20% Plans and Aligns - 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

Direct Manager/Direct Reports:

• This position typically repots to Software Engineer Manager or Sr. Manager

• This position has 0 Direct Reports

Travel Requirements:

• No travel required.

Physical Requirements:

• Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.

Working Conditions:

• Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.

Minimum Qualifications:

• Must be eighteen years of age or older.

• Must be legally permitted to work in the United States.

Preferred Qualifications:

• 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.

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.

Preferred Education:

• No additional education

Minimum Years of Work Experience:

• 2

Preferred Years of Work Experience:

• No additional years of experience

Minimum Leadership Experience:

• None

Preferred Leadership Experience:

• None

Certifications:

• None

Competencies:

• Global Perspective

• Manages Ambiguity

• Nimble Learning

• Self-Development

• Collaborates

• Cultivates Innovation

• Situational Adaptability

• Communicates Effectively

• Drives Results

• Interpersonal Savvy

We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. - $90,000.00 - $170,000.00