Data Measurement & Reporting Manager
Evernorth
- Hyderabad, Telangana
- Permanent
- Full-time
- Manage and develop a team of senior and junior analysts.
- Manage daily and intraday ad hoc reporting inventory to ensure reporting SLAs are met.
- This includes frequently assigning and occasionally reassigning ad hoc requests to team members based on capacity, complexity, and whether an ad hoc request has been escalated by business partners.
- Manage the quality review of ad hoc reporting output, critical to ensure reports are delivered accurately, the first time, as perceived by our requesting matrix partner.
- For special project requests, fully understand the requirements based on review and communication with matrix partners. Leverage this understanding to identify the software, skills, and work effort hours needed to fulfill the request. Plan the development, quality review, and delivery based on a combination of team capacity and matrix partner requested timeline. Work with leadership where capacity constraints exist to propose and successfully influence an acceptable solution.
- Identify opportunities to create self-service capabilities for our business partners where recurring ad hoc report requests require repetition for the same or similar data (business intelligence).
- Protect confidentiality of data by ensuring reports are delivered by the team in the appropriate medium, to the appropriate internal audience.
- 8-10 years of proven experience and advanced skills in SQL, SSIS, SAS, Tableau, Python, Microsoft Office, and other related software, is required
- Successful history of 4+ years serving as a manager, team leader, and mentor is required.
- Experience working with health insurance operations (claim, call, client, provider) is preferred.
- Ability to rapidly acquire systems domain and business knowledge, to translate business requirements into whats needed, why, how to query for data needed, and how to visualize the reporting output, is required.
- Ability to prioritize, negotiate, and communicate deliverable dates, within SLAs, is required.
- Ability to draw upon subject matter expertise with team members and business customers is required.
- Excellent verbal, written and interpersonal communication skills is required.
- Experience working with health insurance operations (claim, call, client, provider) is preferred.
- Ability to rapidly acquire systems domain and business knowledge, to translate business requirements into whats needed, why, how to query for data needed, and how to visualize the reporting output, is required.
- Ability to prioritize, negotiate, and communicate deliverable dates, within SLAs, is required.
- Ability to draw upon subject matter expertise with team members and business customers is required.
- Excellent verbal, written and interpersonal communication skills is required.
- SQL (Structured Query Language):
- Ability to utilize functions to create queries, using joins, subqueries, aggregation functions, views, indexing, pivoting, numeric calculations, stored procedures, and other intermediate to advanced techniques.
- Knows how to diagnose and correct query performance issues.
- Ability to work across multiple DBMS (Oracle, SQL, etc.) with a deep understanding of database design and query optimization techniques.
- Relevant SQL certificates, training programs, and projects demonstrating SQL proficiency.
- SSIS (SQL Server Integration Services):
- Knows how to build ETL (extract, transform, and load) processes in code.
- Ability to efficiently load, copy, and download large files.
- Experience with SSIS tasks such as Execute, Data Flow, Send Mail, Custom, etc.
- Ability to automate recurring reports delivery.
- SAS programming Basic skills for data access and generation of large size files.
- Microsoft Access - Ability to diagnose and solve for database performance issues.
- Python - Develop Python scripts to automate report generation to connect to databases, retrieve the data, create the output, and deliver the report.
- Manages Complexity
- Manages Ambiguity
- Collaborates
- Instills Trust
- Builds Effective Teams
- Communicates Effectively
- Interpersonal Savvy
- Tech Savvy
- Ensures Accountability
- Drives Results
- Directs Work
- Customer Focus