Develops complex decision support data applications, data extracts, files, reports, data marts, and/or analysis.
Responsible for entire development life cycle.
Manages the Maintenance and optimization of the Actuarial Systems Data Marts.
Establishes vendor and interdepartmental relationships to ensure the accuracy and completeness of financial data.
Serve as the lead for multiple application areas, including data definitions, usage and file structure, technical structure of the code and the business rules, and structure of requirements that governs the functionality of the system.
Leads in developing data applications, extracts, reports, or analysis by providing input to the business requirements and functional specifications, reviewing technical specs (to make sure all business requirements are met), participating in the user acceptance testing process, and attend all meetings required to support the project effort.
Independently analyze business problems or opportunities; develop recommendations and solutions, implement those solutions, and provide communications on the associated actions, business impacts, and results.
Performs monthly data refreshes, validations and quality assurance checks to support executive financial reporting’s.
Ensures Financial granular detail data is appropriately auditable, snapshotted and stored for quarterly and year end audits.
Provide analytical support for departmental, divisional and corporate projects as needed to accomplish their business goals and to ensure the business needs are met.
Coordinate work and provide direction, assistance and training to peers and junior staff members.
Keeps abreast of changes in the company and with our external vendor; data that affect the departmental processes & systems, make recommendations of actions needed and implement changes to the applicable Actuarial Systems and processes where needed.
Provide technical leadership and application expertise to business project teams and non-project related activities for the full understanding and execution of all types of assignments.
Plan and serve as a key liaison with business areas during development and implementation.
Provide detailed configuration expertise to customers and business partners. This includes verbal, written, and electronic communication, and delivering presentations when needed.

Requirements

Bachelor's degree or advanced degree (where required).
8+ years of experience in related field.
In lieu of degree, 10+ years of experience in related field.
5+ years of SQL Development/Analysis experience - Highly preferred.
5+ years’ experience with medical claims, Pharmacy/medical rebate data - Highly preferred.
Facets experience a plus.
Experience leading project teams.
Experience with Snowflake, AWS cloud environments.

Benefits

Medical, dental, and vision coverage along with numerous health and wellness programs.
Parental leave and support plus adoption and surrogacy assistance.
Career development programs and tuition reimbursement for continued education.
401k match including an annual company contribution.
Work-life balance, flexibility, and the autonomy to do great work.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQL DevelopmentData AnalysisData Applications DevelopmentData ExtractsData MartsQuality AssuranceData ValidationTechnical Specifications ReviewUser Acceptance TestingFinancial Reporting

Soft Skills

Analytical SkillsCommunicationLeadershipProject ManagementInterdepartmental CollaborationTrainingProblem SolvingVendor ManagementDirection and AssistanceAdaptability