"Alerted.org

Sleepy Eye, MN, USA | Information Technology - IT | Salary | 83,000-104,750 per year | Full Time

Christensen Farms is one of the largest, family-owned pork producers in the United States, marketing approximately 3 million hogs per year. Headquartered in Sleepy Eye, Minnesota, the company operates throughout the Midwest with facilities in Minnesota, Iowa, Nebraska, Illinois, and South Dakota. Christensen Farms owns four feed mills, manages 145,000 sows on 44 farms, and oversees more than 350 nurseries and grow-finish sites. The company employees nearly 1,000 people and maintains 1,500 contract partnerships.

Position Overview & Responsibilities

Christensen Farms is looking for a self-motivated Data Engineer to join our Decision Science team. In this position, you will play a significant role in helping grow and modernize our analytics services. As part of the company's data operations, the data engineer will ensure accuracy in decision science and reporting as well as responsibility for collecting, managing, and converting raw data into information that can be interpreted by the business. You will design and develop data collection frameworks for structured and unstructured data including Data Pipelines, ELTs and ETLs to connect large datasets from a variety of sources. You will also engineer reports, dashboards, and visualizations using enterprise business intelligence tools.

This individual will need effective communication skills, communicating up, down and across the organization. This individual will also require the skill to multitask and manage simultaneous project activities that require innovative problem solving. Our ultimate goal is data accessibility to enable the organization to leverage data for performance evaluation and optimization.

What You Will Do:

+ Engineer and implement data models for dimensions and facts within the staging and warehouse layer of our enterprise data lake house.

+ Engineer and implement new and modify existing ETLs, data pipelines, and ELTs to move data from a variety of source systems, including structured and unstructured data, to fit into dimensional data models with large data sets.

+ Engineer schedules and orchestrations for batch and near real time data loads into the enterprise data lake house.

+ Troubleshoots, identifies issues and remediates data performance issues that come with developing, querying, and combining large data sets from a variety of sources.

+ Collaborate with a variety of business users to understand definitions of data, analytics use cases,and assist in building data governance and detailed data requirements.

+ Support and establish reports, dashboards, and visualizations using Power BI.

+ Responsible for executing simultaneous project activities that require innovative problem solving.

+ Provides 2nd level employee support for decision science services.

+ Research tools, disciplines and industry trends and recommend improvements for team or company consideration.

+ Other duties assigned within the scope, responsibility, and requirements of the job.

What You Offer Us:

+ Minimum formal education required: Bachelor's degree in data and analytics or an IT related discipline or 4+ years of equivalent work experience. Masters degree preferred.

+ 2 or more years of experience in a corporate IT Team environment.

+ Exceptional technical skills required. Cloud based tools (examples include Power BI, Data Factory, Databricks, Snowflake, H20.ai, Excel, database management, etc.).

+ 2-3+ years Programming/scripting experience (SQL and/or Python) and working knowledge of the software development life cycle.

+ 2+ years of experience engineering within a data warehouse or related experience with dimensional data modeling.

+ 2+ years of experience designing and developing ETLs with tools like Microsoft SSIS

+ Proven ability to gather detailed technical requirements to design and develop business intelligence report solutions from beginning to end.

+ Clear, concise, and precise written and verbal communication skills to effectively communicate with people of various backgrounds including non-technical audiences.

+ Ability to multi-task and to prioritize objectives, anticipate situations and take quick action.

+ Computer skills required: Working knowledge of Microsoft Office Suite including Visio

+ Strict adherence to company confidentiality and ethical standards.

Additional Desirable Skills/Qualifications

+ Certifications in any of the following are a plus: DASCA (Associate or Senior), IBM Certified Solution Architect, SAS Certified Big Data Professional, ITIL.

+ Enterprise application experience

+ Cloud technologies (Public, Private, Dedicated, Hybrid).

+ Experience in Level 2 and/or Level 3 employee support (Freshservice or similar ITSM tool).

+ Employee computing devices including Windows, Android, and iOS.

+ Experience working in an agricultural business, particularly the swine industry.

What We Offer You:

+ Future leadership career track within data science/engineering in a visible role with exposure to a wide range of technologies.

+ Opportunity to grow at a leading adopter of AI/ML and predictive modeling within a fast-paced ag industry.

+ We offer a comprehensive benefits package including health, dental, vision, a flexible spending account (FSA), life insurance, short-term disability, long-term disability, a 401(k) plan, paid holidays, paid time off bank, an employee assistance program (EAP), and more.

+ Be part of an organization that gives back to the community in many ways---including feed programs that support local farms, food shelf programs, food support for veterans, agriculture education and promotion, FFA/4H support, charitable contributions, etc.

+ A company that has a passionate purpose for food safety, animal welfare, and for living its core values every day--respect, integrity, excellence, adaptability, and innovation.

+ A culture that fosters employee growth, promotion from within, and a highly team-oriented workplace environment.

+ The targeted base pay range for this role is: $83,000 to $104,750 with this range reflecting differences in candidate knowledge, skills, and experience.

Reports to:

Data Architect