Director of Analytics & Engineering

Job Title: Director of Analytics & Engineering

General Hours of Work: Monday - Friday (primarily days with possible evening/weekend involvement) 

Exempt/Nonexempt: Exempt (salaried) 

Department/Unit: Corporate - Innovation 

Reports To: Vice President, Product Innovation 

SUMMARY: 

The Director of Analytics & Engineering will lead a team of analysts and engineers to develop and maintain Avel’s enterprise business intelligence platform and strategy. This role involves designing, architecting, developing, and testing enterprise BI applications, with a preference for MS Fabric and PowerBI experience. The Director will drive business intelligence strategy, partnering cross-functionally with business line, technical, operational, and executive leaders. This is a hands-on position, leveraging technical and coding expertise to support ETL and data modeling processes, write code and calculations to develop reports, and analyze large data sets for insights. The Director will serve as Avel’s thought-leader and expert in business intelligence, and lead, train, and develop the team. The Director will become a subject matter expert in key organizational data points driving decision-making and efficiencies 

ESSENTIAL FUNCTIONS: 

• Develops and maintains Avel’s business intelligence strategy and roadmap, articulating a vision for the organization, driving execution of the roadmap, anticipating new application functionalities, and meeting business needs 
• Is accountable for Avel’s data repository and lakehouse strategy, including guiding the selection of technologies, architecture, and processes. 
• Develops and supports high-value customer reporting, managing subscriptions to balance security and accessibility, requirements.  
• Leads the development of modern data-driven analysis, dashboards, and reports 
• Implements and oversees project intake and delivery cycles using Agile methodologies 
• Supervises, plans and assigns work to data analysts and engineers. Provides guidance, training and direction to staff to assist them in their professional development. 
• Partners effectively with executive leadership, operational business owners, IT, and other stakeholders.  
• Implements best practices around data modeling, environment design, workflows, and SDLC.  
• Designs, models, and builds out BI reports and dashboards, including writing code, DAX calculations, and optimizes the reports for users and subscription services. 
• Manages the Analytics lifecycle including but not limited to solution development, testing, acceptance, documentation, deployment, maintenance, periodic improvement and retirement. Communicates progress and work effectively across the business.  
• Implements and follows change management protocols. Documents data sources, transformations, and relevant business rules, ensuring work product documentation is organized, timely, complete, validate and stored according to protocols and best practices. 
• Assists in the development, execution and enforcement of data handling standards and data management best practices to comply with policies, SOPs and regulations. Ensures compliance with HIPAA, SOC 2 and other federal and state required data policies and best practices. 

ESSENTIAL QUALIFICATIONS:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

REQUIRED EDUCATION and/or EXPERIENCE:  

• Bachelor’s degree in a related technical discipline required. 
• Seven or more years of work experience in data analysis or related field required. 
• Experience driving an enterprise business intelligence strategy 
• Three years of demonstrated supervisory experience required.  
• Proven experience in developing BI applications, with preferred MS PowerBI experience  
• Advanced Excel capabilities  
• Experience with Microsoft Fabric a plus  
• Strong technical and coding expertise to support ETL and data modeling processes 
• Strong understanding of data architecture best practices 
• Proficient in writing T-SQL, PostgreSQL, PySpark/Python and other programming languages. 

REQUIRED COMPETENCIES:  

• Ethics and Values: Adheres to an appropriate (for the setting) and effective set of core values and beliefs during both good and bad times. 
• Customer Focus: Building strong customer relationships and delivering customer-centric solutions.    
• Action-Oriented: Taking on new opportunities and tough challenges with a sense of urgency, high energy and enthusiasm.    
• Decision Quality: Making good and timely decisions that keep the organization moving forward.   
• TQM/Re-engineering: Dedicated to providing the highest quality products and services which meet the needs and requirements of internal and external customers through commitment to continuous improvement; willing to re-engineer processes from scratch and is open to suggestions and experimentation.    
• Intellectual Horsepower: Intellectually sharp, capable, agile and deals with concepts and complexity comfortably.    
• Presentation Skills: Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences. 

REQUIRED PHYSICAL ABILITIES: 

• While performing the duties of this job, the employee is regularly required to talk or hear.   
• The employee frequently is required to sit.   
• The employee is occasionally required to stand; walk; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; and stoop, kneel, crouch, or crawl.   
• The employee must occasionally lift and/or move up to 10 pounds.   
• Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and the ability to adjust focus. 

REQUIRED COMMUNICATION/MATHEMATICAL/REASONING SKILLS:  

• Must possess the required level of skills and abilities to read, write, speak, and apply mathematical concepts and sound reasoning to successfully perform the essential duties and responsibilities of this job. 
• Must be able to perform basic operations on a personal computer within the Windows operating system.  
• This position requires problem solving skills, critical thinking skills, and the ability to multi-task. 

RESPONSIBILITIES, EXPECTATIONS & STANDARDS: 

• Commitment to the daily application of Avel’s mission, vision and core values to deliver access to high quality care. 
• Maintain confidentiality. 
• Work effectively in a team environment, coordinating workflow with other team members and ensuring a productive and efficient environment. 
• Comply with safety principles, Federal and State laws, regulations and standards including but not limited to the Joint Commission. 
• May be involved on organization committees or boards. 

WORK ENVIRONMENT:   

• May be exposed to communicable diseases when working in a health care environment. 
• The noise level in the work environment is usually moderate.