DeveloperJobs.io
← Back to all jobs

Job Description

Natural Grocers is hiring an onsite Data Engineer I in Lakewood, CO to support data movement, ETL development, and reporting across multiple systems.

Responsibilities

  • Support, manage, transport, and report business data across multiple systems.
  • Design, build, monitor, and modify ETLs using various technical systems and technologies.
  • Build and manage ETL and API processes, including development, reverse engineering, and optimization using Python, shell/PowerShell, SSIS, and jobs/workflows with REST and/or SOAP APIs.
  • Troubleshoot data transfer problems across multiple systems.
  • Create datalakes, datawarehousing, and datamarts for business areas and technical tools (preferred: Databricks).
  • Develop programs and jobs to check data quality throughout systems.
  • Build solutions for users to address data quality issues, including an overall dashboard and feedback loops for incorrect data to support error resolution.
  • Use basic skills to support SQL database performance monitoring and query optimization.
  • Troubleshoot database and query performance on servers (RAM, Disk I/O, and processor performance).
  • Facilitate discussions for database maintenance activities such as indexes, statistics, and table keys.
  • Design, develop, and document reports based on business requirements.
  • Document ETL, API, and report development.
  • Provide basic training and user support to promote self-sufficiency.
  • Perform ad hoc analysis and reporting with quick turnaround.
  • Provide tier 2 support for reporting and analysis applications.
  • Troubleshoot SAP CDS views and develop simple CDS views (plus: Business Objects and SQL Server).
  • Maintain a hands-on approach to complete tasks needed to support company operations.

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 implementation.
  • Intermediate to advanced SQL coding (including Databricks, Hadoop, and T-SQL).
  • Advanced skills or experience developing and optimizing complex queries and stored procedures in one or more RDBMS platforms (required: SQL Server and/or Big Data).
  • Intermediate ETL experience with creation, change, and merging.
  • Intermediate API experience with creation, change, and merging (shell and Python preferred; also references ATL).
  • Experience troubleshooting SAP CDS views and developing simple CDS views (plus: Business Objects and SQL Server).
  • Experience updating legacy reports, including optimization and automation.
  • Basic networking knowledge and Windows/unix system administration.
  • Advanced skills or experience in one or more BI tools (required: Business Objects, SSRS, Power BI).
  • Strong communication and presentation skills (oral and written).
  • Innovative thinker and ability to work with and lead cross-functional teams (preferred).
  • HANA and Databricks experience is a plus.
  • Other job duties as required.

Technologies

  • Python, shell/PowerShell, SSIS, jobs/workflows
  • REST APIs, SOAP APIs, ETL, API, ATL
  • Databricks, SQL, Hadoop, T-SQL, SQL Server, Big Data
  • SAP CDS views, Business Objects
  • RAM, Disk I/O, processor performance
  • HANA
  • SSRS, Power BI
  • Windows/unix system administration

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) | Salary: $95,000 - $105,000 per year

Similar Jobs