"Alerted.org

Resp & Qualifications

PURPOSE:

The Senior Data Engineer, working within the Finance Data Systems and Decision Support area, is a highly motivated professional responsible for developing innovative and complex data solutions and applications to support Trend analytics in medical economics. With a critical eye towards data integrity, deep understanding of provider, claims, enrollment data, utilization measures, and practical experience working with health care data, the Senior Data Engineer will work closely with actuaries to produce trend analytics tools, dashboards, and assist with ad hoc reporting and analysis. Additionally, the Senior Data Engineer will partner with actuaries to support the financial impact analysis related to the building of and changes to provider networks and contracting.

The Senior Data Engineer is expected to have a strong understanding of the business and financial health care data and performs analysis on the data to validate accuracy and proper reporting based on established business rules for their own work and that of colleagues.

The Senior Data Engineer is expected to be self-starter. By learning from the existing processes and analytical tools, the Senior Data Engineer can quickly grow and become the SME and go-to person in the subject matter with minimal supervision under the manager. Excellent critical thinking skills and problem-solving skills are necessary to be successful in the role.

The Senior Data Engineer is expected to make decisions on the appropriate data sources, the optimal approach to solving business problems, and to ensure that results are tied to appropriate controls.

The Senior Data Engineer is expected to be extremely proficient in SQL with practical experience in applying complex business rules and advanced commands against large amounts of data to optimally produce desired results. The Senior Data Engineer is expected to be proficient in using complex Excel functions for data analytics, reporting and presentation of data results. Experience in Microsoft business intelligence tools is beneficial, specifically strong knowledge and experience with SSAS (SQL Server Analysis Services) and Power BI.

The Senior Data Engineer is expected to have a firm understanding of the fundamentals of actuarial and financial analytics. This includes familiarity with actuarial terminology and basic calculations as well as with the underlying health care data being used for analysis to be able to explain reasons for outliers and to generally support in-depth questions and analytical results.

The Senior Data Engineer will be responsible and accountable for all phases of the System Development Life Cycle. This requires an understanding of business needs, the data needed to respond to the request, and the ability to execute on the building and delivery of accurate and timely reporting and data solutions.

The Senior Data Engineer is also expected to mentor staff, provide guidance on projects, and represent the Finance Divisions interests during interactions throughout CareFirst.

This is a fast-paced, collaborative, and iterative environment requiring quick learning, agility, and flexibility.

ESSENTIAL FUNCTIONS:

+ Develops and maintains health care data model and solutions to enable business partners build analytics framework and make data-driven business decisions. Works as the liaison translating the business partners data need with underlying infrastructure systems (e.g., data warehouses, data lakes). Prepares and manipulates data using multiple technologies.

+ Interprets data, analyzes patterns using various data quality check techniques, and provides ongoing reports. Executes quantitative analyses that translate data into actionable insights. Provides analytical and data-driven decision-making support for key projects. Designs, manages, and conducts quality control procedures for data sets using data from multiple systems.

+ Develops data models by studying existing data warehouse architecture; evaluating alternative logical data models including planning and execution tables; applying metadata and modeling standards, guidelines, conventions, and procedures; planning data classes and sub-classes, indexes, directories, repositories, messages, sharing, replication, back-up, retention, and recovery.

+ Creates data collection frameworks for structured and unstructured data.

+ Improves data delivery engineering job knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

+ Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.

+ Applies and implements best practices for data auditing, scalability, reliability and application performance.

SUPERVISORY RESPONSIBILITY:

Position does not have direct reports but is expected to assist in guiding and mentoring less experienced staff. May lead a team of matrixed resources.

QUALIFICATIONS:

**Education Level:** Bachelor's Degree in Computer Science, Information Technology or Engineering or related field OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

**Experience:** 5 years of experience with database design and developing modeling tools. Experience developing and updating ETL/ELT scripts. Hands-on experience with application development, relational database layout, development, data modeling.

Preferred Qualifications:

+ Five years of existing knowledge and experience working with health care claims and enrollment data in the health insurance industry is highly preferred. Basic and fundamental understanding of health economics and advanced analytics methodology is desired for this role.

Knowledge, Skills and Abilities (KSAs)

+ Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python).

+ Knowledge and understanding of database design and implementation concepts.

+ Knowledge and understanding of data exchange formats.

+ Knowledge and understanding of data movement concepts.

+ Strong technical and analytical and problem-solving skills to troubleshoot to solve a variety of problems.

+ Requires strong organizational and communication skills, written and verbal, with the ability to handle multiple priorities.

+ Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.

**Salary Range:** $96,048 - $190,762

Salary Range Disclaimer

The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the work is being performed. This compensation range is specific and considers factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, internal peer equity, and market and business consideration. It is not typical for an individual to be hired at the top of the range, as compensation decisions depend on each case's facts and circumstances, including but not limited to experience, internal equity, and location. In addition to your compensation, CareFirst offers a comprehensive benefits package, various incentive programs/plans, and 401k contribution programs/plans (all benefits/incentives are subject to eligibility requirements).

Department

Finance Data 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.

Where To Apply

Please visit our website to apply: www.carefirst.com/careers

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.

PHYSICAL DEMANDS:

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 associate must frequently talk and hear. Weights up to 25 pounds are occasionally lifted.

Sponsorship in US

Must be eligible to work in the U.S. without Sponsorship

\#LI-CB1

REQNUMBER: 21485