Main Responsibilities:

• 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

Qualification and Experience:

• Minimum Bachelors (4 year) (HEC recognized) degree in Software Engineering, Computer Engineering or related field
• At least 2 years of experience in BI solution development and implementation using MSBI Stack