BIGMAC CONSULTANCY
Technical Skills:
The BI Developer should understand and have expertise in the various technologies needed to implement BI solutions. The developer must have experience with the Microsoft BI stack and exposure to other technologies is a plus (Oracle, IBM, Qlik, Tableau, etc.).
Relational Database and SQL Language
Extraction, Transformation and Loading (ETL) (Microsoft SSIS)
Data Warehouse / Solution Design
Dimensional Modeling (Kimball Methodology)
Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
Report Development (Microsoft SSRS, Power BI, Tableu)
Responsibilities
Translate business needs to technical specifications
Design, build and deploy BI solutions (e.g. reporting tools)
Maintain and support data analytics platforms (e.g. MS BI, Tableu, Algonomy)
Create tools to store data (e.g. OLAP cubes)
Conduct unit testing and troubleshooting
Evaluate and improve existing BI systems
Collaborate with teams to integrate systems
Develop and execute database queries and conduct analyses
Create visualizations and reports for requested projects
Develop and update technical documentation
REQUIRED SKILLS / EXPERIENCE:
6+ years of comprehensive report analysis and design experience with demonstrated knowledge of data warehouse/database structures.
6+ years of recent experience developing reports on SSRS and Power BI.
6+ years of recent experience writing complex SQL statements
Demonstrated experience working with business partners, development of functional and technical specifications, and general project management in service of report development cycle.
Strong communication skills with demonstrated experience managing development cycles and project management.