Data Analyst Level II

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.

Primary Duties & Responsibilities

Training and Development:

• Lead training sessions for Level I Analysts and data outreach projects for business group leadership.
• Actively update team lead and peers on work status in weekly stand-up meetings.
• Assist in maintaining training materials up-to-date.
  
  

Data Management And Reporting

• Develop, review, and revise SQL queries using Microsoft SQL Server Management Studio, and translate ad hoc reports into automated solutions using SSRS.
• Support the development of reusable stored procedures and help maintain a consistent report deployment structure based on departmental standards.
• Conduct thorough evaluations of existing stored procedures and ad hoc reporting logic to ensure alignment with intended outcomes.
• Adhere to development standards concerning SQL querying and SQL Server Reporting Services (SSRS).
• Create, optimize, and maintain reports using advanced Excel functionalities, and design digital dashboards, executive information systems, and reports.
• Gather, prep, and load data into the warehouse and other repositories for future reporting.
  
  

Presentation And Research

• Develop and deliver client presentations 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.
• Support research projects that explore innovative ways to use data for business insights, working 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.
  
  

Project And Request Management

• Independently manage assigned requests via the report request queue, and proactively communicate with team members and requestors regarding field changes, new strategies, or report roadblocks.
• Manage report assignments for the Data Analytics Team through the Report Request Queue as needed.
  
  

Communication And Collaboration

• Act as a comprehensive advisor to the business regarding analytic capabilities and reporting options.
• Collaborate with business units to refine requirements for enhancements and new report requests.
• Conduct periodical research on workflow issues/inefficiencies, present trends in data, and suggest potential solutions.
  
  

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.