Business Intelligence (BI) Analyst / Developer

Dairy Farmers of America; Kansas City (KS); On-site; USD 75,000 - 105,000; Full time

Job summary

Dairy Farmers of America seeks a BI Analyst/Developer to architect and build Snowflake data models, pipelines, and Power BI reports that support enterprise analytics and decision-making. You will collaborate with cross-functional teams to maintain governance and data quality while optimizing performance.

The role requires 2–3 years in SQL/Snowflake/Data Warehouse development, with strong SQL and Snowflake skills, and the ability to work independently in a fast-paced IT environment.

Qualifications

• 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.

Responsibilities

• Design, develop, and maintain scalable Snowflake/Power BI data models, schemas, tables, and views to support enterprise BI, analytics, and reporting.
• Build and optimize BI data pipelines and transformation processes, ensuring efficient performance, reliability, and scalability.
• Develop and maintain transformations, stored procedures, tasks, and data integration processes within Snowflake and Microsoft.
• Translate business requirements into well-governed, reusable 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 activities with business analysts and BI team members.
• Proactively identify opportunities to improve query performance, warehouse efficiency, data quality, cost management, and usability.

Skills

On-call readiness

Multi-project management

Independent worker

Communication skills

Education

Bachelor’s degree in Computer or Data Science

Tools

Snowflake

SQL

Power BI

Job description

Business Intelligence (BI) Analyst / Developer

#38550

Company

Dairy Farmers of America

Description

Participate in a cross-functional team environment responsible for development and support of core Dairy Farmers of America (DFA) business applications and processes. The Business Intelligence (BI) analyst / developer will architect, develop, and provide operational support skills to deliver and maintain Snowflake and Power BI data platforms, data warehousing, business intelligence, reporting, and visualization solutions for a wide range of business functions and user communities. The BI analyst / developer will function as part of DFA’s IT organization and follow relevant applications, infrastructure and governance processes.

Job Duties and Responsibilities

• Design, develop, and maintain scalable Snowflake/Power BI data models, schemas, tables, and views to support enterprise BI, analytics, and reporting.
• Build and optimize BI data pipelines and transformation processes, ensuring efficient performance, reliability, and scalability.
• Develop and maintain transformations, stored procedures, tasks, and data integration processes within Snowflake and Microsoft.
• Translate business requirements into well-governed, reusable 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 activities with business analysts and BI team members.
• Proactively identify opportunities to improve query performance, warehouse efficiency, data quality, cost management, and usability.
• The requirements herein are intended to describe the general nature and level of work performed by employee, but is not a complete list of responsibilities, duties, and skills required.Other duties may be assigned as required.

Requirements

Education and Experience:

• 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

Preferred Qualifications

• 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

Knowledge, Skills and Abilities

• Able to work on-call rotation
• Able to demonstrate written and verbal communications skills with the ability to effectively communicate with business users, stakeholders, technical teams, and various levels of management
• Able to work independently
• Able to work on multiple projects simultaneously, including the ability to prioritize
• Able to organize time and resources effectively to achieve goals (i.e., organizational skills)
• 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
• Able to demonstrate strong customer service orientation
• Strong work ethic
• Must be able to read, write, and speak English

An Equal Opportunity Employer including Disabled/Veterans

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us: [e-mail] or 877-215-8701.