MKC - Mid Kansas Coop · 7 hours ago
Business Intelligence (BI) Developer
Wichita,KS,US
Full-time
Onsite
Mid Level
3+ years expMKC - Mid Kansas Coop is seeking a Business Intelligence (BI) Developer to create and manage BI and analytics solutions that transform data into actionable insights. The role involves developing, maintaining, and supporting Microsoft BI reports and analytics solutions while ensuring best practices and standards for BI and data solutions are followed.
Agriculture
Responsibilities
Create actionable reports using SQL Server Reporting Services
Identify data quality problems and their root cause. Propose fixes and create data audits to ensure problem is resolved
Define, plan and implement moderately complex solutions as assigned
Manage the business analysis, requirements gathering and functional design of BI and data solutions including use cases, analytical workflows, business dimensional models and user interface
Manage the technical design of BI and data solutions including logical and physical data modeling, ETL data flow and source-to-target mapping, security design, etc
Suggest, document and implement improvements to current BI processes by leveraging functionality
Coordinates with users to gain understanding of needed changes or modifications of existing programs in order to understand and meet their needs
Maintain confidentiality with regard to the information being processed, stored or accessed
Maintains documentation of database systems
Performs other non-essential duties as assigned
Qualification
Required
Expert knowledge of database development including table design, SQL queries and stored procedures
Extensive experience designing, developing and supporting Microsoft SQL Server Analytics Services (SSAS) applications
Experience designing and developing SQL reports, Crystal Reports, SQL Server Reporting Services (SSRS) and SQL Integration Services
Strong working knowledge of Microsoft OLAP Cube concepts, i.e. OLAP processing, capacity planning, performance tuning and administration dimensions, hierarchies, aggregations, measures, KPI's, calculations, storage and partitions, etc
Strong working knowledge of Microsoft Business Intelligence and database technologies; SSRS, SSIS, SQL Server 2014, T-SQL
Knowledge of other Microsoft technologies e.g. ASP.Net, ADO.Net, SharePoint, PowerBI, PowerPivot, Excel Services, Common Data Service, PowerAutomate (Flow), etc
Possess the ability to remain flexible in a quickly changing environment
Excellent organizational skills including multitasking and prioritizing
Strong analytical and problem-solving capabilities
Bachelor's degree in information systems, computer Science or similar field (equivalent professional experience also considered)
3+ years of previous experience
Cooperative and/or agricultural background desirable
Create actionable reports using SQL Server Reporting Services
Identify data quality problems and their root cause. Propose fixes and create data audits to ensure problem is resolved
Define, plan and implement moderately complex solutions as assigned
Manage the business analysis, requirements gathering and functional design of BI and data solutions including use cases, analytical workflows, business dimensional models and user interface
Manage the technical design of BI and data solutions including logical and physical data modeling, ETL data flow and source-to-target mapping, security design, etc
Suggest, document and implement improvements to current BI processes by leveraging functionality
Coordinates with users to gain understanding of needed changes or modifications of existing programs in order to understand and meet their needs
Maintain confidentiality with regard to the information being processed, stored or accessed
Maintains documentation of database systems
Performs other non-essential duties as assigned
Interpersonal Skills – The ability to strategize, plan and collaborate with both higher- and lower-level colleagues
Attention to Detail – Data is our single largest asset. As such, you can't afford to ignore the little things. The BI Developer needs to have a highly focused attention to detail
Company
MKC - Mid Kansas Coop
MKC is a full-service farm cooperative offering a complete line of products, programs and services for both farm and urban customers throughout Kansas.
201-500 employees
H1B Sponsorship
MKC - Mid Kansas Coop has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
Funding
Current Stage
Growth StageLeadership Team
Anne Warren
Executive Vice President & Chief Human Resources/Talent Officer
Erik Lange
Executive Vice President and Chief Operations Officer
Company data provided by crunchbase