Resp & Qualifications
PURPOSE: For this highly supervised position, the Actuarial Developer/Analyst I is responsible for helping to ensure the accuracy and integrity of Actuarial data and applications through efficient coding, writing clear documentation, and resolution of problems as they arise. The Actuarial Developer/Analyst I is expected to work independently as well as part of a team to analyze, identify, and interpret problems under difficult circumstances and to support measures to solve them. Work is reviewed for professional judgment, support of organizational and departmental goals, and accuracy and quality of performance.
The required programming skills are data-intensive in nature and require the manipulation, managing and reporting of large amounts of information. The Actuarial Developer/Analyst I is expected to start with little or no understanding of the business and is expected to quickly improve on this business knowledge to more independently perform analysis on the data to validate accuracy and proper reporting based on established business rules. Actuarial Developer/Analyst I is expected to learn how to use many different data sources and ensure that results tie to appropriate controls. Processes and reporting results are audited for compliance and the underlying control processes are expected to adhere to the Modal Audit Rule.
The Actuarial Developer/Analyst I is expected to quickly learn and become proficient in moderate to advanced SQL, basic SSIS and the MS Office Suite. This position requires strong conceptual and quantitative skills.
Under the general direction of the Actuarial Systems Manager, the incumbent’s accountabilities include, but are not limited to, the following:
Provide development support for the implementation of complex end-to-end data solutions and applications by coding to high-level specifications:
• Support the implementation of relational and dimensional data models
• Write efficient and maintainable ETL focused on re-usability and clear, logical execution
• Program moderate to advanced SQL incorporating complex business logic
• Perform code and use-case testing based on specifications, document results and research issues when testing fails
Perform highly supervised financial, actuarial and healthcare reporting according to specifications:
• With management guidance, support the development of basic to intermediate analytics based on financial, actuarial and healthcare concepts
• Learn how to review and analyze reporting results for accuracy based on tie outs to appropriate controls and for financial and actuarial soundness to ensure accurate calculations; learn how to identify reporting anomalies and effectively communicate findings to business users
• Expand knowledge and understanding of internal business rules and financial and actuarial concepts through interaction with actuaries, individual research and on-the-job training
Support monthly production processes and improvements to the department’s efficiency:
• Provide monitoring of production processes; assist in the resolution of production issues when they arise
• Ensure that data loads tie to appropriate controls and document according to audit guidelines and practices
• Support the improvement of departmental processes through clear and concise documentation
• Continually develop technical skills in current technologies, programming languages, and departmental practices and procedures
Expand knowledge and understanding of business/healthcare, financial and actuarial concepts through individual research, departmental contacts and on-the-job training
This position is also subject to being "on call" for emergency situations requiring immediate resolution. Travel between all CareFirst locations may be required.
Required: A college degree/certificate in Information Systems, Data Science or Computer Science or total equivalent work experience, with some relevant work experience/knowledge of the following technologies:
IT structured programming/coding (e.g. VB/VBA, C#, etc.)
Relational/Dimensional database development
Abilities/Skills: Additionally, this position requires working knowledge of procedural programming techniques. This position requires strong conceptual and quantitative skills and the ability to work independently and in small teams is necessary. The willingness to work outside of normally scheduled hours when necessary and to multi-task in a fast-paced, stressful environment is expected. Good oral and written communication is necessary as are strong interpersonal skills for interacting with colleagues and customers. Strong analytical and organizational skills are required.
Preferred: Familiarity with writing code for any of the following:
Microsoft Office Suite (Excel, Access, VBA)
MS SQL Server 2008 or later (including DDL and DML) ETL/SSIS (SQL Server Integration Services)
Department: Actuarial Systems
Equal Employment Opportunity
CareFirst BlueCross BlueShield is an Equal Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.
Hire Range Disclaimer
Actual salary will be based on relevant job experience and work history.
Where To Apply
Please visit our website to apply: www.carefirst.com/careers
Please apply before: 03/28/2019
Federal Disc/Physical Demand
Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs.
The physical demands described here are representative of those that must be met by an associate to perform the essential duties and responsibilities of the position successfully. Requirements may be modified to accommodate individuals with disabilities.
The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The employee must frequently talk and hear. Travel among CareFirst sites may be required.
Sponsorship in US
Must be eligible to work in the U.S. without Sponsorship