Engineer II (Data Engineering)

Our values start with our people, join a team that values you!

We are the nation’s largest off-price retailer with over 2,000 stores, and a strong track record of success and growth. Our focus has always been bringing our customers a constant stream of high-quality brands and on-trend merchandise at extraordinary savings. All while providing a fun and exciting treasure hunt experience.
As part of our team, you will experience:

  • Success. Our winning team pursues excellence while learning and evolving
  • Career growth. We develop industry leading talent because Ross grows when our people grow
  • Teamwork. We work together to solve the hard problems and find the right solution
  • Our commitment to Diversity, Equity & Inclusion, and our community. We celebrate the backgrounds, identities, and ideas of those who work and shop with us because our differences make us stronger. We strive to be a positive force in our community.

Our Corporate headquarters are in Dublin, CA, we have 3 buying offices in key markets in New York City, Los Angeles, and Boston, and 7 distribution centers nationwide. With 2022 revenues of $18.7 billion, we are a Fortune 500 company who is committed to providing an inclusive work environment with continuous learning opportunities and development for our teams.

Come see what’s in store: https://jobs.rossstores.com/creative/about

GENERAL PURPOSE:
The Data Engineer II plays a critical role in engineering of data solutions that support Ross reporting and analytic needs. As a key member of the Data engineering team, will work on diverse data technologies such as Steramsets, dbt, data ops and others to build insightful, scalable, and robust data pipelines that feed our various analytics platforms.

The base salary range for this role is $96,000 - $182,000. The base salary range is dependent on factors including, but not limited to, experience, skills, qualifications, relevant education, certifications, seniority, and location. The range listed is just one component of the total compensation package for employees. Other rewards vary by position and location.

Benefits offered to all Associates include Accident, Critical Illness, Vision, Auto, Home, and Pet insurance programs; Associate Discount, Identity Protection, Associate Purchase Program, Benefit Hub Discount Mall, Employee Assistance Program and Commuter Benefits, 401K (service requirements), Employee Stock Purchase Program, Ross Cares Fund, College Discounts, Sick Pay (where legally required) and Referral Bonuses. In addition, all Full-Time Associates, including FT Retail Associate, Area Supervisor, Assistant Store Manager and Store Manager, are eligible for extended benefits offered including Medical/Dental/Vision Health Insurance, Legal Insurance, Vacation Buy, Flexible Spending Account, Health Savings Account, Life/ADD Insurance, Long- Term Disability, Enhanced Maternity and Parental Leave Benefit, Vacation Pay accrued at a rate of 15 days/year, 15 Personal and Company Holidays. AS, ASM and SM Associates in Stores and Exempt Corporate and Merchandising roles are also eligible to receive a Bonus based on individual and business performance.

ESSENTIAL FUNCTIONS:

• Design and Model data engineering pipelines that support Ross reporting and analytic needs.

• Engineer efficient, adaptable, and scalable data pipelines for moving data from different sources into our Cloud Lakehouse

• Understand and analyze business requirements and translate into well-architected solutions that demonstrate the modern BI & Analytics platform

• Be a part of data modernization projects providing direction on matters of overall design and technical direction, acts as the primary driver toward establishing guidelines and approaches

• Develop and deploy performance optimization methodologies

• Drive timely and proactive issue identification, escalation & resolution

• Collaborate effectively within Data Technology teams, Business Information teams to design and build optimized data flows from source to Data visualization

COMPETENCIES:
People

• Building Effective Teams (for managers of People and Projects)

• Developing Talent (for managers of people only, N/A for this role/level)

• Collaboration
Self

• Leading by Example

• Communicates Effectively

• Ensures Accountability and Execution

• Manages Conflict
Business

• Business Acumen

• Plans, Aligns and Prioritizes

• Organizational Agility

QUALIFICATIONS AND SPECIAL SKILLS REQUIRED:

• At least 7 years in-depth, data engineering experience and execution of data pipelines, data ops, scripting and SQL queries

• 5+ years proven data modeling skills - must have demonstrable experience designing models for data warehousing and modern analytics use-cases (e.g., from operational data store to semantic models)

• 2-3 years' experience in modern data architecture that support advanced analytics including Snowflake, Azure, etc. Experience with Snowflake and other Cloud Data Warehousing / Data Lake preferred

• Bachelor's Degree in Computer Science, Information Systems, Engineering, Business Analytics, or Business Management

• Expert in engineering data pipelines using various data technologies - ETL/ELT, big data technologies (Hive, Spark) on large-scale data sets demonstrated through years of experience

• Hands on data warehouse design, development, and data modeling best practices for modern data architectures

• Highly proficient in at least one of these programming languages: Java, Python

• Experience with modern data modelling tools, data preparation tools

• Experience with adding data lineage, technical glossary from data pipelines to data catalog tools

• Highly proficient in Data analysis - analyzing SQL, Python scripts, ETL/ELT transformation scripts

• Highly skilled in data orchestration with experience in tools like Ctrl-M, Apache Airflow. Hands on DevOps/Data Ops experience required

• Knowledge/working experience in reporting tools such as MicroStrategy, Power BI would be a plus

• Self-driven individual with the ability to work independently or as part of a project team

• Experience working in an Agile Environment preferred, Familiarity with Retail domain preferred

• Experience with Streamsets, dbt preferred

• Strong communication skills are required with the ability to give and receive information, explain complex information in simple terms and maintain a strong customer service approach to all users

PHYSICAL REQUIREMENTS/ADA:
This position requires the ability to work in an office environment, including using a computer, attending meetings, working as part of a team, and the ability to communicate with team members and others. Regular attendance also is a requirement of the position.
This position may be performed remotely anywhere within the United States. #LI-Remote

SUPERVISORY RESPONSIBILITIES:
N/A

DISCLAIMER:
This job description is a summary of the primary duties and responsibilities of the job and position. It is not intended to be a comprehensive or all-inclusive listing of duties and responsibilities. Contents are subject to change at management's discretion.

Ross is an equal employment opportunity employer. We consider individuals for employment or promotion according to their skills, abilities and experience. We believe that it is an essential part of the Company's overall commitment to attract, hire and develop a strong, talented and diverse workforce. Ross is committed to complying with all applicable laws prohibiting discrimination based on race, color, religious creed, age, national origin, ancestry, physical, mental or developmental disability, sex (which includes pregnancy, childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), veteran status, military status, marital or registered domestic partnership status, medical condition (including cancer or genetic characteristics), genetic information, gender, gender identity, gender expression, sexual orientation, as well as any other category protected by federal, state or local laws.