Atrium Health
BI Developer II
Atrium Health, Winston Salem, North Carolina, United States, 27104
Job Description
JOB SUMMARY : Responsible for building, implementing and supporting Business Intelligence (BI) solutions. Possesses experience in all stages of BI project work such as requirements gathering, logical and physical design, implementation, testing and deployment. Has an expert level of reporting and analytics tools and advanced experience with BI tools and environments such as Microstrategy, Cognos, MS BI Stack, etc. Conducts training programs and knowledge transfer sessions to peers and users as needed and can create mission-critical enterprise level solutions.
EDUCATION/EXPERIENCE:
Bachelor's degree in Computer Science and two years' directly related experience. Five years of directly relevant development and/or programming experience may be substituted in lieu of education.
The following Epic certifications or experience is desired:Clarity Data ModelAccess Data ModelClinical Data ModelCaboodle Data ModelRevenue Data ModelCogito Tools AdministrationRadar AdminReporting Workbench Admin
LICENSURE, CERTIFICATION, and/or REGISTRATION : N/A
ESSENTIAL FUNCTIONS:
1. Develops standard reports, extracts, data cubes and functional dashboards based on business requirements.
2. Prepares detailed technical and user documentation from which data cubes and relational data tables will be created. Ensures complete and accurate data solution definitions.
3. Serves as a reference for analytic and data visualization software packages.
4. Investigates, resolves and follows up on system related problems. Collaborates on system design conflicts.
5. Maintains and further develops existing BI solutions with a focus on multidimensional cubes and MDX.
6. Maintains data models to design, develop and generate both standard and ad-hoc reports.
7. Works within established guidelines, standards and methodologies for creating BI solutions and documentation. Recommends changes to established guidelines, standards, methodologies and conventions as appropriate.
8. Safeguards protected healthcare information from unintentional disclosure in compliance with applicable rules and regulations.
9. Maintains professional growth and development through seminars, workshops and professional training opportunities.
10. Performs other duties as assigned.
SKILLS/QUALIFICATIONS : Expert level of proficiency and experience with relational database concepts and query tools. Expert level of proficiency in SQL query syntax, data cube (OLAP) design, build and maintenance and data extraction methodologies. Advanced background in programming, system analysis, design and problem solving. Superior ability to translate user requirements into functional and technical specifications, wireframe designs, draft reports and final products. Advanced experience with data visualization and analytics tools. Demonstrated expertise with patient care-oriented databases, hospital-based administrative database applications and data warehousing technology is preferred. Superior problem solving skills. Strong initiative and proven ability to work independently. Able to communicate on a professional level with customers and staff. Excellent interpersonal and communication skills. High tolerance for ambiguity and conflict. Strong sensitivity to customer service. Familiarity with change management.
WORK ENVIRONMENT:
Fast paced and occasionally long, irregular hours Subject to ambiguity and conflict Subject to interruptions Occasional travel required
PHYSICAL REQUIREMENTS:
0% 35% 65% to to to 35% 65% 100% N/A Activity X Standing X Walking X Sitting X Bending X Reaching with arms X Finger and hand dexterity X Talking X Hearing X Seeing Lifting, carrying, pushing and or pulling: X 20 lbs. maximum X 50 lbs. maximum X 100 lbs. maximum
About Us
Atrium Health Wake Forest Baptist is a pre-eminent academic health system based in Winston-Salem, North Carolina. Atrium Health Wake Forest Baptist is part of Advocate Health, which is headquartered in Charlotte, North Carolina, and is the fifth-largest nonprofit health system in the United States, created from the combination of Atrium Health and Advocate Aurora Health. Atrium Health Wake Forest Baptist's two main components are an integrated clinical system - anchored by Atrium Health Wake Forest Baptist Medical Center, an 885-bed tertiary-care hospital in Winston-Salem - that includes Brenner Children's Hospital, five community hospitals, more than 300 primary and specialty care locations and more than 2,700 physicians; and Wake Forest School of Medicine, the academic core of Atrium Health Enterprise and a recognized leader in experiential medical education and groundbreaking research that includes Wake Forest Innovations, a commercialization enterprise focused on advancing health care through new medical technologies and biomedical discovery.
Wake Forest Baptist Health, Wake Forest University School of Medicine and Atrium Health have joined forces in a strategic combination that will enhance care, transform medical education and create economic opportunity for countless lives in North Carolina and beyond. As a part of that combination, the two health systems will be integrating technology and platforms, including our career sites.
This means that although you are applying on the Wake Forest Baptist Health Career Site, you receive communications from the Atrium Health Recruitment Team. Please know that this is an expected process, and thanks in advance for your flexibility.
About the Team
Mission, Vision and Culture Commitments
Mission
To improve health, elevate hope and advance healing - for all.
Vision
To be the first and best choice for care.
Culture Commitments
We create a space where all Belong
We Work as One to make great things happen
We earn Trust in all we do
We Innovate to better the now and create the future
We drive for Excellence - always
JOB SUMMARY : Responsible for building, implementing and supporting Business Intelligence (BI) solutions. Possesses experience in all stages of BI project work such as requirements gathering, logical and physical design, implementation, testing and deployment. Has an expert level of reporting and analytics tools and advanced experience with BI tools and environments such as Microstrategy, Cognos, MS BI Stack, etc. Conducts training programs and knowledge transfer sessions to peers and users as needed and can create mission-critical enterprise level solutions.
EDUCATION/EXPERIENCE:
Bachelor's degree in Computer Science and two years' directly related experience. Five years of directly relevant development and/or programming experience may be substituted in lieu of education.
The following Epic certifications or experience is desired:Clarity Data ModelAccess Data ModelClinical Data ModelCaboodle Data ModelRevenue Data ModelCogito Tools AdministrationRadar AdminReporting Workbench Admin
LICENSURE, CERTIFICATION, and/or REGISTRATION : N/A
ESSENTIAL FUNCTIONS:
1. Develops standard reports, extracts, data cubes and functional dashboards based on business requirements.
2. Prepares detailed technical and user documentation from which data cubes and relational data tables will be created. Ensures complete and accurate data solution definitions.
3. Serves as a reference for analytic and data visualization software packages.
4. Investigates, resolves and follows up on system related problems. Collaborates on system design conflicts.
5. Maintains and further develops existing BI solutions with a focus on multidimensional cubes and MDX.
6. Maintains data models to design, develop and generate both standard and ad-hoc reports.
7. Works within established guidelines, standards and methodologies for creating BI solutions and documentation. Recommends changes to established guidelines, standards, methodologies and conventions as appropriate.
8. Safeguards protected healthcare information from unintentional disclosure in compliance with applicable rules and regulations.
9. Maintains professional growth and development through seminars, workshops and professional training opportunities.
10. Performs other duties as assigned.
SKILLS/QUALIFICATIONS : Expert level of proficiency and experience with relational database concepts and query tools. Expert level of proficiency in SQL query syntax, data cube (OLAP) design, build and maintenance and data extraction methodologies. Advanced background in programming, system analysis, design and problem solving. Superior ability to translate user requirements into functional and technical specifications, wireframe designs, draft reports and final products. Advanced experience with data visualization and analytics tools. Demonstrated expertise with patient care-oriented databases, hospital-based administrative database applications and data warehousing technology is preferred. Superior problem solving skills. Strong initiative and proven ability to work independently. Able to communicate on a professional level with customers and staff. Excellent interpersonal and communication skills. High tolerance for ambiguity and conflict. Strong sensitivity to customer service. Familiarity with change management.
WORK ENVIRONMENT:
Fast paced and occasionally long, irregular hours Subject to ambiguity and conflict Subject to interruptions Occasional travel required
PHYSICAL REQUIREMENTS:
0% 35% 65% to to to 35% 65% 100% N/A Activity X Standing X Walking X Sitting X Bending X Reaching with arms X Finger and hand dexterity X Talking X Hearing X Seeing Lifting, carrying, pushing and or pulling: X 20 lbs. maximum X 50 lbs. maximum X 100 lbs. maximum
About Us
Atrium Health Wake Forest Baptist is a pre-eminent academic health system based in Winston-Salem, North Carolina. Atrium Health Wake Forest Baptist is part of Advocate Health, which is headquartered in Charlotte, North Carolina, and is the fifth-largest nonprofit health system in the United States, created from the combination of Atrium Health and Advocate Aurora Health. Atrium Health Wake Forest Baptist's two main components are an integrated clinical system - anchored by Atrium Health Wake Forest Baptist Medical Center, an 885-bed tertiary-care hospital in Winston-Salem - that includes Brenner Children's Hospital, five community hospitals, more than 300 primary and specialty care locations and more than 2,700 physicians; and Wake Forest School of Medicine, the academic core of Atrium Health Enterprise and a recognized leader in experiential medical education and groundbreaking research that includes Wake Forest Innovations, a commercialization enterprise focused on advancing health care through new medical technologies and biomedical discovery.
Wake Forest Baptist Health, Wake Forest University School of Medicine and Atrium Health have joined forces in a strategic combination that will enhance care, transform medical education and create economic opportunity for countless lives in North Carolina and beyond. As a part of that combination, the two health systems will be integrating technology and platforms, including our career sites.
This means that although you are applying on the Wake Forest Baptist Health Career Site, you receive communications from the Atrium Health Recruitment Team. Please know that this is an expected process, and thanks in advance for your flexibility.
About the Team
Mission, Vision and Culture Commitments
Mission
To improve health, elevate hope and advance healing - for all.
Vision
To be the first and best choice for care.
Culture Commitments
We create a space where all Belong
We Work as One to make great things happen
We earn Trust in all we do
We Innovate to better the now and create the future
We drive for Excellence - always