Data Engineer I

iHerb

Job Summary:

The Data Engineer I is responsible for creating and maintaining pipelines that provide essential data for reporting and analytics across the company.

Job Expectations:
• Designs and develops pipelines that support data ingestion, curation, and provisioning of complex enterprise data to support analytics and reporting in our current technology stack.
• Provides successful deployment and provisioning of data solutions to required environments.
• Designs and builds data architecture and applications that successfully enable speed, quality, and efficient pipelines.
• Under the guidance of a senior lead member, full participation in the data pipeline continuous integration and continuous delivery (CI/CD) processes is required.
• Work under guidance of a senior lead member to develop data pipeline jobs throughout their lifecycle.
• Assist in the design and build efficient data models for robust business intelligence, analytics, and engineering needs that remain.
• Demonstrate initiative by seeking potential business issues and proactively solve them.
• Analyze and translate business needs into data models to support long-term, scalable, and reliable solutions.
• Interacts with cross-functional customers and development team to gather and define requirements.
• Reviews discrepancies in requirements and resolves with stakeholders in a timely manner.
• Build strong cross-functional partnerships with Data Scientists, Analysts, Product Managers and Software Engineers to understand data needs and deliver on those needs.

The duties and responsibilities described above may provide only a partial description of this position. This is not an exhaustive list of all aspects of the job. Other duties and responsibilities not outlined in this document may be added as necessary or desirable, with or without notice.

Knowledge, Skills and Abilities:
• 1+ years of programming skills with Python.
• Experienced in Agile methodologies & DevOps approach to maintaining pipelines and databases.
• Excellent knowledge of software engineering fundamentals.
• Experience in developing pipelines with CICD principles
• Proficiency with Databricks (DLT, Medallion Architecture, Lakehouse Concepts, etc) preferred.
• Experience with SQL.
• Had exposure to data modeling principles and patterns (star and snowflake DM, ER).
• Relational and non-relational data structures, theories, principles, and best practices.
• Knowledge of data privacy regulations (GDPR, CCPA, CRPA) and the impact these regulations have on data engineering framework.
• Strong problem-solving and analytical skills.
• Passion for data engineering and for enabling others by making their data easier to access.
• Be proactive, requiring minimal supervision with strong time management or organization skills.
• Must be an inquisitive learner and have a thirst for improvement.
• Excellent verbal and written communication skills.

Equipment Knowledge:
• Experience with Microsoft Office Suite (Word, Excel, PowerPoint)
• Experience with Google Business Suite (Gmail, Drive, Docs, Sheets, Forms) preferred.
• Databricks Engineer Associate Certification preferred.
• AWS Certifications, preferred:
■AWS Certified Solutions Architect – Associate/Professional
■AWS Certified Developer– Associate/Professional
■AWS Certified DevOps Engineer – Associate/Professional
■AWS Certified Data Analytics
■AWS Certified Security - Specialty
■AWS Certified Cloud Practitioner

Experience Requirements:

1-3 years as a Data Engineer

Education Requirements:

Bachelor or Master's degree in Computer Science, Engineering, Information Systems, or related (STEM) fields preferred, or a combination of education and equivalent work experience

Judgment/Reasoning Ability: Able to identify, troubleshoot and resolve problems quickly using sound judgment, poise and diplomacy. Ability to use judgment and reasoning skills, and determine when to escalate issues, as required, in a timely manner.

Physical Demands: The physical demands described here are representative of those that must be met by a Team Member to successfully perform the essential functions of this job. While performing the duties of this job, the Team Member is regularly required to talk and hear. The Team Member is frequently required to sit, walk, climb stairs, use hands and fingers, bend, stoop and reach with hands and arms. Reaching above shoulder heights, below the waist or lifting as required to file documents or store materials throughout the work day. The Team Member may occasionally lift or move office products and supplies up to 25 pounds. Proper lifting techniques required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Work Environment: The noise in the work environment is usually moderate. Other factors are:
• Hectic, fast-paced with multi-level distractions
• Professional, yet casual work environment
• Office / Warehouse environment
• Ability to work extended hours a

Location: United States

Posted: Aug. 19, 2024, 7:10 p.m.