Develop analytical and operational reporting solution using SSIS, SSAS and Power BI
Assist in identify solutions to reporting needs and, if necessary, develop new reports or modify existing reports
Develop and implement ETL solution
Document project-specific processes and data flows, data dependencies, data definitions and relevant business rules
Implement data security model across all business intelligence products including row level security and partitioning.
Deliver all work products to defined best practice standards and ensure high quality results
Required Skill set:
Good theoretical background and hands on experience in Normalized and Denormalized database design
Good Understanding of dimensional modeling, designing facts and dimensions table
Hands on in complete ETL design & development cycle including data analysis, database design, data mapping, transformation and data load on Microsoft BI stack
Reporting and Analytics presentation layer expertise including Dashboards, Reporting, and OLAP on Power BI & other Microsoft products
Knowledge of modern software development practices such as agile methodologies and DevOps and test driven development
Self-motivated, quick learner and a responsive team player
Excellent written/oral communication, presentation, and interpersonal skills
Ability to work under pressure, within agreed targets and timescales and deliver quality outcomes.
