Job Title: Lead Data Warehouse Engineer
Job ID #: 12683
Location: Washington, DC
Career Band: BDB
PRINCIPLE ACCOUNTABILITIES: Under the guidance of the Manager the incumbent is responsible for, but are not limited to, the following:
Software Design, Development
Leads in designing and defining core reusable assets that support the long-term business strategy for development efforts.
Leads in design and solution reviews to ensure adherence to performance guidelines & business requirements.
Ensure 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.
Drives the solution design and solution review to ensure the technical architecture design meets the technical objectives, business requirements, and standards.
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.
Software Integration Testing
Assists in software development and enterprise integration testing, system (end to end) testing, and problem resolution related to business applications and/or related middleware components.
Verifies that the Business Requirements as defined in the Project Requirements Document are tested end to end throughout the D&I systems (ODS / EDM / SBI / CBI) .
Ensures planning phases include non-functional requirements for error handling, service level agreements, capacity planning, and that proper test cases are created.
Utilizes HP Application Life Cycle Management toolset (ALM) to record all defects that are discovered during testing and corrected before the final closure of the project.
Coordinate with the enterprise auditing teams as well as external audit requests. This includes tracking all D&I reviews for the fiscal year and participate in all audits with proper D&I project teams: TOS Audit Coordination, CareFirst Corporate Audit Services, and Financial Accounting
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 / D&I 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 outside of D&I.
Ensures all projects comply with Audit, Balance, and Control Framework Standard. This requires the ABC team to work with the project teams to define the ETL audit statistics to be captured in the Audit database.
Conducts system integration testing according to all baselined project requirements.
Conduct validation cycle hand off to Business End-User / DGS to facilitate UAT phase
Ensures proper hand off to D&I Data Governance for UAT and Day to Day production support for project closure. There should be no outstanding severity 1 or 2 tickets prior to deployment.
Works with legal to ensure all new Business Associate Agreements with vendors have a “New” template that includes a Data Use Agreements section. Obtain a separate sign off on that DUA section of the BAA.
Tracks all BAAs for all vendors, consultants, brokers and accounts at CareFirst and present results quarterly to executive management.
Day to Day Support
Addresses Magic tickets (One Stop) for issues reported by end users and the Help Desk.
Maintains current support contact information for each job. This is currently stored in the Magic database for each JCL job as well as in the team’s Application Support List (see Key Documentation).
Presents to Executive Management Quarterly ticket counts, defect trends, and areas for improvement.
Completes analysis, design, development, testing, and deployment of bug fixes as issues are identified.
Coordinates and review defect fixes with the Data Governance Team and downstream consumers. By Q2 2016, the team will include taking over management of the D&I defect process.
Identifies recurring causes for defects and work with the Development and ABC Teams to address these during the development and validation process.
Coordinates with the ABC Team to provide test data management for defect validation.
Coordinates with the D&I Project Intake Team and the D&I Development Team on the prioritization and resourcing of SVETs.
Assists end-users with the intake process for an SVET when changes are requested in a production code and there is not an associated Corporate Initiative.
Works with DGS and business users to define requirements for the change requested.
Completes analysis, design, development, testing, and deployment 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 standards.
Ensure proper deployment procedures are being followed in the production environment and drive the production handover process with the Development Team. This includes the creation of a Production Support document and completed Deployment Checklist.
Ensures sufficient knowledge of any transitioned application has been gained in order to effectively support it.
Coordinates all production support handoffs with the CI Project team and the D&I Audit, Balance, and Control team to ensure all Severity 1 and 2 defects are closed.
Participate in the yearly Disaster Recovery exercise and run any needed test cases to demonstrate the effectiveness of our Disaster Recovery plans and processes.
Works with Information Security to ensure that proper roles are created for all supported systems.
Reviews server utilization (CPU, Memory, & I/O usage) and storage capacity for all supported servers weekly and monthly.
Performs annual data growth assessments to determine current year and future data storage needs.
Works with IT Operations and Storage Teams to ensure production servers always have a buffer of available storage to prevent issues with unforeseen growth spikes.
Cross-trains production support resources on various technologies used in production support and expand the knowledge base to support different applications.
Leads work and projects in a matrix environment
BA/BS in Computer Science, Engineering, Math, Actuarial Science, Information Systems, or other related IT field or equivalent work experience plus;
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 Pyramid Analytics, OLAP Dimensional development, Data Warehousing, Master Data Management (MDM), Customer Data Integration (CDI), IBM Initiate, Oracle, Informatica (9.5.1 or higher) Power Exchange, Informatica Power Center, Tibco, C#, .NET.
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 experience
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.
Department: Data Integration Architect
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.
Actual salary will be based on relevant job experience and work history.
External applicants: Please visit our website to apply: www.carefirst.com/careers
Internal applicants: Please visit PeopleSoft/Employee Self Service/CareFirst Careers
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.
Please apply before: 08/29/2019