Engineer II (Data Engineering)

$93,200 - $176,550/Yr

Ross-Shire Engineering - Washington, DC

posted about 2 months ago

Full-time - Mid Level
Washington, DC
1,001-5,000 employees
General Merchandise Retailers

About the position

The Data Engineer II plays a critical role in engineering data solutions that support Ross reporting and analytic needs. As a key member of the Data Engineering team, you will work on diverse data technologies such as Streamsets, dbt, data ops, and others to build insightful, scalable, and robust data pipelines that feed our various analytics platforms. This position is essential for ensuring that our data infrastructure is efficient and capable of meeting the growing demands of our analytics initiatives. In this role, you will be responsible for designing and modeling data engineering pipelines that support Ross's reporting and analytic needs. You will engineer efficient, adaptable, and scalable data pipelines for moving data from different sources into our Cloud Lakehouse. Understanding and analyzing business requirements will be crucial, as you will translate these into well-architected solutions that demonstrate the modern BI & Analytics platform. You will also be involved in data modernization projects, providing direction on overall design and technical direction, and acting as the primary driver toward establishing guidelines and approaches. Your responsibilities will include developing and deploying performance optimization methodologies, driving timely and proactive issue identification, escalation, and resolution. Collaboration will be key, as you will work effectively within Data Technology teams and Business Information teams to design and build optimized data flows from source to data visualization. This role requires a self-driven individual with the ability to work independently or as part of a project team, and strong communication skills are essential to explain complex information in simple terms and maintain a strong customer service approach to all users.

Responsibilities

  • 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 them into well-architected solutions that demonstrate the modern BI & Analytics platform.
  • Participate in data modernization projects providing direction on overall design and technical direction.
  • Develop and deploy performance optimization methodologies.
  • Drive timely and proactive issue identification, escalation, and resolution.
  • Collaborate effectively within Data Technology teams and Business Information teams to design and build optimized data flows from source to data visualization.

Requirements

  • 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 with demonstrable experience designing models for data warehousing and modern analytics use-cases.
  • 2-3 years' experience in modern data architecture that supports advanced analytics including Snowflake, Azure, etc.
  • 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.
  • 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 modeling tools and data preparation tools.
  • Experience with adding data lineage and 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 the Retail domain preferred.
  • Experience with Streamsets, dbt preferred.
  • Strong communication skills are required.

Nice-to-haves

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

Benefits

  • Accident, Critical Illness, Vision, Auto, Home, and Pet insurance programs
  • Associate Discount
  • Identity Protection
  • Associate Purchase Program
  • Benefit Hub Discount Mall
  • Employee Assistance Program
  • Commuter Benefits
  • 401K (service requirements)
  • Employee Stock Purchase Program
  • Ross Cares Fund
  • College Discounts
  • Sick Pay (where legally required)
  • Referral Bonuses
  • 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
  • Bonus based on individual and business performance.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service