Sr Data Analyst

Job Summary

In the role of a Senior Data Analyst, the individual is expected to drive the development of data-driven solutions that influence decision-making across the organization. This involves generating ad hoc reports using SQL and Excel, as well as developing automated MIDAS reports for end-users with a focus on creating standardized and optimized stored procedures. The role also includes managing long-term, research-based projects using Excel Dashboards and Power Query, which often support the larger organizational goals. 

In terms of client relations, the Senior Data Analyst 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 Executive Leaders and Corporate Account Executives is carried out to articulate the company's value proposition and competitive advantage. 

The role requires a broad 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, each task having a turnaround time set by the business. Adherence to these 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 providing training for Level I and Level II Analysts, maintaining up-to-date training materials, and managing the team's documentation repository.

Primary Duties & Responsibilities

Training and Development: 

•    Lead training sessions for mentoring Level I and Level II Analysts and data outreach projects for business group leadership.

•    Utilize reporting experience to provide direction to Level I and Level II Analysts in weekly stand-up meetings.

•    Maintain training materials up-to-date and manage the team's documentation repository.

•    Develop innovative methods to enhance the presentation of data and advise peers on presentation strategy. 

Data Management and Reporting:

•    Lead the development and automation of ad hoc reports and dashboards using SQL, SSRS, and advanced Excel functionalities (including Power Query, PivotTables, and dashboarding techniques).

•    Conduct robust data validation, quality assurance, and testing on analytics deliverables, ensuring accuracy and alignment with business needs.

•    Assist in automating manual reporting processes and standardizing reporting templates to improve efficiency and data consistency.

Stakeholder & Cross-Functional Collaboration

•    Serve as an associate point of contact between the Analytics team and key business units such as Account Management, Operations, Provider Management, and Executive Leadership.

•    Translate complex business needs into clear technical requirements, ensuring that data insights directly support project and organizational objectives.

•    Communicate technical findings in a clear, accessible format for non-technical audiences and facilitate discussions around key data insights.

Process Optimization & Reporting Governance

•    Identify inefficiencies in existing processes and lead initiatives to streamline project execution and report workflows.

•    Contributes to the development and enforcement of data governance policies and reporting standards, maintaining a repository of best practices and reusable templates.

•    Drive ongoing process improvement initiatives, including the automation of reporting processes and the refinement of project management practices.

Presentation and Research:

•    Develop and deliver client presentations and executive dashboards that effectively communicate the value proposition of our data-driven solutions, using data visualization techniques to present complex data in an understandable, compelling format. Present results to key stakeholders and assist in data-driven decision-making. 

•    Lead research projects that explore innovative ways to use data for business insights, collaborating closely with different teams to understand their needs and tailor the research accordingly.

•    Leverage cross-business expertise to provide comprehensive data solutions, understanding the unique needs and challenges of different business units and tailoring data analysis and reporting to meet these needs.

Qualifications

•    Bachelor's degree in Statistics, Mathematics, Computer Science, or related field. Master's degree is a plus.

•    Expertise in SQL and SSRS, including the ability to write complex SELECT statements, expert-level experience with JOINs, WHERE clauses, common syntax, and temporary tables, correct use of conditional filters, nested subqueries, efficient use of indexes, and query optimization.

•    4+ years of experience in SQL Server Reporting Services (SSRS) development and Visual Studio.

•    Quality Assurance (QA) experience is preferred.

•    Experience in data warehousing is preferred.

•    Capable of working with key stakeholders and executive leaders 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 VLOOKUPs, create pivot tables, and create dashboards.

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

•    Ability to communicate ideas in both technical and user-friendly language.

•    Exceptional analytical and problem-solving skills.

•    Leadership and project management skills.

•    Strong written and verbal communication and presentation skills.