What are the responsibilities and job description for the Data Engineer - Kansas City Metro area position at Bartlett?
Come grow with us! Established in 1907, Bartlett, a Savage Company, is a diverse agribusiness focused on the acquisition, storage, transportation, processing, and merchandising of grain. As part of Savage, Bartlett has been designated by USA Today as a Top Workplace and received recognition as a Military Friendly Employer and a Top Company for Women to Work For in Transportation.
Military Veterans and Reservists are encouraged to apply.
The Basics
Location Requirement: Kansas City, MO
Days/Hours: Monday – Friday 8 a.m. – 5 p.m.
As a Data Engineer at Bartlett, you will be a key contributor in enabling data-driven decision-making processes within our organization. You will collaborate with business and technical teams across various dimensions of the data analysis pipeline to shape, optimize, and maintain our data landscape. You will leverage your proficiency in data modeling, transformation, analysis, and reporting to create, modify, and sustain robust data pipelines and reports. Applying data warehousing standards, you will design and implement data structures that enable efficient storage and retrieval of enterprise information. You will participate in expanding and improving the Savage data pipeline, including sourcing, integration, and performance optimization.
As a team, we seek to continuously improve the access, timeliness, discoverability, and accuracy of the data we provide to the organization. You will contribute to our data-driven journey and empower our organization to make informed decisions with confidence.
These are just a few of the benefits you can expect from working with Savage:
Military Veterans and Reservists are encouraged to apply.
The Basics
Location Requirement: Kansas City, MO
Days/Hours: Monday – Friday 8 a.m. – 5 p.m.
As a Data Engineer at Bartlett, you will be a key contributor in enabling data-driven decision-making processes within our organization. You will collaborate with business and technical teams across various dimensions of the data analysis pipeline to shape, optimize, and maintain our data landscape. You will leverage your proficiency in data modeling, transformation, analysis, and reporting to create, modify, and sustain robust data pipelines and reports. Applying data warehousing standards, you will design and implement data structures that enable efficient storage and retrieval of enterprise information. You will participate in expanding and improving the Savage data pipeline, including sourcing, integration, and performance optimization.
As a team, we seek to continuously improve the access, timeliness, discoverability, and accuracy of the data we provide to the organization. You will contribute to our data-driven journey and empower our organization to make informed decisions with confidence.
These are just a few of the benefits you can expect from working with Savage:
- A culture that appreciates team members
- Excellent benefits including medical, dental, vision, PTO, paid holidays, profit sharing, and 401(k) with match.
- Paid Parental and Uniformed Services Leave
- Develop and maintain complex SQL queries and stored procedures for data integration jobs and models.
- Design, develop, and optimize Integration packages.
- Document SQL queries, SSIS packages, and data models for clarity and reproducibility.
- Create and maintain reporting and visualization solutions using Power BI and SSRS.
- Collaborate with business teams to design effective solutions using SQL and SSIS.
- Promote a culture of quality and shared ownership of solutions.
- Identify, document, and track work items and participate in project planning.
- Stay updated on best practices and emerging technologies related to data engineering.
- Review and debug large stored procedures optimizing performance and troubleshooting errors.
- Qualified applicants outside of the listed tech stack are encouraged to apply, such as AirFlow, Postgres, AWS Aurora, AWS Glue, Snowflake
- Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience).
- 3 years of hands-on SQL development and optimization experience.
- 2 years of SSIS and Python experience for ETL/ELT processes.
- Proven experience in data modeling and reporting with SQL, SSRS, SSIS, and Power BI.
- Strong problem-solving skills and attention to detail with a focus on SQL and SSIS.
- Excellent communication and teamwork skills.
- Ability to adapt to fast-paced development cycles and changing priorities.
- A complete job description is available upon request
- Savage is an Equal Opportunity Employer and maintains a drug-free workplace
- California Residents Job Application Privacy Notice https://savageco.com/careers/california-residents-job-applicant-privacy-notice/
