Data Engineer I

Natural Grocers•Lakewood, CO

About The Position

The Data Engineer I supports, manages, transports, and reports business data across multiple systems. The role designs, builds, monitors, and modifies ETLs using a range of technologies, and develops programmed and administrative solutions for data quality and access governance. It also provides end-user support for reporting and analysis tools, with an emphasis on helping users become self-sufficient. The position works with databases, APIs, reporting tools, and data lakes, warehouses, and marts. It includes troubleshooting data transfers and database performance, developing data-quality checks and user-facing solutions, documenting data processes and reports, providing training and Tier 2 application support, and conducting ad hoc analysis and reporting. Employees are expected to take a hands-on approach and perform other assigned duties as needed.

Requirements

Bachelor’s degree in Computer Science or Computer Information Systems, or equivalent experience.
At least 2 years of experience in data engineering.
Knowledge of database architecture and its implementation.
Intermediate to advanced SQL coding skills, including Databricks, Hadoop, or T-SQL.
Advanced SQL skills or experience developing and optimizing complex queries and stored procedures in one or more RDBMS or big-data platforms, such as SQL Server.
Intermediate ETL experience, including creating, changing, and merging ETLs.
Intermediate experience creating, changing, and merging APIs; shell and Python experience preferred.
Advanced skills or experience with one or more BI tools, such as Business Objects, SSRS, or Power BI.
Strong oral and written communication and presentation skills.
Basic networking knowledge and Windows or Unix system administration experience.

Nice To Haves

Experience with Databricks.
Experience troubleshooting SAP CDS views and developing simple CDS views, Business Objects, and SQL Server.
Experience updating legacy reports, including optimization and automation.
Innovative thinking and ability to work with and lead cross-functional teams.
Experience with HANA databases.

Responsibilities

Build and manage ETL and API processes, including development, reverse engineering, and optimization using technologies such as Python, shell or PowerShell, SSIS, jobs and workflows, and REST or SOAP APIs.
Troubleshoot data transfer problems across multiple systems.
Create data lakes, data warehouses, and data marts for business areas and technical tools.
Develop programs and jobs to check data quality across systems.
Create solutions for users to respond to data-quality problems, including dashboards and feedback mechanisms for resolving incorrect data.
Support SQL database performance monitoring and query optimization.
Troubleshoot database and query performance on servers, including RAM, disk I/O, and processor performance.
Facilitate discussions about database maintenance processes, including indexes, statistics, and table keys.
Design, develop, and document reports based on business requirements.
Document ETL, API, and report development.
Provide basic training and support to users to promote self-sufficiency.
Perform ad hoc analysis and reporting with quick turnaround.
Provide Tier 2 support for reporting and analysis applications.
Perform other job duties as required, including tasks assigned by a manager.

Benefits

Birthday bonus pay for all Crew Members.
Vitamin Bucks, with up to $2,080 earned as store credit annually.
Holiday pay for five holidays when stores are closed.
Paid time off for sick days and vacation, increasing with tenure.
Paid nutrition education.
Crew Member discount.
Regular scheduled pay increases.
Advancement opportunities and career development.
Health and Wellness Program.
Employee Assistance Program (EAP).
Employee Referral Program.
For full-time Crew Members working 30 or more hours per week: medical, dental, and vision insurance.
For full-time Crew Members working 30 or more hours per week: paid parental leave and paid medical leave through company-paid short-term disability insurance.
For full-time Crew Members working 30 or more hours per week: company-paid short-term disability insurance and company-paid life insurance.
For full-time Crew Members working 30 or more hours per week: voluntary benefits, including hospital indemnity, accident insurance, long-term disability insurance, and term life insurance.
For full-time Crew Members working 30 or more hours per week: 401(k) retirement savings plan with discretionary company match.
For full-time Crew Members working 30 or more hours per week: healthcare and dependent care flexible spending accounts (FSA).
For full-time Crew Members working 30 or more hours per week: health savings account (HSA) with company match.