CareFirst– Data Integration Manager


Job Title: Data Integration Manager

Location: Washington, DC

Career Band: BDC

Job ID #:  9567

The FEPOC Manager, Data Integration contributes to the overall enablement of a comprehensive Enterprise Data Foundation, including Operational Data Store, Data Marts and Big Data environments, for collecting data from multiple systems into centralized data structures for analytics and reporting along with supporting enterprise operational needs.  As the Data Integration Manager, the incumbent’s accountabilities include, but are not limited to, the following (Note, at any given time, incumbent’s job may have a project manager focus, production support focus, a developer focus, a tester focus, and/or a functional analyst focus) :
The manager shall be responsible, in close coordination with the FEPOC Data Warehouse Director, for building and maintaining an effective team for all data migration activities. The manager shall perform staff planning activities to forecast needs, assess staff capabilities and manage on boarding and off boarding of resources when necessary. The manager shall work closely with staff to perform career development activities, including performance appraisals, training plans, goals and objective setting, and regular one-on one meetings.
The manager shall work with the project team to achieve project goals and should work in a collaborative manner to complete all tasks within project schedules. This may require coordination of work in areas of estimating, requirements gathering, designing, coding, testing, capacity planning, quality assurance, and planning.  The manager will coordinate activities with customer stakeholders, dependent organization stakeholders and Informatics personnel to deliver solutions and meet all project milestones.
The manager shall operate within an enterprise data warehouse environment, analyze and translate functional specifications and change requests into technical specifications including an estimated level of effort. This task shall also include support for any Project Requirement Documentation in detailing all technical specifications as agreed upon between the business and technical staff. This may include coordinating multiple business and technical teams to ensure the accuracy and integrity of enterprise wide data and applications associated with it.
Maintains ahigh level of knowledge in data integration practices, data warehouse and big data techincal architectures and industry leading tools in order to provide corporate vision and oversight of current environment. Manager works closely with FEPOC Data Warehouse Director and FEPOC Data Integration Architect to make recommendations which enable FEPOC to establish and maintain a valued and trusted data environment.

This position is also subject to being “on call” for emergency situations requiring immediate resolution.  Travel between all CareFirst locations may be required.

SUPERVISORY RESPONSIBILITY: Responsible for 5-10 direct reports and 5-10 contractors.

Minimum Qualifications:

Required experience, abilities and skills:
This position requires a College degree in Computer Science, Engineering, or related technical field such as Information Management or equivalent experience. This position requires 7 to 10+ years of management experience with as least 5 number of years in data warehousing work with an emphasis on extract, transform and load work. Must have data warehouse environment experience designing data models, extracting and loading data, and running SQL queries.
The following software and technology experience is needed:

• At least 5 years serving in a project lead role.
• At least 5 years of Ab Initio or other Extract / Transform / Load toolset.
• At least 3 years of test experience
• At least 1 year with a transactional toolset such as Tibco or MQ Server
• At least 3 years of SQL work
• At least 1 year of writing Store Procedures  and  XML files
• At least 1 years of Unix Shell Scripting

• Experience in full life cycle project/program management and leadership.
• Proven ability to budget, organize and manage teams.
• Must be able to teach, develop, and motivate associates.
• Excellent oral and written communications abilities are necessary along with the ability to present clearly to executive level leadership.
• Excellent interpersonal skills including the ability to build consensus and agreement and bring resolution to contentious issues and entrenched interests.
• Proven ability to lead problem-solving discussions.
• This position requires strong analytical and organizational skills with the ability to expand technical / business knowledge appropriate to the team through reading, research, on-the-job training and classroom training.

Solid understanding of Health Care industry. Knowledge of other software packages such as debugging tools, an e-mail tool, and 4th generation languages are preferred.

Department: Federal Employee Program Data Warehouse

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.

Please visit our website to apply:

PeopleSoft/Self Service/Recruiting

Actual salary will be based on relevant job experience and work history.

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.

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

Please apply before: 3/21/2017



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s