Reporting to the Team Lead, Enterprise Data Science and Analytics, the Sr. Enterprise Data Specialist will contribute to evolving a data culture within Bayshore Healthcare through the ongoing initiatives to develop and evolve analytic products within our core analytic suite, Power Insights. They will gain a solid understanding of Bayshore business practices, and the data applications that support these practices, while working in collaboration with other members of the Enterprise Data team, and business resources, to define the organization’s analytic needs, and then build the analytic solutions that will meet those needs.  In this capacity, the Sr. Enterprise Data Specialist will be accountable for analyzing data within source system databases, writing code to extract and transform the data as needed, then guide the Enterprise Architecture and Engineering team in building and testing the dimensional tables and views needed. They will then use these tables and views to create Data Fabric Semantic Models (Datasets) and develop the Power BI reports and dashboards (data visualizations) needed to best fulfill the analytic needs of the business. In addition, the Sr. Enterprise Data Specialist will act as an Enterprise Data “ambassador” providing guidance, education, and support to others within the organization in the areas of analytic queries, education on analytic tools, and selection of data visualizations that represent information in the most effective manner.  For the near future, the Sr. Enterprise Data Specialist will be engaged almost exclusively on a special “provincial phase based” project to migrate the Home Care Solutions data to a new source system and will be responsible for working with multiple teams to establish new reporting and analytics based on the new source system and help to transition to these reports as branches are brought online.  This project will require travel to branches across Canada depending on which province is being migrated.

Key Responsibilities 

• Work with the Business and Support units within Bayshore to define the requirements for key operational reporting metrics and analytic use cases
  
• Collect, document, profile, and analyze requirements to support the creation of data definitions, business transformation logic, and source to target mapping specifications  
• Collaborate with other Enterprise Data team members, including Data Science & Analytics, Data Engineering, and Product Management to design, plan, develop, and deliver data products that best support the organization’s analytic requirements  Design, develop, test, and deploy enterprise-level and division-specific reports, dashboards, and other data products in accordance with defined test scenarios 
• Develop detailed data queries to extract data from primary or secondary data sources and build the data stories needed 
  
• Use statistical tools to interpret data sets and work closely with Data Science & Analytics Team Lead and other Data Analysts to build descriptive, prescriptive, diagnostic, and predictive data analytics and models  
• Conduct in-depth data analyses, data wrangling, cleaning, and preprocessing to ensure data accuracy, reliability, and quality  
• Identify and escalate data and content integrity issues on a timely basis to the Data Management team, and assist in defining Data Quality “campaigns” to address these issues   
• Assist with the development and maintenance of data catalog and business glossary to enable ongoing data quality monitoring to ensure consistency in data definitions and build trust in the data across the organization  
• Participate in agile ceremonies, with a strong ability to review BRDs and provide concise work breakdown structure and work effort to contribute to monthly release planning 
• Adhere to Bayshore Policies and Procedures and maintain confidentiality of client and corporate information  
• Complies with all Canadian provincial and federal privacy legislation 
• All other duties as required