Enterprise Data Warehouse Developer

LCMC Health

About The Position

The Enterprise Data Warehouse Developer works under minimal supervision and is responsible for performing a variety of technical work associated with analyzing technical requirements, evaluating database (and associated subproduct) design, and creating database deliverables to support the creation of business intelligence and reporting products. The ideal candidate will be an experienced team leader capable of setting best practices and establishing processes to support those practices. The developer will assist in the discovery and analysis of requirements, collaborate with the respective BID team members on design and data modeling, and build data structures and processes to meet the needs of the BID team to provide best in class end-products to providers, staff, and executive leadership.

Requirements

9 years of experience in IT with a High School Diploma
7 years of experience in IT with an Associate's Degree
5 years of experience required with a Bachelor's degree
Required: High School Diploma/GED or equivalent.
Ability to conceptualize and analyze complex requests and create meaningful data architecture.
Ability to work independently and manage time well.
Ability to create dashboards and reports and deliver them to clinical and business colleagues.
Ability to maintain assigned reports, programs and systems.
Ability to communicate effectively orally and in writing.
Ability to understand functionality and relationships between supported applications.
Excellence in customer service and superior teamwork skills.
Expertise in data architecture, data loading and transformation, warehousing, automation processes, and associated security measures.

Nice To Haves

Preferred: Bachelor's Degree.
Preferred Certification Name: Epic Clarity Certification
Required Issuer: Licensure Speciality: Entity:
Preferred: Knowledge of healthcare and clinical systems.
Preferred: Knowledge of SQL/SSRS/SSIS/Tableau/Crystal Reports/Epic.

Responsibilities

Demonstrates ability to represent Information Technology in a respectful and professional manner.
Completes assigned tasks per defined project scope, timelines, and budgets.
Demonstrates a driven, creative, self-motivated personality with a strong desire to succeed.
Understands interconnectivity and integration with EMR and third-party applications.
Works with internal IT teams on technical troubleshooting, integration, reporting, and training.
Demonstrates creativity and passion to continuously learn.
Follows department standards and procedures.
Communicates effectively with technical team at all levels and with users at a non-technical and clinical level.
Alerts leadership/senior staff members of any outages, problems, or delays.
Maintains knowledge of health care, technology, and industry trends.
Maintains appropriate certifications.
Provides mentoring and assistance to other team members as able, especially Business Intelligence Developers.
Guides the team in analysis, design, and development.
Develops and sets standards and best practices for the team.
Collects data regarding current IT environment and documents workflows and system access.
Develops data products (tables, DataMart's, stored procedures, imports/extracts, etc.) to support the development of reports, dashboards, and other outputs according to required specifications and objectives.
Works in conjunction with other users and departments to assist them in their decision-making process by developing worthwhile, meaningful, and informative reports.
Provides knowledge on use of basic functionality for dashboards and reporting tools that the team produces or manages.
Applies analytical skills to define the information requirements necessary to design, build, and install upgrades and/or new implementations.
Makes recommendations for reporting products based on system capabilities versus customer needs.
Develops and/or evaluates previously refined data and programs and selects from a range of alternatives to determine the appropriate action to be taken.
Consolidates and optimizes available data warehouse infrastructure.
Conceives analytics and business intelligence platform architecture for clients, including internal and third-party clients.
Designs and implements ETL procedures for intake of data from both internal and outside sources as well as ensures data is verified and quality is checked.
Designs and implements ETL processes and data architecture to ensure proper functioning of analytics lad, as well as client’s or third-party’s reporting environments and dashboard.
Collaborates with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
Carries out monitoring, tuning, and database performance analysis.
Performs the design and extension of data marts, meta data, and data models.
Ensures all data warehouse architecture codes are maintained in a version control system.
Assists in the development of work plans, task sequencing.
Utilizes change management process.
Completes required documentation.
Serves as member of various employee committees to discuss reporting needs.
Coordinates activities with other departments and work groups as needed.
Serves as a backup to related positions as needed.
Participates in on call rotation.
Helps Desk support as needed.
Performs related duties as assigned.