Share this Job
Apply now

Apply for Job

Business Intel Dev-Analyst

Decision Support 
Full Time 
Day Shift 
40 hrs / week

Rated as one of the Top 25 Best Hospitals to Work for in the U.S., the heart of LMC is our 508-bed modern state-of-the-art facility. Winning the prestigious, "Summit Award" from Press Ganey for outstanding patient satisfaction, "Consumer Choice Award" from the National Research Corporation, all contributing to our reputation for giving our patients the highest quality care.  Lexington Medical Center was voted one of South Carolina’s “Best Places to Work” for 2019!

We are located in heart of the Midlands, right outside of Columbia, SC, and one of the most successful integrated healthcare systems in the Southeast. As the third largest employer in the Midlands, we invite you to be a part of our ongoing success and join our LMC Family.

Job Summary

Under the general direction of the Director of Decision Support, assists business partners with implementing and utilizing decision support and business intelligence (BI) software solutions to transform data into information in order to achieve clinical and business goals/objectives. This includes: (1) collaborating with functional users and other internal and external resources to gather data requirements to design, develop, enhance and support reporting applications (2) assisting with implementation efforts of BI / Decision Support technologies and tools  including system selection / evaluation, analysis / design, development / implementation, and ongoing support / maintenance (3) providing  data reporting, extracting, management and analysis services to assist with problem solving, decision making and strategic planning (4) promoting/ensuring system data integrity by applying technical knowledge to resolve system issues as well as identify enhancements to improve data quality, security and operational efficiencies. Maintains/promotes excellent communications and interpersonal relationships, serving as liaison between business units and IS assisting with report/data generation, analysis and interpretation and user training as required.

Minimum Qualifications

•Minimum Education: Bachelor's Degree in Computer Science, Information Technology, Statistics, Business or Health Care Administration
•Minimum Years of Experience: 3 Years of related experience;
3 Years of experience in requirements gathering, data analysis, data modeling or report design/development (may be included in above);
3 years of previous programming experience (may be included in above).
•Substitutable Education & Experience: A Bachelor's Degree with 3 years of related experience can be substituted for one of the following:
An Associate's Degree in a related field plus 5 years of direct report writing/development experience may be considered;
7 Years of direct programming/development experience
•Required Certifications/Licensure: Must be willing to obtain vendor EHR and/or other technical certifications as required
•Required Training: Proficiency in using BI and Microsoft SQL reporting technologies/tools (ex. SSRS, SSAS, OLAP, Crystal Reports, Cognos, Business Objects) to develop BI solutions including data extracts, queries, reports, dashboards, scorecards to meet end user requirements regarding access to system information;
Proven experience with relational database structures, theories, principles and practices including data warehouse concepts and technologies, data governance and data modeling;
Excellent verbal, written, presentation and interpersonal communication skills, experience working with directly with key operational personnel with ability to serve as an effective change agent/advocate;
Advanced analytical and problem solving skills with ability to evaluate problems, identify and implement creative, innovative  and effective solutions;
Excellent organizational skills with ability to coordinate concurrent projects and handle multiple priorities, ambiguity, continuous change and high-pressure situations;
Proficiency in PC productivity tools such as Microsoft Office Suite (Excel, Word, Outlook, Project, Access, PowerPoint).

Essential Functions

  • Develops analytical and operational reports to assist clinical and business unit leaders with their strategic, financial, and operational decision making processes
  • Participates in development meetings, interviews, reviews and design sessions and collaborates across service lines, functions and levels of organization to determine requirements for reports, extracts, data analyses, metadata, data governance, data quality and performance
  • Demonstrates proficiency in use of BI system application tools including Microsoft SQL (SSRS, SSAS) and other report writers (Crystal, Business Objects, Cognos) screen designers, import/export utilities as well as drill down features/analyzers (OLAP)
  • Provides business units / departments with the tools, technology, and applications to access clinical, financial, and administrative information on a timely basis
  • Designs, develops, tests, documents and implements templates, filters, reports, dashboards, scorecards and extracts to leverage data environment to meet business unit needs.
  • Participates in data modeling, metadata development and data security administration activities including identification/maintenance/documentation of usage standards and data element, calculation, metric and statistical definitions
  • Assist with audits and data validation activities to promote and insure data accuracy and quality
  • Consistently promotes data quality and governance to help ensure integrity of revenue, clinical, budget, operational, forecast and other key enterprise information assets
  • Assist with business unit analysis, information requirements definitions, source data identification, data quality definitions, data extraction, transformation, load/import (ETL) and summarization processing.
  • Serves as liaison with IS team members to translate data requirements into technical specifications, help identify and assess potential data sources and establish procedures to insure data quality including validation of ETL processing.
  • Collaborates with IS and DBAs to administer computerized databases including design, backup recovery, monitoring, reorganization, and development of database standards to achieve optimal performance
  • Creates and carries out deployment tasks, business workflow interpretation, and participates in application build, testing and support

Duties & Responsibilities

  • Troubleshoots and triages problems identified within BI and related source applications, developing SQL scripts to  respond to data issues and communicating with vendors and IS technology resources to resolve system issues
  • Provides support for performance improvement initiatives by resolving data retrieval issues and identifying opportunities to more efficiently extract, manipulate, analyze, report and disseminate system data.
  • Serves as process change advocate; research and challenge existing processes, assist with development of process change recommendations based upon pertinent data analysis in order to help improve functional workflows.
  • Develops and maintains related system documentation to support new implementations, software upgrades, program modifications and customizations including configuration manuals, data definitions, in-house diagrams and process flow charts according to department standards
  • Participates in short, medium and long range system planning including evaluating new applications implemented within the organization with respect to determining the impact to business intelligence data sources
  • Assists with system selections/acquisition of BI and Decision Support applications, programs and tools, including participating in initial system design and configuration, as well as providing testing, implementation and training support as needed
  • Participates in project management tasks, support team goals, objectives and timelines as required working with a sense of urgency and accuracy to ensure effective implementation as well as initiate/maintain project resources, plan documentation and coordinate communication updates as necessary.
  • Utilizes technical and programming expertise to strengthen the knowledge and skills of related team members.
  • Attends continuing education courses, seminars and conferences to keep abreast of BI and Decision Support technology developments
  • Maintains an optimistic, professional and positive demeanor, exemplifies excellent customer relations toward patients, visitors, physicians, and coworkers.  Holds self accountable and serves as role model for conformity to Service Expectations Policy.
  • Performs all other duties as assigned by authorized personnel or as required in an emergency, e.g., fire or disaster.

We are committed to offering quality, cost-effective benefits choices for our employees and their families:

  • Day ONE medical, dental and life insurance benefits 
  • Health care and dependent care flexible spending accounts (FSAs)
  • Eligible employees may also enroll in LMC's retirement plans on their date of hire, including the South Carolina State Retirement System (SCRS)
  • Supplemental 401(k)
  • 457(b) retirement plans
  •  Free life insurance – equal to 1x salary
  • Adoption assistance
  • 401(K) Match – LMC matches dollar for dollar up to 6% 
  • LMC provides its full-time employees short-term disability and long-term disability coverage after 90 days of eligible employment
  • 529 College Savings
  • Tuition reimbursement
  • Student loan forgiveness

Equal Opportunity Employer

It is the policy of LMC to provide equal opportunity of employment for all individuals, and to remain compliant with applicable state and federal laws and regulations. LMC strives to provide a discrimination-free environment, and to recruit, select, on-board, and employ all employees without regard to race, color, religion, sex, age, disability, national origin, veteran status, or pregnancy, childbirth, or related medical conditions, including but not limited to, lactation. LMC endeavors to upgrade and promote employees from within the hospital where possible and consistent with the employee’s desires and abilities and the hospital’s needs.

Nearest Major Market: Columbia
Nearest Secondary Market: South Carolina

Apply now

Apply for Job