Data Analyst Level II

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

Job Summary

In the role of a Data Analyst Level II, the individual is expected to independently handle the development of data-driven solutions that influence decision-making across the organization. This involves generating ad hoc reports using SQL and Excel, and developing automated MIDAS reports for end-users. The role also includes managing long-term, research-based projects using Excel Dashboards and Power Query.

In terms of client relations, the Data Analyst Level II is responsible for creating slide decks that compare client performance to industry standards. This involves identifying trends and areas for enhancement within the clients’ data. Collaboration with team leaders is carried out to articulate the company’s value proposition and competitive advantage.

The role requires a comprehensive understanding of various business aspects, which helps in turning data into useful insights for different groups. Tasks assigned are managed independently via an internal Report Request Queue. Adherence to turnaround times and maintenance of the quality standards established by the Analytics leadership are the baseline for performance evaluation. Part of the role is to ensure the accuracy of existing query logic, reporting procedures, and code structures, conduct quality checks, and assist in standardizing queries. A significant aspect of the role is dedicated to training and documentation, including maintaining up-to-date training materials, and managing the team’s documentation repository.

Qualifications

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

• Proficiency in SQL ranging from intermediate to advanced level, including the correct use of conditional filters, subqueries, indexes, and variable manipulation.

• 2-4 years of experience in SQL Server Reporting Services (SSRS) development.

• Capable of working with stakeholders to evaluate potential risks and translate business requirements into layman’s terms.

• Advanced proficiency in Microsoft Excel, including the ability to write complex formulas, use LOOKUPs, create pivot tables, apply logical and statistical functions, and create dashboards.

• Experience in training end users and Data Analyst I team members.

• Demonstrated experience in designing user interfaces with a 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.

Flexible 8 hour shift starting between 4:00pm up to 10:00pm Philippine time