Scope:
The Common Cluster Solutions Branch focuses on services that support both ministries and all branches within the cluster. CCS also provides business intelligence, data analysis and other KPI reporting on important areas of business operations to our partners and the cluster. These services include Business Intelligence (BI), which consists of performance reporting, analytics and consulting services, and includes offering self-service tools to enable and empower our business partners to make informed decisions for their day-to-day business operations.


The resource would be engaged on a number of discrete projects that have been approved by ministry program areas as key priorities, including:
1. SOLGEN Inspectorate of Policing
2. Other SOLGEN Program areas as required
In addition, other Microsoft Power BI work is ongoing within the Branch and resources may be required to assist in other Power BI development work involved in the unit.


Experience and Skill Set Requirements
Deliverables:
Design and implement business intelligence data solutions (pipelines, ETLs/ELTs, data warehouse, data lake, data lakehouse)
Undertake special assignments/sub-projects as assigned.
Assess, evaluate, and document stakeholder interests.  
Conduct business requirement sessions and document options and outcomes.
Prepare and document data analysis findings and data dictionaries.
Participate in problem analysis and identify opportunities where business intelligence and advanced analytics can be used to support project and/or program objectives.
Serve as a data analytics subject matter expert on inter-disciplinary project teams and/or as an ad-hoc advisor to deliver data analytics expertise and advice.
Conduct periodic reviews of developed analytical solutions to identify opportunities for enhancements or evolution.
Research, prepare and document issues related to data collection and reporting requirements.
Plan, prepare and deliver demo and training sessions on new Business Intelligence dashboards and reports to all levels of user community.
Ensure alignment and adherence to IT processes and standards.
Participate in development and UAT testing and document results.
Participate in Knowledge transfer.

Skills and Knowledge:
Proven experience as a Data Engineer/ETL Developer in building Business Intelligence products
Proven experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop pipelines & Business Intelligence products
Demonstrated experience with Azure Data Factory, Databricks, Power BI, SQL Query and/or other data query tools
Demonstrated knowledge and experience of Microsoft Azure ecosystem
Proven, demonstratable experience in data visualization; working with BI implementation methodologies
Knowledge of data analysis, data management
Proven ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues
Excellent verbal and written communication skills, interpersonal and facilitation skills  
Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology
Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment
Mandatory Requirements: At least 5 years of experience
All roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS.
Security Clearance process, levels, roles etc. are subject to change without prior notice. Candidates may be required to undergo revised/new process (or levels) any time prior or during the term of the contract.

Criteria Ratings MUST TOTAL 100
Criteria 1: Technical Skills - 60 Points
Experience as a Data Engineer/ETL Developer in building Business Intelligence products
Data Interpretation and Insight Generation: Strong ability to interpret data, identify trends and patterns, and generate meaningful insights that support business decision-making.
Experience with Data Mining Techniques: Proficiency in data mining techniques and methodologies, including clustering, classification, regression, and association rules, to extract valuable information from large datasets.
Experience in Data Warehousing: Understanding of data warehousing concepts and experience in working with data warehouse technologies.
Knowledge of Data Integration Techniques: Skills in integrating data from various sources and formats for comprehensive analysis.
Proficiency in Data Analytics Tools: Expertise in using data analytics tools such as Python (Pandas, NumPy, SciPy), R, or SAS for complex data manipulation and analysis.

Criteria 2: Documentation, Collaboration & Communication Skills - 40 Points
Documentation, Collaboration & Communication Skills
Clarity in Complex Business Challenges: Ability to bring clarity to complex business issues and articulate business process requirements versus technology solutions effectively.
Excellent Verbal and Written Communication: Demonstrated excellence in both verbal and written communication, including the ability to convey complex data concepts in understandable terms.
Interpersonal and Facilitation Skills: Strong interpersonal skills, with an ability to facilitate discussions and consensus among diverse groups.
Effective Documentation Skills: Proficiency in creating clear and detailed documentation, including reports, guides, and process maps.
Collaboration with Internal/External Stakeholders: Demonstrated ability to effectively partner with both internal and external stakeholders, fostering productive relationships.
Teamwork and Cross-Functional Collaboration: Experience in working collaboratively in cross-functional teams, contributing to a cohesive team environment.
Presentation Skills: Strong presentation skills, capable of delivering insights and findings to both technical and non-technical audiences.
Conflict Resolution and Negotiation Skills: Ability to resolve conflicts and negotiate effectively, maintaining a focus on business objectives.
Time Management and Organizational Skills: Demonstrated effective time management skills, with the ability to prioritize tasks and meet deadlines in a dynamic environment.
Adaptability and Flexibility: Ability to adapt to changing business needs and technology landscapes, maintaining effectiveness in varying environments.
Stakeholder Management: Experience in managing stakeholder expectations and maintaining open lines of communication throughout project lifecycles.
Critical Thinking and Problem-Solving: Strong critical thinking skills, with an ability to analyze problems, identify root causes, and develop innovative solutions.