Business Intelligence (BI) Analyst / Developer

Dairy Farmers of America • Kansas City, KS

9h

About The Position

The Business Intelligence (BI) Analyst / Developer participates in a cross-functional team responsible for developing and supporting core Dairy Farmers of America (DFA) business applications and processes. The role architects, develops, and provides operational support for Snowflake and Power BI data platforms, data warehousing, business intelligence, reporting, and visualization solutions serving a wide range of business functions and user communities. The position is part of DFA’s IT organization and follows applicable application, infrastructure, and governance processes.

The listed duties and qualifications describe the general nature and level of work and are not necessarily comprehensive. Other duties may be assigned as required.

Requirements

• Bachelor’s degree in Computer or Data Science, or equivalent experience.
• 2–3 years of experience as a SQL developer, Snowflake developer, Data Warehouse developer, or BI Developer.
• Strong skills with Snowflake and SQL.
• Able to communicate effectively in writing and verbally with business users, stakeholders, technical teams, and various levels of management.
• Able to work independently and on multiple projects simultaneously, including prioritizing work.
• Able to organize time and resources effectively to achieve goals.
• Able to demonstrate leadership qualities as a self-starter, set direction, and complete assignments.
• Able to interact effectively and cooperatively with employees at all levels.
• Strong customer service orientation and work ethic.
• Must be able to read, write, and speak English.

Nice To Haves

• Strong knowledge of SQL and relational data concepts.
• Knowledge of Snowflake architecture, development, and performance optimization.
• Working knowledge of Power BI and enterprise reporting concepts.
• Familiarity with working in an Agile development environment.

Responsibilities

• Design, develop, and maintain scalable Snowflake and Power BI data models, schemas, tables, and views for enterprise BI, analytics, and reporting.
• Build and optimize BI data pipelines and transformation processes for performance, reliability, and scalability.
• Develop and maintain transformations, stored procedures, tasks, and data integration processes within Snowflake and Microsoft.
• Translate business requirements into reusable, well-governed data models aligned with enterprise standards.
• Define and enforce development standards, naming conventions, data governance, and data modeling best practices.
• Coordinate development, testing, deployment, and change management with business analysts and BI team members.
• Identify opportunities to improve query performance, warehouse efficiency, data quality, cost management, and usability.
• Participate in an on-call rotation.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level