Share this Job

Data Warehouse Developer/Inter

Date: Jun 24, 2019

Location: Charlotte, NC, US, 28208

Company: Atrium Health

Job Req ID: 187845

Position Number: 00155830

Employment Type: Full Time

Shift: Variable/On Call

Shift Details: Day Shift

Standard Hours: 40.00

Department Name: IAS Enterprise Data Mgmt

Location: CHS Corporate Operations

Location Details:  Airport Center Building E

Carolinas HealthCare System is Atrium Health. Our mission remains the same: to improve health, elevate hope and advance healing - for all. The name Atrium Health allows us to grow beyond our current walls and geographical borders to impact as many lives as possible and deliver solutions that help communities thrive. For more information, please visit carolinashealthcare.org/AtriumHealth

 

 

Job Summary
Develops and maintains data warehouse data management processes, query, and reporting tools, and analytical applications. Documents and analyzes data warehouse/decision support business requirements and associated source systems to build the application architecture and data management architecture. Designs, codes, test, debugs, documents, and maintains the analytical applications and data management process.

Essential Functions

  • Identifies, defines, and documents business requirements including information, cleansing, transformation, retention, summarization, and SLA requirements. Analyzes these requirements together with the data architect to determine data warehouse subject areas and data needs. Participates in database design sessions to ensure the data model meets the business requirements and supports the technical needs of the analytical applications.
  • Designs, builds, and configures analytical applications and data access tools to meet business requirements. Establishes data classifications, data definitions, and data relationships and ensures this information is populated into the metadata repository.
  • Analyzes business requirements and source system data structures to develop detailed source to target data mappings and data transformation rules. Develops data extract requirements for source system teams. Performs an in-depth analysis of source system data to ensure data adheres to identified business rules. Develops conceptual and detailed designs to extract, cleanse, transform, integrate, load, and summarize source data for the data warehouse (ETL processes). Confers with the data architect to ensure compatibility of design with data warehouse data model.
  • Builds unit test, and integration tests systems interfaces, extract, transformation, load, and integration processes, and associated reports. Ensures that the programs adhere to the design specifications and that all tests are documented appropriately.
  • Conducts system tests, customer acceptance tests, and performance tests to certify the integrity of the data warehouse environment. Develops, executes, and documents test cases to validate report accuracy against documented requirements and to verify the outcome of the data warehouse data management processes.
  • Understands and implements data security and monitors and ensures data quality.
  • Helps design and administer the metadata repository and updates it with source to target mappings and associated cleansing/transformation rules.
  • Handles all training on the data warehouse data content, access tools, and management processes.

 

Physical Requirements
Work is subject to high-level visibility through exposure to Atrium administration. This position requires high degree of proficiency in verbal and written communications. Must be on call to respond to data warehouse production needs. Must be able to work in an air-conditioned environment. Must be able to lift up to 35 lbs from floor to waist high tables or shelves six feet above floor level.

Education, Experience and Certifications
High School Diploma or GED required; Bachelors Degree preferred. 2 years experience in designing, implementing and supporting data warehouse/decision support systems. Strong skills in design and development components, Oracle applications development, batch architecture development, AIX, SQL, PL/SL, relational database design/dimensional modeling, Business Objects, Visual Basic, Windows NT/Windows 2000. Preferable strong skills in design and development components, IBM Netezza PL/SQL, SQL Server/T-SQL, and relational database design/dimensional modeling.

 

 

At Atrium Health, formerly Carolinas HealthCare System, our patients, communities and teammates are at the center of everything we do. Our commitment to diversity and inclusion allows us to deliver care that is superior in quality and compassion across our network of more than 900 care locations.

 

As a leading, innovative health system, we promote an environment where differences are valued and integrated into our workforce. Our culture of inclusion and cultural competence allows us to achieve our goals and deliver the best possible experience to patients and the communities we serve.

 

Posting Notes: Not Applicable

Carolinas HealthCare System is an EOE/AA Employer


Nearest Major Market: Charlotte

Job Segment: Data Warehouse, Database, Oracle, Developer, Data Management, Technology, Data