DataJobs.io
← Back to all jobs

Job Description

Natural Grocers is hiring a Data Engineer I to support end-to-end business data operations across multiple systems, with an emphasis on ETL, data quality, and user self-sufficiency.

Responsibilities

  • Support, manage, transport, and report business data across multiple systems.
  • Design, build, monitor, and modify ETLs using a range of technologies.
  • Build and manage ETL and API processes, including development, reverse engineering, and optimization using Python, shell/PowerShell, SSIS, jobs/workflows, and REST and/or SOAP APIs.
  • Troubleshoot data transfer problems across multiple systems.
  • Create data lakes, data warehouses, and data marts for business areas and technical tools (Databricks preferred).
  • Develop programs and jobs to check data quality throughout connected systems.
  • Create solutions to help users resolve data quality issues, including an overall dashboard and feedback capture for incorrect data.
  • Provide basic skills for SQL database performance monitoring and query optimization.
  • Troubleshoot database and query performance on servers, including RAM, disk I/O, and processor performance.
  • Facilitate discussions for database maintenance processes, including indexes, statistics, and table keys.
  • Design, develop, and document reports based on business requirements.
  • Document ETL, APIs, and report development.
  • Provide basic training and support to promote user self-sufficiency.
  • Perform ad hoc analysis and reporting with quick turnaround.
  • Provide tier 2 support for reporting/analysis applications.
  • Troubleshoot SAP CDS views and develop simple CDS views, with Business Objects and SQL Server as plus.
  • Undertake additional hands-on tasks needed to get the work done.

Requirements

  • Bachelor’s degree in Computer Science or Computer Information Systems (or equivalent).
  • 2+ years of experience in data engineering.
  • Knowledge of database architecture and how to implement it.
  • Intermediate to advanced SQL coding (Databricks, Hadoop, T-SQL).
  • Advanced SQL skills or experience optimizing complex queries and stored procedures in one or more RDBMS platforms (SQL Server and/or Big Data required).
  • Intermediate ETL experience creating, changing, and merging ETL workflows.
  • Intermediate API (ATL) experience creating, changing, and merging APIs, with shell and Python preferred.
  • Experience troubleshooting SAP CDS views and developing simple CDS views; Business Objects and SQL Server as plus.
  • Experience updating legacy reports, including optimization and automation.
  • Basic networking knowledge and Windows/unix system administration.
  • Advanced skills or experience with one or more BI tools: Business Objects, SSRS, Power BI (required).
  • Strong communication and presentation skills (oral and written).
  • Innovative mindset and ability to work with and lead cross-functional teams (preferred).
  • Experience with HANA databases and Databricks is a plus.

Technologies

  • Python
  • Shell/PowerShell
  • SSIS
  • Jobs/Workflows
  • REST APIs
  • SOAP APIs
  • Databricks
  • SQL
  • Hadoop
  • T-SQL
  • SQL Server
  • Big Data
  • SAP CDS views
  • Business Objects
  • RAM
  • Disk I/O
  • Processor performance
  • HANA
  • SSRS
  • Power BI
  • ETL
  • API
  • ATL
  • Windows/Unix

Benefits

  • Birthday Bonus Pay
  • Vitamin Bucks (up to $2,080 earned as store credit annually)
  • Holiday Pay for 5 Holidays (stores closed)
  • Paid Time Off (sick days and vacation) that increases with tenure
  • Paid Nutrition Education
  • good4u Crew Member Discount
  • {N}power Program (customer appreciation and rewards program)
  • Regular, scheduled pay increases
  • Advancement opportunities and career development
  • Health and Wellness Program
  • Employee Assistance Program (EAP)
  • Employee Referral Program
  • Medical, Dental and Vision Insurance
  • Paid Parental Leave
  • Paid Medical Leave (through company paid short-term disability insurance)
  • Company Paid Short-Term Disability Insurance
  • Company Paid Life Insurance
  • Voluntary benefits including Hospital Indemnity, Accident Insurance, Long-Term Disability Insurance, Term Life Insurance
  • Retirement Savings Plan (401k) with discretionary company match
  • Healthcare and Dependent Care Flexible Spending Account (FSA)
  • Health Savings Account (HSA) with company match

Physical Requirements

  • Occasionally lift or carry up to 50 lbs.
  • Occasionally push or pull up to 30 lbs.
  • Constantly use the computer for data entry and use of mouse.
  • Constantly sit, use fine motor manipulations, and reach outward for the duration of the work shift.
  • Frequently grip, bend, twist, and turn.
  • Occasionally walk, stand, squat, kneel, and reach above chest as needed.

Environmental Requirements

  • Occasionally work with cold, heat, sharp tools/equipment, noise, contact stress, dust, fumes, and congested worksite.

Location: Lakewood, CO (onsite)

Compensation: USD 95,000 - 105,000 per year

Similar Jobs