CareFirst Careers

Data Warehouse Sr Engineer

Resp & Qualifications

PURPOSE: 

Provide oversight of a small group 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.
Performs complex analyses of technical requirements. Takes leadership on design, coding, testing, implementation of systems and applications software, etc.
Proactively determine solutions and ensure all milestones are met. Escalate to executive management as needed.

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.
  • Ensures all project teams code is to CareFirst specifications and ensure proper unit testing is done for all code.
  • Looks 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, acts 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 provides 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.


QUALIFICATION REQUIREMENTS

BA/BS in Computer Science, Engineering, Math, Acturial 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, defect management, and testing.

Required Skills and Abilities:

Demonstrated expertise leading specific work or resources on a team to deliver results.
Demonstrated experience participating in or leading agile or SCRUM development cycles.

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; ETL and ELT technologies; 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; OLAP Dimensional development; Data Warehousing; Master Data Management (MDM) tools and concepts; Oracle; Microsoft SQL Server; Informatica (9.5.1 or higher) PowerExchange, Informatica Power Center; Tibco; C#; .NET.; Python; AWS and / or Azure stack (including but not limited to AWS Glue, Lake Formation, Redshift, Azure Blob, Azure Data Factory).

Preferred:

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.

Hands on experience in technologies with skills ranging with one or more of the following:  Apache Kafka or similar streaming technologies; Cloud-native or cloud-agnostic integration tools such as Talend, Pentaho or SnapLogic; Open source database management systems such as PostgreSQL; Power BI and/ or Tableau; Snowflake.

#LI-TV1

 

Department

Department: CBIW HCA Development - DC 

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

Closing Date

Please apply before:4/1/2020

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.

PHYSICAL DEMANDS:

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

Learn more about Information Technology