Position Summary / Career Interest:

Data Analytics Engineer will help architect analytical frameworks and promote self-service offerings in the business intelligence space for technical content developers and other stakeholders in the health system. This role supports continuous improvement and technology development by leveraging available and emerging data sets from our business enterprise, processes, and machinery that enable improved content delivery to our customers. Data Analytics Engineers will work closely with various teams within the health system that support content development processes to design, build, troubleshoot, and improve our data pipeline and data models, with a focus on constructing scalable and performant infrastructure for analytical use. Further, the Data Analytics Engineer will be responsible for pioneering new methodologies, defining and improving performance metrics and evaluation, and will generally lead innovation efforts on the Data Analytics Engineering team. Successful candidates should have strong interpersonal skills and be comfortable operating in a dynamic environment. You will need advanced SQL skills to transform data from multiple sources; and strong communications skills to clearly document and explain the final data model. There is a significant amount of analytical data infrastructure to build for a growing team, so you will need to balance priorities, meet deadlines and make sure you are investing enough time to make data models sustainable and easy to repurpose in the future. Lastly, the Data Analytics Engineer should have an entrepreneurial spirit, always asking "how can we do this better", to drive outcomes for patients as well as for the Health System as a whole.


Responsibilities and Essential Job Functions

• Leadership • Organize data in a meaningful way and provide additional context as necessary so that it is ready for analysis by technical content developers and other key stakeholders in the health system that promotes self-service. • Lead the design, development, and maintenance of innovative and scalable business intelligence solutions across the organization, with the highest standards of analytical rigor and data integrity. • Collaborate with Data Management team to Knowledge Management teams build and maintain complex databases with processes that data cleansing takes place further upstream. • Lead Change Advisory Board activities to maintain and introduce change to data models and content produced by team members. • Provide guidance to Change Advisory Board team regarding change management practices and principals to analytical content. • Lead processes that define and improve internal standards for style, maintainability, and best practices for a high-scale data infrastructure. • Lead large scale analytical initiatives with notable risk and complexity to define scope, develop strategy for execution, manage timelines, and coordinate activities with other involved team members. • Lead deployment, and integration of predictive models and artificial intelligence into development and production environments with BI Statisticians and Data Scientists in the EMR and non-EMR environments. • Conduct code reviews to provide guidance on engineering best practices and compliance with development procedures. • Contribute to a culture of innovation, collaboration, and continuous improvement.
• Essential Skills • Write clean, maintainable, and well-documented code with focus on software engineering reliability standards embedded in development standards to support data processes. • Apply coding & engineering best practices (ex. SQL formatting, version control, code review) to data team workflows, and continue to develop & promote best practices among content developers across teams that consider scalability, reliability and performance of systems/contexts affected when defining technical designs. • Assist with maintenance of operational life cycle support for Caboodle and internal EDW including upgrades, patch releases, and automation of manual processes. • Create integrated views of data collected from multiple sources in the EMR and non-EMR environment. • Analyze query performance and perform query tuning to assist content developers in designing and optimizing queries. • Analyze data compiled by the Data Management team and perform data cleansing that complies with data hygiene best practices. • Consistently create optimal design adhering to architectural best practices; consider scalability, reliability and performance of systems/contexts affected when defining technical designs.
• Connect The Dots • Design, transform, and implement data models (EPIC, Caboodle, Star Schema, Predictive, etc.) that support flexible querying, data analysis and visualization of content, ensuring all aspects of product development follow compliance and security best practices. • Track industry trends and emerging technology changes and work with IT & Platform teams to ensure these are understood, evaluated, and enabled as necessary (including leading of implementation and training). • Review tasks critically and ensure they are appropriately prioritized and sized for incremental delivery. • Anticipate and communicate request and project roadblocks and delays before they require escalation. • Communicate with stakeholders of varying seniority across the company, including senior executives, to demonstrate value of the data infrastructure projects, serving as a technical thought partner and leader.
• Innovation and Process Improvement • Discover opportunities for an organization to improve its systems and processes through the use of data analytics. • Ability to recommend Data Management process, governance, organizational and platform models, tool selections and application integration options to clients. • Comply with all policies and standards.
• Must be able to perform the professional, clinical and or technical competencies of the assigned unit or department.
• These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.

Required Education and Experience

• Bachelors Degree Computer Science, Bioinformatics, Mathematics, Engineering, or related field (or equivalent years in experience)
• 7 or more years experience developing applications with one or more business intelligence tools such as Power BI, Qlik, SlicerDicer, SAP Business Objects, Tableau, etc.
• 7 or more years SQL experience in a relational database or an equivalent combination of education and experience
• 5 or more years experience using data mining/analytical methods and associated tools such as Python, R, etc.
• 1 or more years experience successfully implementing analytical and business intelligence solutions and/or processes at the enterprise level

Preferred Education and Experience

• Master's Degree in Engineering, Healthcare Administration, Data Analytics, or another related field
• Experience with cloud service such as Azure Cloud, Synapse, Data Factory, Azure SQL
• Experience in healthcare environment
• Experience with building ETL Pipelines
• Experience working with Caboodle
• Experience with financial modeling, machine learning / AI models, and/or statistics

Required Licensure and Certification

• Epic certification in 4 data model(s). If not certified, certification is required within 1 Year

Preferred Licensure and Certification

• Project management, Lean, Six Sigma, Agile certification
• MS Certifications: Azure Data Fundamentals, Power BI Data Analyst Associate, Azure Enterprise Data Analyst Associate, MCSA: BI Reporting, MCSA: SQL 2016 BI Development, Azure Data Engineer Associate, Azure Developer Associate, Customer Data Platform Specialty, Power Platform App Maker Associate

We are an equal employment opportunity employer without regard to a person’s race, color, religion, sex (including pregnancy, gender identity and sexual orientation), national origin, ancestry, age (40 or older), disability, veteran status or genetic information.