ETL - Technical Systems Analyst (Abinito or Informatica)

Blue Cross and Blue Shield Is currently seeking a ETL Systems Analyst in Washington, DC, or Chicago.

Blue Cross Blue Shield Association, also known as BCBS, BCBSA, or The Blues, is a United States-based federation with 34 independent and locally operated BCBSA companies that provide health insurance in the United States to more than 115 million people as of 2022.

Relocation assistance is available.

As a Systems Analyst you will:

Be responsible for the design, development and implementation of advanced technology systems and data standards to meet the needs of business. Partners with customers to understand business requirements to create the technical functional specifications.

Acts as an internal data consultant to advise and influence business and technical partners.

This role is specifically located within the Systems Analyst Group under the Federal Employee Program (FEP).

The FEP IMS SA group helps maintain the infrastructure and data for a large clinical data ecosystem.

We work closely with business data SMEs and technical implementation teams to build data pipelines and reporting applications.

Our goal is to serve as a trusted advisor to the business and as a technical advisor to the technical teams.

Validate and ensure business requirements are thorough, detailed, and concise. Ensure exceptions to the above are documented and approve by management.

Be responsible for all SA artifacts, per EPMO guidelines are developed, reviewed, and signed off. Responsible for tagging System Use Cases.

Ensure exceptions to the above are documented and approve by management.

Provide support to business and serve as the SME for applications.

Provide forecasts and detailed estimates for SA activities and artifacts.

Be responsible for providing weekly status, on time, to all stakeholders. Responsible for researching customer issues and escalating risks/issues appropriately and in a timely manner. Test and investigate issues to determine the appropriate resolution.

Complete assigned responsibilities and prepare for team meetings. Attend team meetings on time and ensure effective usage of time. Complete timesheets accurately and ensure time is reported regularly with the proper allocation of time spent on projects.

Participate in department standards/templates and skill development.

Act professionally and foster positive relationships with other groups.

Responsible for identifying/vocalizing areas for improvements, implementing process improvements and ensuring long term compliance.

Contribute to the creation and maintenance of structured design methodologies and processes for the department.

Basic Qualifications:

High School Diploma or GED, bachelor’s degree in computer science, Information Systems, Business Administration, or other related field, or equivalent work experience in similar work environment.

Minimum 5 years of IT work experience focused on systems development and programming.

Experience with databases and SQL (Prefer DB2)

Experience with ETL (preferably AbInitio or Informatica)

Reporting system experience (preferably Cognos)

Experience with Data Modeling, Data analysis, data profiling and data manipulation skills.

Experience with implementing ETL systems and reporting systems.

Data warehouses and data mart experience in exploring and writing functional requirements with business/tech teams.

Experience writing example documents: Functional Requirements Specifications (FRS), Requirements Traceability Matrix (RTM), Source to Targets (S2Ts), Data Exchange Documents (DEDs), and Data Models.

Preferred Qualifications:

BCBS or health insurance industry background

Ability to effectively adapt to rapidly changing technology and apply it to business needs.

Familiar with various development methodologies.

Familiar with data governance, data lineage, data quality, and security.