Enterprise Data Warehouse Developer - Remote

LCMC Health

2d•Remote

About The Position

Your job is more than a job REMOTE REQUIREMENT Must be a resident of Texas, Louisiana, Mississippi, Alabama, Florida or Georgia GENERAL DUTIES General: 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. Data Product Development: 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. Data Warehouse Owner: 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. Project Management: Assists in the development of work plans, task sequencing. Utilizes change management process. Performs as required: 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.

Requirements

Must be a resident of Texas, Louisiana, Mississippi, Alabama, Florida or Georgia
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
High School Diploma/GED or equivalent.
Epic Clarity Certification Required
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

Bachelor's Degree.
Knowledge of healthcare and clinical systems.
Knowledge of SQL/SSRS/SSIS/Tableau/Crystal Reports/Epic.

Responsibilities

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.