RestonRecruiter Since 2001
the smart solution for Reston jobs

Senior Data Warehouse Engineer

Company: CareFirst BlueCross BlueShield
Location: Reston
Posted on: July 15, 2019

Job Description:

Resp & Qualifications

PRINCIPAL ACCOUNTABILITIES: Under the guidance of the Manager the incumbent is responsible for, but are not limited to, the following:

  • Support Analysis, Design, Development
  • Support in designing and defining core reusable data assets that support the long-term business strategy for development efforts.
  • Assesses data quality via data profiling and identifies data gaps through gap analysis of desired data versus existing data sources.
  • Develop thorough source to target mappings to populate new, integrated data structures.
  • Look for standardization and reuse opportunities, abstractions and patterns across classes and components to streamline design and development of data integration solutions.
  • Drives the solution design and solution review to ensure the data design and data mappings meet the technical objectives, business requirements, and standards.
  • Drives the design of maintainable data integration logic for existing and new data applications in accordance with the technical specifications.

    Data Integration Testing

    • Assists in data analysis and design, data integration (end to end) testing, and problem resolution related to data and business rules.
    • Verifies that the Data Requirements as defined in the Project Requirements Document are tested end to end throughout the Software Development Life Cycle.
    • Performs data profiling throughout lifecycle to assess data sets and identify data anomalies.
    • Performs data validation to ensure that data integration code is working in accordance with source-to-target mappings.
    • Performs test data management activities including working with the business to obtain a sufficient test data set, coordinate with operations teams for access by all project / staff to environments / storage of test data sets to perform multiple test cycles, and work with enterprise testing for validation of data that is required.
    • Tracks all data issues and escalates to appropriate stakeholders as needed.

      Day to Day Support

      • Works with end users, business analysts, and source system experts to understand business requirements and drive the appropriate data solutions.
      • Research data anomalies to assist development teams in completing data integration development.
      • Coordinates and review data findings with the Data Governance Team and downstream consumers.
      • Completes data analysis, data design, gap analysis and source to target mappings per the specifications of a project.
      • Works closely with the project teams as new projects and point releases are deployed to ensure adherence to published data standards.
      • Ensures sufficient knowledge of any transitioned application has been gained in order to effectively support it.
      • Maintains proper documentation for the source to target mappings and identifies changes as needed to existing mappings.

        Performs data profiling and data validation to better understand data and ensure working data integration solutions.


        BA/BS in Computer Science, Engineering, Math, Actuarial Science, Information Systems, or other related IT field or equivalent work experience plus;

        3-5 years of experience with database management systems, ETL systems, business intelligence tools, gap analysis, source to target mappings, 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; source-to-target mappings; full-cycle system development, test case creation, audit balance and control metrics, relational and dimensional database systems; data quality tools;
        • Strong SQL experience; Experience with OLAP Dimensional development, Data Warehousing, Master Data Management (MDM), Hadoop, Ab Initio, DB2, MS Office.Some Healthcare experiences


          Familiarity with new technologies and how they could be leveraged to benefit the department, new business strategies and corporate initiatives

          Experience with Ab Initio and/or MicroStrategy.Some knowledge of Big Data Technologies


          Department: Data Integration Architect

          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:

          Closing Date

          Please apply before: 08/08/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 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

Keywords: CareFirst BlueCross BlueShield, Reston , Senior Data Warehouse Engineer, Engineering , Reston, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Engineering Jobs

Network Engineer (Lead) with Security Clearance
Description: Network Engineer Lead br Location: Ft. Belvoir, VA br Security Clearance: Top Secret SCI br Salary/Pay Rate - br FT/PT Status: Full Time Employment br Job Code: 2019-C4ISR-002 Essential Duties (more...)
Company: Advanced Systems Development
Location: Fort Belvoir
Posted on: 07/19/2019

Network Engineer- TS/SCI w/Poly with Security Clearance
Description: Job Description: Leidos has a career opening for a Jr. Network Engineer in Laurel, MD. PROGRAM SUMMARY: This particular contract modernizes and ensures the uninterrupted availability of a critical component (more...)
Company: Leidos
Location: Laurel
Posted on: 07/19/2019

AI Data Architect/ Data Engineer
Description: OverviewWhat do you get when you bring together the brightest minds and place them into an exciting, fast-paced environment that fosters intellectual growth and rewards based on impact, not tenure --You (more...)
Company: Guidehouse
Location: Washington
Posted on: 07/19/2019

Senior Engineers (Transmission Electrical/Mechanical Engineer -
Description: Senior Engineers Transmission Electrical/Mechanical Engineer - Description At Exelon, we've got a place for you Join the nation's leading competitive energy provider, with one of the largest electricity (more...)
Company: Exelon Corporation
Location: Baltimore
Posted on: 07/19/2019

Senior Spacecraft Power Electronics Engineer
Description: Job Description Are you searching for meaningful work in Spacecraft Power Electronics design and development Are you passionate about Space If so, we're looking for someone like you to join our team (more...)
Company: Johns Hopkins University Applied Physics Laborator
Location: Laurel
Posted on: 07/19/2019

Diesel Mechanic
Description: Diesel Mechanic Join the Red Crew as a Diesel Mechanic Red Classic is the dedicated carrier and wholly owned subsidiary of Coca-Cola Consolidated, Inc. At Red Classic we provide technicians with the
Company: Red Classic - Maintenance Mechanic
Location: Baltimore
Posted on: 07/19/2019

Automated Test Engineer II
Description: Are you ready to build it, break it, and then rebuild it even better Do you have proven success in designing better and creative ways to break software and identifying potential problems Parsons is (more...)
Company: Parsons
Location: Columbia
Posted on: 07/19/2019

IT Security Engineer
Description: Symplicity is a U.S. technology company building the world's leading student success software. With two decades of experience in the Education Technology space, we are deployed at more than 1,000 universities (more...)
Company: Symplicity Corporation
Location: Arlington
Posted on: 07/19/2019

91B Light-Wheel Vehicle Mechanic
Description: 91B Light-Wheel Vehicle MechanicJob ID: Job Views: 142Location: REISTERSTOWN, Maryland, United StatesZIP Code: 21136Job Category: Mechanic and MaintenancePosted: 05.29.2019Age Requirements: Must be between (more...)
Company: Army National Guard
Location: Reisterstown
Posted on: 07/19/2019

Computational Fluid Dynamics (CFD) Engineer
Description: PRINCIPAL DUTIES AND RESPONSIBILITIES: br br The successful applicant will join ATR's Engineering and Systems Division, working as a team member on site as Computational Fluid Dynamics CFD Engineer (more...)
Company: Advanced Technology and Research Corporation
Location: Bethesda
Posted on: 07/19/2019

Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Reston RSS job feeds