Business Intelligence (BI) Analyst /Developer in Kansas City KS

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 business intelligence, data warehousing, 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 deploy logical or physical data models that support information delivery and the data visualization needs of the business using data warehousing concepts and dimensional data modeling?
• Design, develop, and deploy ETL Scripts and pipelines
• Acquire data from various and multiple sources, transforming it to reporting ready data marts based on business requirements
• Co-ordinate data modeling, ETL development, and testing activities with teammates and business resources
• Create technical specifications for data flows and transformations
• Follow established standards
• Create and execute test scripts with business reporting analysts
• Ensure data quality with data modelers and / or business analysts through regression testing and troubleshooting
• Deliver data models using agile development releases
• Coordinate change management with business analysts and BI analytics teammates
• Maintain outbound interfaces using API, FTP, email, etc
• Test new technologies to assist the company in becoming a data driven organization
• 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