Senior Data Analyst II - SSRS & Excel

MEDRISK PHILIPPINES; Mandaluyong; On-site; PHP 580,000 - 759,000; Full time

Job summary

MEDRISK PHILIPPINES in Manila seeks a Data Analyst Level II to independently develop data-driven solutions that influence decision-making across the organization. You will generate ad hoc reports using SQL and Excel, and build automated MIDAS reports for end users.

You will manage long-term, research-based projects with Excel Dashboards and Power Query, create client performance slide decks, identify trends, and work with team leaders to articulate the company's value proposition and competitive

Qualifications

• Bachelor’s degree in Statistics, Mathematics, Computer Science, or related field.
• SQL proficiency from intermediate to advanced with filters, subqueries, indexes, and variables.
• 2-4 years of experience in SQL Server Reporting Services (SSRS) development.
• Capable of translating business requirements into layman’s terms.
• Advanced proficiency in Microsoft Excel, including complex formulas, LOOKUPs, pivots, and dashboards.
• Experience in training end users and Data Analyst I team members.
• Experience designing user interfaces with focus on information delivery.
• Excellent analytical and problem-solving skills.
• Ability to work independently and as part of a team.
• Strong written and verbal communication skills.

Responsibilities

• Develop data-driven solutions and ad hoc reports using SQL and Excel.
• Create automated MIDAS reports for end users.
• Develop Excel Dashboards and Power Query for long-term projects.
• Prepare client performance slide decks comparing to industry standards.
• Collaborate with team leaders to articulate the company’s value proposition and competitive advantage.
• Maintain training materials and ensure quality, accuracy of queries and reporting.

Skills

SQL

Excel

Data analysis

Communication

Teamwork

Training

UI design

Education

Bachelor’s degree in Statistics, Mathematics, Computer Science, or related field

Tools

SSRS

Power Query

Excel

Job description

MEDRISK PHILIPPINES in Manila seeks a Data Analyst Level II to independently develop data-driven solutions that influence decision-making across the organization. You will generate ad hoc reports using SQL and Excel, and build automated MIDAS reports for end users.

You will manage long-term, research-based projects with Excel Dashboards and Power Query, create client performance slide decks, identify trends, and work with team leaders to articulate the company's value proposition and competitive