Position Purpose: Provides advanced business and technical expertise to design, build, validate, implement, and support complex data solutions, reporting, applications, and automations. Serves as a subject matter expert in business systems, claims data, audit sampling, databases, and reporting platforms. Translates business, audit, and regulatory requirements into sustainable technical solutions; ensures data accuracy through testing and reconciliation; resolves complex production issues; and partners across business, technology, risk and control, and vendor teams. Independently leads technical work and guides other analysts.
Key Details: Must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Sponsorship and future sponsorship are not available for this opportunity, including employment-based visa types H-1B, L-1, O-1, H-1B1, F-1, J -1, OPT, or CPT.
Develops ad-hoc reports to conduct data analysis and validation, including reconciliation of source data, business rules, sampling logic, calculations, and automated output for accuracy, completeness, and control compliance.
Confers with area/department to analyze current operational procedures and trends and identify problems, partnering with business, technology, risk and control, and vendors to manage requests, validate changes, and resolve complex issues.
Conducts business analysis and recommends technical alternative solutions to management as to course of action that best meets the organization's goals.
Research, evaluate and assess the financial and operational impact of issues identified in data/processes.
Analyzes requirements, procedures, and problems to automate processing or to improve existing business systems; develops applications, APIs, and automation that integrate data and reduce manual effort.
Creates and maintains multiuser, real-time, robust database and reporting solutions, including complex SQL queries, stored procedures, database structures, ETL processes, data pipelines, data models, and paginated and interactive reports supporting claims audit sampling, analytics, and automation; administers workspaces, gateways, deployment pipelines, service accounts, access, and security.
Acts as subject matter expert to provide business and technical expertise in requirements solicitation, system analysis, technical design, programming, testing, validation, and documentation of business applications/systems, including data flows, process maps, runbooks, testing evidence, and knowledge transfer materials.
May be responsible for monitoring and reporting to management on the status of departmental projects: Anticipates and identifies issues that could inhibit achieving the project goals and objectives, and implementing corrective actions and mitigation strategies; independently leads complex technical initiatives and manages priorities, milestones, risks, status, and implementation.
Provides oversight and resolves complex issues, optimizing performance, resolving problems, and providing timely follow- up on identified issues; owns production support, including monitoring, triage, root cause analysis, defect resolution, change implementation, and documentation.
Provides guidance and training to staff on process, procedures, technical solutions, documentation, and issue resolution.
Additional Responsibilities:
Performs other duties as assigned.
Complies with all policies and standards.
Education/Experience:
Bachelor's Degree in a related field or equivalent work experience in technical data analysis, database and application development, conducting system analysis meetings, developing system design documents, developing project plans with achievable milestones and deadlines, testing, validating, and supporting solutions in production, and mediating different department demands to gain approvals on system scope and design.
Master’s degree in related field i.e., Mathematics, Computer Science, Information Systems,…