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 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
C