Data Warehouse Developer - Senior

Department: 34036 Carolinas Medical Center - LC: Nursing Administration: Morehead Status: Full time

Benefits

Eligible: Yes Hours Per Week: 40 Schedule Details/Additional Information: Varies Job Summary Manages all activities related to the development and administration of data warehouse data management process, query and reporting tools, and analytical applications. Analyzes data warehouse/decision support business requirements and associated source systems to design and develop the application architecture and data management architecture. Handles the detailed design specification development, coding, testing, debugging, and documentation associated with implementing and maintaining the analytical applications and data management processes. Healthcare experience required. Experience with EPIC is a plus. Essential Functions

• Develops work plans, estimates tasks, and provides budget input for items related to the development of data warehouse data management processes and analytical applications. Provides input into determining project scope and is able to communicate and manage project scope.
• Identifies, defines, documents, analyzes, and obtains customer sign-off on data warehouse/decision support business requirements. Analyzes these requirements to establish the application architecture.
• Establishes the data management architecture through an analysis of business requirements, source system data, and source system application architectures. Evaluate and approve technical architecture and to define the optimal location and configuration of extract, load, and transformation routines. The data management architecture addresses batch architecture requirements such as restart/recovery, automated control total reconciliation, standard control reports, error handling procedures, and automated scheduling of data management processes.
• Coordinates development of extract routines with source system team loads.
• Manages data security including data encryption, user and group management, views, and security modes available for the data warehouse and the data access tools.
• Administers the metadata repository, controlling repository entries, updates, and deletions. Designs the metadata repository with the application developer. Develops procedures for providing customers with central access to refresh status information.

Physical Requirements Work is subject to high-level visibility through exposure to administration. Must have excellent verbal and written communication skills. Work requires on call (beeper) to respond to data warehouse production needs. Works in an air-conditioned environment. Must be able to lift, place, and remove equipment 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; Bachelor's Degree preferred. 4 years experience in designing, implementing, and supporting Data Warehouse/decision support systems. Pay Range $50.05 - $75.10 Our Commitment to You: Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more - so you can live fully at and away from work, including:

Compensation

• Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training
• Premium pay such as shift, on call, and more based on a teammate's job
• Incentive pay for select positions
• Opportunity for annual increases based on performance

Benefits and more

• Paid Time Off programs
• Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
• Flexible Spending Accounts for eligible health care and dependent care expenses
• Family benefits such as adoption assistance and paid parental leave
• Defined contribution retirement plans with employer match and other financial wellness programs
• Educational Assistance Program

About Advocate Health Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation's largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits. Apply tot his job Apply To this Job