Resp & Qualifications
The Data Engineer is a highly motivated professional responsible for developing innovative and complex data solutions and applications to support actuarial analytics. With a critical eye towards data integrity and a growing understanding of healthcare data, the Data Engineer will partner with actuaries on a wide range of activities to produce analytics tools and applications and assist with ad hoc reporting and analysis. Additionally, the Data Engineer will work closely with non-actuarial stakeholders to support financial and business-related processes to understand and manage the financial health of the company.
The Data Engineer is expected to have a basic understanding of the health care business and is strongly encouraged to quickly improve on this business knowledge to perform analysis more independently on the data to validate accuracy and proper reporting based on established business rules.
The Data Engineer is expected to learn and understand the fundamentals of actuarial analytics. This includes becoming familiar 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 Data Engineer will be responsible and accountable for all phases of the System Development Life Cycle. This requires an understanding of the business need, 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 Data Engineer is expected to make decisions, with management guidance, on the appropriate data sources to use, the optimal approach to solve business problems, and to ensure that results tie to appropriate controls.
This is a fast-paced, collaborative, and iterative environment requiring quick learning, agility, and flexibility.
Writes and executes ETL code, primarily complex SQL/NoSQL script, but with a strong ability to leverage other technologies.
Analyzes and validates existing routines and communicates impacts. Assists with data transformation, manipulation, and presentation to users.
Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.
Supports the Software Engineering team with data analysis and validation with extensive SQL queries.
Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework.
Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise. Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts.
Defines Data Integration best practices for the data management environment.
This position has no direct reports, however, may informally lead teams in a matrix environment.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Experience: 3 years Hands-on experience with database management systems, ELT/ETL systems, business intelligence tools, defect management and system testing.
Education: Bachelor's Degree in Information Technology or Computer Science or Engineering
In Lieu of Education: In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
- Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python)., Advanced
- Knowledge and understanding of data exchange formats., Advanced
- Knowledge and understanding of database design and implementation concepts., Advanced
- Ability to recognize, analyze, and solve a variety of problems., Advanced
- Knowledge and understanding of data movement concepts., Advanced
- Excellent communication skills both written and verbal. , Advanced
- The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes them ineligible to perform work directly or indirectly on Federal health care programs.
- Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time.
- 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.
Department: Information Technology
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: 10.01.2021
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 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