.. : Hyderabad (WFO) Mandatory : IOS Development + SwiftUI + Objective C iOS, Xcode, SWIFT, JIRA, Core Location, Core Data, Core Animation, Autolayout, Design Patterns, Unit Testing, Github, Source Control, CI/CD, Testflight, Firebase. • Proficient with Swift Language with iOS frameworks such as Core .. read more
Position Summary:
The job profile for this position is Data Measurement & Reporting Manager, a Band 4 Management Career Track Role. The Data Measurement & Reporting Manager will be responsible for managing and developing a team of 5 to 10 advisors, lead analysts, and analysts. The team is responsible for the rapid development, quality review, and completion of 50 to 100 ad hoc reporting requests per week from business operations (claim, provider, call, client, legal, and compliance matrix partners).
The output of the reports contains business intelligence including claim details, call details, client level information, etc. The work environment is fast paced and embedded within the business operation, affording the Data Measurement & Reporting Manager and team to work directly with numerous business owners who serve our customers, clients, and providers. Develops and nurtures strong relationships, based on mutual levels of respect and trust, with operational leaders and front-line staff.
The Data Measurement & Reporting Manager is also responsible for leading and prioritizing an inventory of 5 to 10 special project requests per month that typically require significantly more effort hours and higher levels of complexity than most ad hoc reporting requests. Automation opportunities exist to convert one-time ad hoc reports into recurring delivery, once the initial ad hoc request is delivered. This leader manages day to day inventory across the team, including prioritizing and setting direction for the team. The leader needs advanced technical skills in SQL, SSIS, SAS, Microsoft Access, and Python to directly guide and engage with the team and business to complete complex and/or time sensitive requests. Gathering business requirements, communicating through phone calls, Webex meetings, and written correspondence through Web Messenger and Outlook are essential to successful performance.
Job Description & Responsibilities:
- 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.
Experience Required:
- 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 Desired:
- 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 what’s 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 Desired:
- 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 what’s 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.
Primary Skills:
- 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.
Additional Skills:
- Manages Complexity
- Manages Ambiguity
- Collaborates
- Instills Trust
- Builds Effective Teams
- Communicates Effectively
- Interpersonal Savvy
- Tech Savvy
- Ensures Accountability
- Drives Results
- Directs Work
- Customer Focus