Investigative Analyst Senior

Anticipated End Date:

Position Title:

Job Description:

Location: This role requires associates to be in-office 1 - 2 days per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work-life balance. This approach combines structured office engagement with the autonomy of virtual work, promoting a dynamic and adaptable workplace. Alternate locations may be considered if candidates reside within a commuting distance from an office.

Please note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting location(s) will not be considered for employment, unless an accommodation is granted as required by law.

The Investigative Analyst, Senior is responsible for analyzing complex business problems and having an extensive knowledge of the applications, data, associated technologies and/or analytic methods to support Department objectives. Analyzes healthcare, business system, and financial data to identify complex patterns of suspicious activity, outliers, anomalies and other issues that represent risk. Displays a high level of critical thinking and analysis. Applies strong knowledge of a structured query language (e.g. MS Access, VBA, T-SQL, or PL/SQL) to perform complex data extraction, quantification, analysis, reporting, and ETL (Extract, Transform, and Loading) of data.

Utilizes advanced statistical knowledge to perform sampling, extrapolation and forecasting techniques. Possesses strong demonstrated experience in developing MS Access databases and SQL Server solutions. Works on complex issues where analyses of situations or data require an in-depth evaluation.

• Serves as the point of authority in the analysis of complex healthcare, business systems, and financial data, including development of advanced analytic outputs and/or services.
• Performs complex data mining and ad hoc data analysis to identify and quantify patterns of suspicious activity, outliers, anomalies and other issues that represent risk.
• Develops and utilizes complex analytic outputs and/or services, including predictive models, decision trees, forecasting and optimization analysis.
• Develops requirements for analysis and reporting solutions to support Department business objectives.
• Develops complex databases, queries, and reports.
• Perform database and dataset updates.
• Utilizes multiple corporate data repositories, including SQL Server and Oracle databases to extract information.
• Uses management reporting tools to provide business intelligence required to make effective decisions.
• Completes analysis and reporting utilizing a variety of applications (Access, ACL, SQL Server, Oracle, Facets, and People Soft).
• Reads and interprets design document conceptual, logical, and physical models to include context diagrams, data flow diagrams, process flow diagrams, data dictionaries and logical flow charts.
• Identifies risks and multiple solutions.
• Recommends and implements improvements to existing procedures. Influences others to follow existing procedures.
• Makes technical and functional business recommendations based on evolving technologies and evolving application trends to include infrastructure, software, database, and networks.
• Analyzes business system configuration data to identify complex patterns of suspicious activity, outliers, anomalies and other issues that represent risk.
• Addresses business challenges to improve efficiency and decision making, reduce redundancy, and ultimately enhance business results.
• Applies advanced statistical knowledge to perform sampling, extrapolation and forecasting techniques.
• Functions as a liaison between own department, health plans, functional areas, and ITS, collaborating directly with associates, other departments, and external constituents to analyze data, identify trends, and communicate findings.
• Trains associates in data analysis.
• Serves as a subject matter expert to less experienced associates in data sources, analysis, query, database, application, and reporting.
• Continues to improve technical skills and to stay current with…