BI Analyst I

About Us:

Mid-States Distributing ("Mid-States") is the leading Farm, Ranch, and Home Retail Cooperative. Our company is owned by 29 independent Farm, Ranch & Home retailers (“Members”) who operate over 700 stores in 33 states with combined annual sales in excess of 7 billion dollars. Our member/owners retail items such as agriculture parts & supplies, petroleum products, hardware & tools, pet food, lawn & garden, animal health supplies, apparel & footwear, sporting goods, and various other products for the Farm, Ranch, and Home.

We are looking for competitive people who like to win big and have fun doing it. We place a tremendous amount of emphasis on creating a unique and positive company culture. Most of our employees will tell you this is the best place they’ve ever worked. We value high-energy people who like to work hard and play hard. Our consumers are primarily rural people raising “kids, pets, cows, and crops” so traditional values like God, family, and patriotism are important virtues around here. So, if you are enthusiastic and competitive, have a great attitude, have good communication skills, build relationships, love to win, and like ice cream – Mid-States is the place for you! If you are not, please apply with our competitors!

POSITION OVERVIEW:

The BI Analyst I is responsible for designing, developing, and implementing scalable business intelligence solutions that empower data-driven decision-making across the organization. This role involves collaborating with stakeholders to translate business requirements into robust data architectures, ensuring data integrity, availability, and optimal performance for BI systems. They ensure that a formal data standard is adhered to and that the company’s data assets align with the business's goals, establishing and maintaining a cohesive data strategy for both internal and external data.

The BI Analyst I is expected to partner with the BI team, senior leaders, and product teams to create scalable, flexible, and reporting solutions that address customer business problems, leveraging Domo as our primary platform for data ingestion, transformation, and visualization.

KEY RESPONSIBILITIES:

• Develop and maintain data models and ETL (Extract, Transform, Load) processes to ensure efficient data storage, integration, and retrieval.
• Collaborate with stakeholders to gather and analyze business requirements, translating them into technical specifications and actionable BI solutions.
• Ensure data accuracy, consistency, and availability across all BI systems and reporting environments.
• Create and maintain connections to various data sources in Domo via API, direct query, no code JSON, etc.
• Identifies opportunities for standardization of existing workflows and developing more efficient processes to support maximum efficiency and productivity.
• Mentor and guide team members, fostering a collaborative and knowledge-sharing environment.
• Establish and enforce best practices, standards, and guidelines for BI development and implementation.
• Continuously evaluate and recommend improvements to existing BI solutions, staying current with emerging BI technologies and trends.

MINIMUM QUALIFICATIONS, SKILLS, AND EXPERIENCE:

• Bachelor’s degree in computer science, Information Systems, or a related field. Equivalent work experience will be considered.
• Minimum of 1 year of experience in data analysis, reporting, business intelligence, and/or other related roles.
• Proficiency with BI tools (e.g., Domo, Power BI, Tableau) and knowledge of ETL processes. Experience with Domo and D365 is a plus.
• Have used programming languages such as SQL for data manipulation. R, HTML, CSS, Python, and JavaScript would be a plus.
• Demonstrated experience in data visualization, creating reports and dashboards, and working with large and complex datasets.
• Excellent analytical, problem-solving, and communication skills.
• Strong understanding of data security and compliance best practices.
• Proven experience leading BI projects and managing stakeholder expectations.

PHYSICAL REQUIREMENTS:
Generally, the job requires 80% sitting, 10% walking, and 10% standing. This job is performed in a generally clean environment. The usual and customary methods of performing the job's functions require the following physical demands: some lifting, carrying, pushing, and/or pulling, some stooping and significant fine finger dexterity.

TRAVEL:
Some travel involved

OTHER DUTIES:
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this position. Duties, responsibilities, and activities may change at any time with or without notice.

Reasonable accommodations may enable individuals with disabilities to perform the essential functions.

A few words from our COO:

I have had the pleasure to work for some incredible companies during my career, but Mid-States is truly the best company I have ever worked for. Lead by our dynamic CEO, Tom Mahlke, our team strives to provide a unique, exciting, fun, and fulfilling work environment for our staff. Things like drama, laziness, and entitlement have no place in Mid-States, which makes Mid-States a refreshing place to work. We offer competitive salaries, have a fantastic benefits package, and believe in rewarding those who produce. We serve a wonderful industry, and we are financially sound and growing rapidly. If you are an enthusiastic, high-energy person with a positive attitude and the skills described above, you may have just found the last job you will ever apply for! I look forward to meeting you. – Jeff Rash, COO