Job Summary:

In accordance with the Mission, Vision and Values, and strategic directions of PHSA safety, including both patient and employee safety, is a priority and a responsibility shared by everyone at PHSA’s Agencies/Divisions/Services, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.  

The Lead, Business Intelligence (BI) and Data & Data reports to the Manager, Supply Chain Performance, develops and maintains various complex data solutions, tools, and automations which impact several functional areas throughout PHSA. The Lead is responsible for leading the service quality and delivery of the portfolios in reports or dashboards building, data analytics, data ETL (extraction, transform, load) pipelines development, and no-code / low-code application development with GUI (Graphical User Interface) to gather business data.

The Lead designs, builds, and implements data system and infrastructure to support machine learning and data analytics. The Lead works with internal and external stakeholders to translate business requirements into technical specification, and is responsible for implementing software or infrastructure upgrades, developing strategies for data security, and ensuring compliance with pertinent PHSA IT security and privacy policies. The Lead supervises a team and works primarily with Microsoft solutions such as SQL Server, SSRS, Power BI, SSAS, SSIS, TSQL, DAX, C#, Python, Power Platform, Azure Functions, and multiple Azure data-related services in the cloud, and manages and supports the servers and infrastructure used as the hosting environment.

Duties/Accountabilities:

1. Provides work direction, guidance, mentoring and coaching of the technical team; determining work priorities, assigning tasks and reviewing workload; resolving day-to-day issues and monitoring completed work to ensure conformance with established standards; and determining related training requirements and referring unresolved operational and staffing challenges to the management.
2. Designs, develops, and maintains reports and complex analytical solutions by gathering business requirements, translating requirements into technical specifications and logical data model, developing corresponding database, troubleshooting errors, and deploying solutions. Writes ad-hoc queries and reports to support staff and leaders in data analysis, when required.
3. Resolves data-related technical challenges and performs root-cause analysis to answer specific business questions by tracing data transformation through different stages in the automated data pipeline, troubleshooting  programming errors, investigating the impact of business process / application configuration changes to the data automation, researching industry best practices for design and programming, developing programming solutions to fix problems, and working with IMITS and external vendors to deploy application patches.  
4. Designs, develops and supports the Master Data Management (MDM) solutions, to map the business dictionary data across multiple ERP systems and other data sources, such as GS1 GDSN data or the medical device data from US FDA. Utilizes advanced algorithms, programming solutions, or commercial-off-the-shelf (COTS) solutions to control the quality of the master data, such as performing dedupe or working with the business to implement data quality rules.
5. Designs, develops, and supports the automated data ETL (extraction, transform and load) processes by automating data gathering from on-premise applications or cloud sources on the internet, troubleshooting programming errors, developing and deploying solutions to fix errors. Develops programming scripts to automatically monitor ETL environment security.
6. Develops technical requirement and implementation plan, coordinates with stakeholders to execute technical implementation plan, and escalates to project sponsor(s) when required.  
7. Develops no-code / low-code applications with GUI (Graphical User Interface) to gather business data, troubleshoots application programming errors, and develops / deploys solutions to fix errors.
8. Writes programming codes to develop data pipelines using data engineering or data science techniques, and transforms data by utilizing machine learning or Artificial Intelligence algorithms. Automates processes to cleanse and enhance business data to bring out insights or data patterns. Facilitates or automates business decision making with the enhanced data. Designs, builds, and implements data system and infrastructure to support the machine learning and AI analytics.
9. Sustains application access and security, performs system inspections, develops automated scripts for application / database functional testing or unit testing, recommends improvements to ensure effectiveness of programming development processes or system performance.
10. Drafts standard procedures, writes comprehensive system and operating documents, prepares system documents for review and approval and develops backup/recovery.
11. Provides training on applications and reporting, coaches and supports staff by hosting presentations, or writing users manuals.
12. Performs other related duties as assigned.
    
    

Qualifications:

Education, Training and Experience

• Graduation from a recognized degree or diploma program in Computer Science, four (4) years of recent related experience or an equivalent combination of education, training and experience.

Skills and Abilities

• Ability to communicate effectively both verbally and in writing.
• Ability to deal with others effectively.
• Physical ability to carry out the duties of the position.
• Ability to write programs in a variety of program languages
• Ability to organize work.
• Ability to operate related equipment.