● Interview with process owners and managers to address business needs.
● Translate business needs and data logic to technical specifications.
● Provide a secure connection between the data warehouse and databases.
● Design a database for managed and not managed data.
● Provide report data structures.
● Design, build, and deploy BI solutions (reporting tools) as needed.
● Maintain and support data analytics platforms.
● Create tools to store data (e.g. OLAP cubes).
● Evaluate and improve existing BI systems and data structure.
● Collaborate with teams to integrate systems.
● Develop and execute database queries and conduct analyses.
Requirements
● At least 5 years of proven experience as a business analyst and report developer.
● Familiar with business processes such as production, inventory, commercial, and management requirements.
● Experience in data warehouse design (e.g., dimensional modeling) and data mining.
● In-depth understanding of database management systems, online analytical processing (OLAP), and ETL framework.
● Experience with Reporting Tools and BI technologies such as Microsoft Power BI, Qlikview, and Crystal Reports.
● Knowledge of SQL queries, SQL Server Reporting Services (SSRS), and SQL Server Integration Services (SSIS).
● Knowledge of ERP Business Processes and software is a plus.
● Being familiar with the food industry is a plus.