Business Intelligence (BI) Analyst / Developer

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

Job summary

Dairy Farmers of America is seeking a BI analyst/developer to design, develop, and maintain Snowflake and Power BI data platforms for enterprise analytics. You will translate business requirements into governed data models, optimize pipelines, and support reporting across functions.

The role requires a Bachelor's in Computer or Data Science (or equivalent) and 2–3 years of SQL/Snowflake/BI development experience. On-site in Kansas City.

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.
• Experience with Power BI and enterprise reporting is a plus.

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

SQL

Snowflake

Power BI

Data modeling

Data warehousing

Agile development

Education

Bachelor's degree in Computer or Data Science

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

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