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
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, manage, transport, and report business data across multiple systems. This onsite role in Lakewood, CO focuses on building and maintaining ETLs, improving data quality and access governance, and enabling reporting tools that help users become self-sufficient.
Key Responsibilities
- Support, manage, transport, and report business data across multiple systems.
- Design, build, monitor, and modify ETLs using multiple technologies, including solutions that support data quality and access governance.
- 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 issues across multiple systems.
- Create data lakes, data warehousing, and data marts for business areas and technical tools, with Databricks preferred.
- Develop programs and jobs to validate data quality across systems.
- Create solutions for resolving data quality problems, including an overall dashboard and feedback loops for incorrect data.
- Provide SQL database performance monitoring and query optimization support.
- Troubleshoot database and query performance on servers, including RAM, Disk I/O, and processor performance.
- Facilitate discussions related to 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 help users maintain self-sufficiency.
- Perform ad hoc analysis and reporting with quick turnaround as needed.
- Provide Tier 2 support for reporting and analysis applications.
- Support troubleshooting for SAP CDS views and develop simple CDS views, with Business Objects and SQL Server as plus.
- Maintain a hands-on approach and perform other duties as required to help the company thrive.
Required Qualifications
- Bachelor’s degree in Computer Science or Computer Information Systems, or equivalent.
- 2+ years of experience in data engineering.
- Knowledge of database architecture and its implementation.
- Intermediate to advanced SQL coding experience (including Databricks, Hadoop, and T-SQL).
- Advanced skills or experience developing and optimizing complex queries and stored procedures in one or more RDBMS platforms, including SQL Server and/or Big Data.
- Intermediate ETL experience creating, changing, and merging ETL solutions.
- Intermediate API experience creating, changing, and merging APIs; shell and Python preferred.
- Experience updating legacy reports with optimization and automation.
- Basic networking knowledge and Windows/unix system administration.
- Advanced skills or experience in one or more BI tools: Business Objects, SSRS, or Power BI (required).
- Strong communication and presentation skills (oral and written).
- Innovative thinking 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.
Work Location and Compensation
- Location: Lakewood, CO (onsite)
- Salary: USD 95,000 - 105,000 per year
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 a congested worksite.
Similar Jobs
C