Business Intelligence Developer (On-site)

Idahoan Foods - Idaho Falls, ID

Full-time - Mid Level

Idaho Falls, ID

Food Manufacturing

About the position

The Business Intelligence (BI) Developer at Idahoan Foods is responsible for designing and developing self-service business intelligence systems that provide insights for decision-making. This role involves collaborating with end users to gather requirements, modeling data, and ensuring the performance and security of data systems. The BI Developer will support managers and users in their data needs and contribute to the analytics platform roadmap under the guidance of the Director of Analytics.

Responsibilities

• Meet with decision makers and nontechnical end users to define business requirements and convert them into technical specifications for reports and data visualizations.
• Design, develop, and publish datasets, dataflows, reports, dashboards, and apps to the Power BI service.
• Prepare and deliver recommendations addressing existing and potential trouble areas across the organization.
• Create models, specifications, diagrams, and documentation for new and modified systems.
• Train and provide technical support to end-users.
• Collaborate in the planning, design, development, and deployment of normalized and de-normalized data models within the data warehouse.
• Identify, communicate, and resolve data quality and reconciliation issues.
• Integrate, extract, load, and transform data from disparate source systems.
• Review and analyze the effectiveness of existing systems and develop strategies for improvement.
• Monitor and adjust queries, reports, data models, and dataflows to optimize performance.
• Assist in implementing effective business analytics practices.

Requirements

• College degree in business administration, computer science, accounting, or management information systems combined with 2-5 years related work experience.
• Understanding of database management systems, data warehouse design, self-service BI software, and T-SQL scripting.
• Practical knowledge in importing data for use in report software, spreadsheets, graphs, and flow charts.
• Self-service BI experience is preferred (Power BI, Tableau, Domo, etc.).
• Experience with ERP source systems (MS Dynamics 365 F&O or similar) is preferred.
• Knowledge of Azure Data Factory, Azure SQL Database, and SQL Server (or similar) is preferred.
• Demonstrated problem-solving, analytical and communication abilities.

Nice-to-haves

• Familiarity with the Software Development Life Cycle in an IT environment.
• Experience with Visual Studio and code management.