Data Engineer I
Analytics
API
Automation Developer
Big Data
Bigdata
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud Data Engineering
Cloud Data Platform
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Databricks
Design
Digital Marketing
Engineer
ETL
Hadoop
Hr Technology
Informatica
Information Technology (IT)
Integration
Microsoft
Microsoft 365
Microsoft Office
Microsoft Power Platform
MS SQL
Office Tools
Power BI
Power Platform
Product Management
Reporting and Analytics
Software Development
SQL
Sql Server Integration Services
Visual Design
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
C