Data Engineer I

Key Responsibilities

• Design and implement data and analysis infrastructure.
• Determine appropriate data management systems for analysis.
• Build, maintain, and optimize data pipelines.
• Move data pipelines effectively into production for key data consumers.
• Provide data expertise when building and testing stories, features, and components.
• Participate in the development and management of application programming interfaces (APIs) that access key data sources.
• Guarantee compliance with data governance and data security requirements.
• Create, improve, and operationalize integrated and reusable data pipelines to enable faster data access, integrated data reuse, and improve time-to-solution for data initiatives.
• Contribute to the development of the team backlog and architectural runway.
• Manage work in process (WIP) levels.
• Support engineering aspects of program and solution Kanban.
• Participate in program increment planning, pre- and post- planning, system, and solution demos, and inspect and adapt events.
• Participate as part of the Agile Development Team.

Essential Job Functions

• Assist in building and maintaining data pipelines and data management solutions using Snowflake, Coalesce, SQL, and Python.
• Assist in managing and monitoring data pipelines and workflows using Airflow and other orchestration technologies.
• Develop and support data transformation processes used to extract, transform, and load data between systems.
• Assist with data integrations, conversions, imports, and exports involving Workday and other internal and external systems.
• Assist in troubleshooting and resolving programming, pipeline, and production support issues while developing root-cause analysis skills.
• Learn and use modern data preparation, integration, automation, cloud, and AI-enabled tools and techniques.
• Assist in implementing processes that support data integrity, standardization, and quality.
• Contribute to data reliability, efficiency, quality, and automation improvements.
• Assist in maintaining data dictionaries, metadata, data mappings, technical specifications, test cases, and production support documentation.
• Work closely with product teams, engineers, analysts, and business partners to understand data requirements and contribute to the development of technical solutions.
• Participate in Agile Team activities and contribute to regularly producing product increments.
• Perform other duties as assigned.

Requirements & Tech Stack

• SQL experience.
• Python experience.
• Ability to troubleshoot programming and technical issues.
• Basic understanding of data engineering concepts.
• Basic understanding of data integration, data quality, and data transformation.
• Problem-solving skills.
• Ability to collaborate with business and IT stakeholders.
• Ability and willingness to learn new technologies.
• Good to have: Experience in an Agile environment.
• Good to have: Experience or exposure to Snowflake, Coalesce, Workday, or Airflow.
• Good to have: Relevant technical certification.
• Good to have: ETL/ELT and data pipeline development.
• Good to have: REST APIs.
• Good to have: Agile methodologies.
• Good to have: DevOps concepts.
• Good to have: Data modeling.
• Good to have: Metadata management.
• Basic Ability: Learn and use advanced analytics tools for object-oriented/object function scripting.
• Basic Ability: Work across multiple deployment environments including cloud and on-premises, and multiple operating systems.
• Basic Ability: Work with popular data discovery, analytics, and business intelligence (BI) software tools for semantic-layer-based data discovery.
• Basic Ability: Collaborate with both business and IT stakeholders.
• Basic Ability: Use judgment to form conclusions that may challenge conventional wisdom.
• Basic Ability: Apply original thinking to produce new ideas and innovate.
• Basic Knowledge: Data management disciplines including data integration, modeling, optimization, and data quality, and/or other areas directly relevant to data engineering responsibilities and tasks.
• Basic Knowledge: Popular database programming languages for relational and non-relational databases.
• Basic Knowledge: Representational state transfer (RESTful) API design.
• Basic Knowledge: Agile methodologies and capable of applying DevOps principles to data pipelines to improve the communication, integration, reuse, and automation of data flows.

Qualifications

• Bachelor’s degree in IT Engineering, Computer Science, Business Management, Mathematics, Information Technology, Computer Engineering, or Information Sciences preferred, or equivalent experience.
• Typically requires 0-2 years of experience in the desired field or may have entry level technical or business work experience, including internships.
• Preferred: Experience in an agile environment strongly preferred.
• Preferred: Relevant certification is preferred.

Compensation & Benefits

• Pay Range: $73,000 - $98,000 per year
• Benefits:
• Health, Dental and Vision Insurance
• Generous 401(k) with company match
• Paid Time Off (PTO) with Paid Holidays
• Flexible/Hybrid Work Schedule
• Paid Volunteer Program