Essential Duties & Responsibilities:

• Develop solutions to extract data from various systems and load it into databases using different technologies to transfer and load the data such as SSIS, Azure Data Factory.
• Work closely with the team to evaluate, maintain and support existing applications ensuring that the BI platform is accurate, available, and performant.
• Identify improvements and work with the BI Manager to implement solutions for the existing applications.
• Build out visualizations and dashboards using Power BI.
• Identify new reporting features that can add value for Benefit and share with the business experts.
• Work with different business departments to gather business needs and translate them into technical specifications.
• Work with the BI Manager to support BI projects from the business interviews to the roll out of the applications, ensuring all critical control points are met as per Benefit standards.
• Promote the use of the BI solutions across the company through trainings and presentations.
• Research new BI technologies. Test and determine if they would be beneficial for the company.

Qualifications:

• 3 to 5 years of experience in data warehouse and analytics/BI architectures, including data modelling
• Experience with technologies like SQL Server, Azure and Google Cloud.
• Experience leading BI projects from the user interviews to the deployment and support of the solution
• Familiarity with ETL tools
• Experience with data visualisation tools
• Knowledge of the wholesale/retailer business
• Strong database conception skills
• Familiarity with SQL Server skills such as security, replication, backup. Performance testing is a plus
• Ability to write complex SQL queries with joins, sub queries and aggregations
• Ability to use ETLs such as SSIS, Azure Data Flow
• Ability to manipulate complex sets of data
• Ability to create data visualizations and dashboards using Power BI
• Strong understanding of retail business in order to capture end-users requirements and translate them into working dashboards.
• Ability to create planning and communicate milestones
• BS/MS in Computer Science or Information Systems preferred or equivalent combination of education and experience.