Enterprise Data Warehouse Developer

Your job is more than a job

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.

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.

EXPERIENCE QUALIFICATIONS

• 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

EDUCATION QUALIFICATIONS

• Required: High School Diploma/GED or equivalent.
• Preferred: Bachelor's Degree.

LICENSES AND CERTIFICATIONS

• Preferred Certification Name: Epic Clarity Certification
  • Required
  • Issuer:
  • Licensure Speciality:
  • Entity:

KNOWLEDGE, SKILLS, AND ABILITIES

• 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.
• Preferred: Knowledge of healthcare and clinical systems.
• Preferred: Knowledge of SQL/SSRS/SSIS/Tableau/Crystal Reports/Epic.

REPORTING RELATIONSHIPS

• Does this position formally supervise employees? No

WORK SHIFT:

Days (United States of America)

LCMC Health is a community. 

Our people make health happen. While our NOLA roots run deep, our branches are the vessels that carry our mission of bringing the best possible care to every person and parish in Louisiana and beyond and put a little more heart and soul into healthcare along the way. Celebrating authenticity, originality, equity, inclusion and a little “come on in” attitude is the foundation of LCMC Health’s culture of everyday extraordinary

Your extras

• Deliver healthcare with heart. 
• Give people a reason to smile. 
• Put a little love in your work. 
• Be honest and real, but with compassion.  
• Bring some lagniappe into everything you do. 
• Forget one-size-fits-all, think one-of-a-kind care. 
• See opportunities, not problems – it’s all about perspective. 
• Cheerlead ideas, differences, and each other. 
• Love what makes you, you - because we do

You are welcome here. 

LCMC Health is an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability status, protected veteran status, or any other characteristic protected by law.

The above job summary is intended to describe the general nature and level of the work being performed by people assigned to this work. This is not an exhaustive list of all duties and responsibilities.  LCMC Health reserves the right to amend and change responsibilities to meet organizational needs as necessary.

 

Simple things make the difference. 

1.    To get started, take your time to fully and accurately complete the application for employment. Incomplete applications get bogged down and are often eliminated due to missing information. 

2.    To ensure quality care and service, we may use information on your application to verify your previous employment and background.  

3.    To keep our career applications up-to-date, applications are inactive after 6 months and, therefore, require a new application for employment to be completed. 

4.    To expedite the hiring process, proof of citizenship or immigration status will be required to verify your lawful right to work in the United States.