**Location:** Avera Downtown Building-Sioux Falls **Worker Type:** Regular **Work Shift:** Day Shift (United States of America) **Pay Range:** _The pay range for this position is listed below. Actual pay rate dependent upon experience._ $70,720.00 - $106,600.00 **Position Highlights** **You Belong at Avera** **Be part of a multidisciplinary team built with compassion and the goal of Moving Health Forward for you and our patients. Work where you matter.** **A Brief Overview** Provides strategic and tactical decision support to stakeholders at all levels of Avera Health. In collaboration with Lead and Senior Enterprise Data Engineers, the Enterprise Data Engineer uses knowledge of EMR workflows and other third-party software to develop informational models and reports/presentations of critical corporate, financial, and clinical information. **What you will do** + Design and develop information models, schemas, code patterns, frameworks, algorithms, UI conventions for financial, clinical, and organizational data warehousing, particularly involving EMR systems, processes, and workflows. + Develop the business and clinical intelligence architectures to enable fact-based decision making while supporting ad-hoc analysis and insight generation. + Perform detailed analysis of high-level requirements and document design specifications. + Develop and implement designs in collaboration with other team members within and outside of the Avera IT community. + Design and develop OLAP and OLTP systems and data warehouses. + Design and Support data ETL subsets of the Avera Data Repository for operational Business and Clinical Intelligence teams. + Competently employ the analytics/data visualization platform standards at Avera (Visual Insight, Tableau, Power BI), as well as Microsoft tools and IDEs (SSRS, SSMS, Visual Studio, Excel)Becomes and remains knowledgeable concerning data integration standards (i.e., HL7)Assists with integration engine product installation and configuration (Summit). + Performs data analysis/mapping/normalization and related interface project planning, design, development, documentation, testing, implementation, and go-live execution. + Works with management in determining the strategic goals of Avera Information Technology and the Enterprise Data Analysis Team from a data analysis, reporting, and decision support perspective. + Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. **Essential Qualifications** The individual must be able to work the hours specified. To perform this job successfully, an individual must be able to perform each essential job function satisfactorily including having visual acuity adequate to perform position duties and the ability to communicate effectively with others, hear, understand and distinguish speech and other sounds. These requirements and those listed above are representative of the knowledge, skills, and abilities required to perform the essential job functions. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions, as long as the accommodations do not cause undue hardship to the employer. **Preferred Education, License/Certification, or Work Experience:** + Bachelor's in a computing, design or clinical discipline. + Experience compiling reports and presentations in multiple media and formats. + Experience executing complex work streams, work packages and deliverables. + Basic knowledge of Analytics/Data Visualization Platforms (Visual Insight, Tableau, Power BI), Office Suite and other Microsoft Tools/IDEs (SSRS, SSMS, Visual Studio, Excel). + Basic understanding of Relational Database Management Systems (RDBMS) & the concepts of data management/wrangling and at least one database product (such as Microsoft SQL Server) + General technical knowledge of computer hardware, software, and networks along with precise knowledge of specific data elements involved in systems integration, data analysis/mapping experience in normalizing disparate data sets. **Expectations and Standards** + Commitment to the daily application of Avera’s mission, vision, core values, and social principles to serve patients, their families, and our community. + Promote Avera’s values of compassion, hospitality, and stewardship. + Uphold Avera’s standards of Communication, Attitude, Responsiveness, and Engagement (CARE) with enthusiasm and sincerity. + Maintain confidentiality. + Work effectively in a team environment, coordinating work flow with other team members and ensuring a productive and efficient environment. + Comply with safety principles, laws, regulations, and standards associated with, but not limited to, CMS, The Joint Commission, DHHS, and OSHA if applicable. **Benefits You Need & Then Some** Avera is proud to offer a wide range of benefits to qualifying part-time and full-time employees. We support you with opportunities to help live balanced, healthy lives. Benefits are designed to meet needs of today and into the future. + PTO front-loaded for eligible hires + Free health insurance options, for full-time single coverage on Avera High Deductible Health Plan + Up to 5% employer matching contribution for retirement + Career development guided by hands-on training and mentorship _Applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status. If you are an individual with a disability and would like to request an accommodation for help with your online application, please call 1-605-504-4444 or send an email to_ _talent@avera.org_ _._ At Avera, the way you are treated as an employee translates into the compassionate care you deliver to patients and team members. Because we consider health care a ministry, you can live out your faith, uphold the dignity and respect of all persons while not compromising high-quality services. Join us in making a positive impact on moving health forward. The policy of Avera to provide opportunities for all qualified employees or applicants without regard to disability and to provide reasonable accommodations for all employees or applicants who may be disabled. Avera is committed to ensuring compliance in accordance with the Americans with Disability Act. For assistance, please contact HR Now at 605-504-4444. Additional Notices: For TTY, dial 711 Avera is an Equal Opportunity/Affirmative Action Employer: Minority/Female/Disabled/Veteran/Sexual Orientation/Gender Identity.