Business Intelligence Data Architect

Who We Are:

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 Data Architect 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 Data Architect is expected to partner with the BI team, senior leaders, and product teams to create scalable, flexible, and resilient architectures that address customer business problems, leveraging Domo as our primary platform for data ingestion, transformation, and visualization.

ESSENTIAL FUNCTIONS:

• Design and implement scalable BI architectures to support business objectives and strategic decision-making.
• 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.
• 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, COMPETENCIES, AND EXPERIENCE:

• Bachelor s degree in computer science, Information Systems, or a related field. Equivalent work experience will be considered.
• Minimum 5 years of experience in BI architecture, data warehousing, and data modeling.
• Proficiency with BI tools (e.g., Domo, Power BI, Tableau) and strong knowledge of ETL processes. Experience with Domo is a plus.
• Have used programming languages such as SQL, Python, JavaScript for data manipulation. R, HTML, CSS would be a plus.
• Experience designing and implementing data models, database structures, and data integration solutions.
• 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 AND WORK ENVIRONMENT:

• Ability to stand, walk, reach, climb, bend and kneel
• Ability to lift up to 30 pounds frequently and 50 pounds+ occasionally
• Ability to reach above and below the shoulders
• Ability to use hands and fingers to grasp, twist, and pull
• Ability to withstand external weather conditions (rain, cold, heat or other adverse weather) to perform tasks as assigned

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 job. Duties, responsibilities, and activities may change at any time with or without notice.

A few words from our COO:

Mid-States is truly the best company I have ever worked for. We strive to provide a unique, exciting, fulfilling work environment for our staff. We are cautious when we hire because we want to protect that environment. Drama, laziness, and entitlement have no place in Mid-States. Our company is very financially sound and growing like crazy. 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