Description

You will optimize database performance, build data models, and support end-users with Power BI and SQL tools.

Responsibilities

• Review and optimize existing SQL queries, execution plans, partitions, and indexes to resolve performance issues.
• Write complex DAX queries and design MS SQL Server data models and schemas.
• Provide training and technical support to end-users on Power BI and SQL functionalities.
• Leverage Python or R for data analysis and scripting tasks.

Required Skills

• 5+ years of experience with Power BI and SQL development.
• Strong proficiency in MS SQL Server data modelling and schema design.
• Experience writing complex DAX queries for data analysis.
• Familiarity with cloud platforms such as Azure or AWS.
• Knowledge of other BI tools like Tableau or QlikView.
• Microsoft Certified: Data Analyst Associate or equivalent certification.
• Experience in Pensions Benefit Management programs is required.

Preferred Skills

• Additional relevant certifications in SQL, Data Analysis, or database management.

Key Skills

Education

Any Gradute