Lead Data Warehouse Engineer - Technical.ly

Lead Data Warehouse Engineer

CareFirst |  Washington, DC, United States | Dev / Eng

Job Description
Perks + Benefits
Company Culture
Technical.ly Coverage

We are looking for a Lead Data Warehouse Engineer to join us and the revolution in health care IT.

We are working on “the big picture” of the future of health care information technology, and what we do touches the lives of millions of people.  Today, we are looking for a formal Lead Data Warehouse Engineer who wants to make a difference; be change-maker, while working together to build a leaner approach and really make an impact in our Data Services Engineering team and our success. At CareFirst BlueCross BlueShield, you will have the opportunity to influence the direction of health care. Working here means collaborating across teams, influencing change, and providing clear communication as you support data-driven, transformation technology solutions that deliver business value.

Some of the other tasks you’ll work on include:

  • Provide oversight of a larger group within Data and Informatics (D&I) of resources in the design, develop, test, debug, document, and support all types of applications consistent with established specifications and business requirements to deliver business value.
  • Takes leadership and accountability on coordination of work between multiple D&I teams and supply status to the program management team.
  • Implement solutions and ensure all milestones are met. Escalate to executive management as needed

In support of Software Design, Development, you will:

  • Lead in designing and defining core reusable assets that support the long-term business strategy for development efforts, ensure adherence to performance guidelines & business requirements and that all project teams code is to CareFirst specifications and ensure proper unit testing is done for all code.
  • Look for standardization and reuse opportunities, abstractions and patterns across classes and components to streamline design and development of BI solutions.
    With knowledge of the organization’s infrastructure, hardware, systems software and protocols, act as a consultative resource for strategy, system design, development and/or modifications of software/procedures to solve business solutions across multiple heterogeneous platforms.
  • Drive the solution design and solution review to ensure the technical architecture design meets the technical objectives, business requirements, and standards and ensures applications are designed for optimum performance and provide suggestions for ways to restructure designs to achieve optimal performance.
  • Drives the design, develop, test and implementation of maintainable program logic for existing and new application in accordance with the technical specifications.
    Reports to executive management on all project work and lessons learned as projects are closed.


  • BA/BS in Computer Science, Engineering, Math, Acturial Science, Information Systems, or other related IT field or equivalent work experience.
  • 5-7 years of experience with database management systems, ETL systems, business intelligence tools, defect management, and testing.
    Required Skills and Abilities:
  • Demonstrated expertise leading specific work or resources on a team to deliver results.
    Hands on experience in numerous technologies with skills ranging with one or more of the following:
  • Logical and physical data model design; technical documentation; full-cycle system development, test case creation, audit balance and control metrics, relational and dimensional database systems;
    Web-enabling applications; Java technologies (EJB, JSP, servlet), J2EE Web Service
  • Development, Unix development, SQL Development (PL/SQL or T-SQL), Experience with SSIS, SSRS, SSAS or SAS or MicroStrategy or Pryamid Analytics, OLAP Dimensional development, Data Warehousing, Master Data Management (MDM), Customer Data Integration (CDI), IBM Initiate, Oracle, Informatica (9.5.1 or higher) PowerExchange, Informatica Power Center, Tibco,  C#, .NET., Snowflake, Azure
  • Strong SQL and Data Analysis skills, attention to detail are required for this role.  Additionally, the ability to obtain and retain business knowledge needed for future contributions.


  • Some Healthcare experiences.
  • Familiarity with new technologies and how they could be leveraged to benefit the department, new business strategies and corporate initiatives.
  • Some knowledge of Big Data Technologies.

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

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

Apply Now
Read More
Health & Wellness Benefits
  • Dental
  • Disability Insurance
  • Health Insurance
  • Life Insurance
  • Onsite Gym
  • Vision
  • Wellness Programs
Parental Benefits
  • Family Medical Leave
  • Generous Parental Leave
  • Mother Rooms
Perks & Discounts
  • Casual Dress
  • Special Discounts
Professional Development
  • Online Trainings
  • Tuition Reimbursement
Retirement & Stock Options Benefits
  • 401K
Vacation & Time Off Benefits
  • Generous PTO
  • Paid Holidays

Describe the culture at CareFirst.

The culture is one of continuous learning. We are working to create tomorrow’s health plan — one that puts the service and security of our members first. Member security drives every decision we make as a company. We’re always looking at how and where we can improve our digital infrastructure. We’re open to creativity.


What are some of the ways you empower employees to make a difference at CareFirst? 

We believe that each of us has an opportunity to make a difference in our roles and the community.

For the past two years, the company has held an enterprise-wide event to advance diversity, equity and inclusion in our workplace and communities called the Week of Equity and Action. Through this, CareFirst associates participate in virtual trainings and community activations that reaffirm the company’s commitment to empathy, understanding, diversity, inclusion, equity and belonging. In 2019, associates collectively volunteered more than 10,000 hours of time with and for more than 30 non-profit organizations. This included assembling more than 5,000 personal hygiene care kits for individuals experiencing homelessness and packing nearly 14,000 infant bundles and 345,000 diapers for families in need. This year, due to COVID-19 restrictions, the Week of Equity and Action included 38 virtual workshops hosted by associates and external speakers; opportunities for associate to share their talents through skills based volunteering sessions with 70 non-profit organizations; and strategic partnerships with minority, women, Veteran and/or LGBTQ-owned businesses in the community.

CareFirst has taken intentional steps to encourage associates to continue conversations and action around diversity, equity and inclusion, including increased trainings and resources, leadership coaching, the launch of a Diversity, Equity and Inclusion Council, and increased internal and external communications to ensure associates feel supported in the workplace.


What qualities do you look for in tech job candidates?

Overall, we look for people who want to be part of something bigger than themselves. Individuals with a service mindset and a community focus, as well as the requisite technical skills and expertise.


How has hiring been affected since COVID-19?

We’re happy to say that hiring has been business as usual. We’ve onboarded 800 people since March, 2020.

For 2021, we aim to grow our tech workforce by 15%, with a focus on developers in cyber security, data science, UX and EPMO, as well as technical and non-technical project and product managers for next gen government programs.

  • Accepted file types: pdf, png, jpg, docx, doc.

New jobs. Your inbox. Every week. Get it.