Job Description:
Responsibilities:

• Lead the development and delivery of functional and ministry-specific analytics to support evidence-based decision-making and produce actionable insights.
• Work closely with client groups to assess current data analytics and reporting capabilities, gather future-state requirements and identify further opportunities for improvement.
• Facilitate decision-making and manage client expectations.
• Own the execution of analytics initiatives including end-to-end reporting and data set delivery.
• Participate in documentation, development, testing
• Work with functional area experts, Data Architects and ETL Developers and stakeholders to understand complex business issues and develop appropriate Business Intelligence solutions.
• Design methods to capture, structure, transform and process data to be used to generate models.
• Build data models that provide information which is accurate, easy to understand and unbiased.
• Communicate complex quantitative analysis in a clear and precise manner, providing useful visuals and summaries.
• Provide interpretation, advice, and expertise to client groups and other stakeholders, including direction on how to transform analytics into actionable information and proactive insights that support decision making.

General Skills:

• Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and teamwork skills
• Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
• Adept at communicating to both technical and non-technical audiences
• Experience with a range of analytical methods, techniques and tools such as, but not limited to: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
• Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
• Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
• Experience designing high quality interfaces to present information in a meaningful way to end users
• Broad understanding of data management, financial and business analysis, database architecture, and information visualization
• Proficiency in query languages, experience constructing complex query statements and mathematics and statistics
• Experience in one or more programming or scripting languages
• Strong investigative and logic skills.
• Awareness of emerging Business Intelligence trends and directions
• Experience with analytical software such as R,
• Proficiency with desktop analysis software including Microsoft Excel, Access, VBA, Power BI

Database Administrator Involves:

• Assisting with the transformation/cleaning of data from a legacy database into a new data warehouse
• Determine appropriate data structure for remaining relevant legacy data
• Develop mapping and transformation rules to align the two databases
• Create data dictionary for new data
• Develop connections with multiple other government databases and develop system to maintain the connection so that it does not go out of date
• Supporting Power BI visualization and report building
• Develop and test any automated data validation tools deemed necessary

Experience and Skill Set Requirements:
Database Skills - 70%:

• Experience with one or more database technologies, designing data architecture for new databases and dimensional data models
• Proficiency with SQL and experience writing SQL scripts
• Experience in monitoring and enforcing database rules, cleaning, transforming and joining data, creating and applying data standards
• Subject matter expert in database design of data warehouse or data marts.

Communication Skills - 25%:

• Experience in developing documentation on data standardization and requirements
• Demonstrated consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance.
• Demonstrated team player with a track record for meeting deadlines and strong verbal and written communication skills; with both technical and non-technical audiences.

Government Experience - 5%:

• Previous public sector experience in an organization of equivalent size and complexity to the Government.