Address
Form of work
SalaryWe are in search of a seasoned professional to provide technical expertise in the design and implementation of complex projects as well as re-engineering of legacy (on-premise) technical solutions as to facilitate cloud migration.
If this sounds like your next career move, then consider this exciting opportunity with us.
OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism:
We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals, as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.
Visit the OPS Anti-Racism Policy and the OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.
We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the "How to apply" section if you require a disability-related accommodation.
What can I expect to do in this role?
You will:• Provide senior technical expertise in building data collection and processing pipelines for downstream consumption for Business Intelligence (BI) and analytics.
• Lead the design and implementation of logical and physical data models suitable for consumption by BI tools.
• Lead and participate in the migration of legacy on-premise legacy BI applications and data stores to modern cloud platforms
• Translate corporate information requirements into detailed system/programming specifications.
• Perform system acceptance testing and draft system documentation.
• Develop End User Application (EUA) demos and proto-types to support design process.
• Consult with users to determine their user requirements.
How do I qualify?
TECHNICAL KNOWLEDGE:
• Knowledge of the principles/techniques of large-scale Business Intelligence (BI) and data warehouse / database design, data modelling and information management concepts.• Practical hands-on experience in design and development of BI solutions (using technologies such as IBM Cognos Analytics or Power BI) including advanced reporting and data visualizations
• Familiarity with the process of building a BI solutions, including data warehouse/mart design, data extraction, transformation and loading (ETL).
• Knowledge and experience using relational database systems such as Oracle (including advanced SQL and PL/SQL or equivalent).
• Experience or knowledge with cloud infrastructure and services (AWS, Microsoft Azure) as well as data warehousing solutions for cloud (AWS Redshift, Azure Synapse).
• Experience in all life cycle stages of a BI solution (requirements gathering, design, development, implementation, and maintenance).
• Understanding of Enterprise Architecture principles, techniques, methodologies and various architecture domains.
• Some experience in Unix/Windows/Python scripting, and other development tools.
SYSTEMS ANALYSIS AND TECHNOLOGY PLANNING EXPERIENCE:
• Experience analyzing, designing, developing, testing, implementing, supporting, and demonstrating business applications (for Business Intelligence and data analytics).• Experience building and managing data sets by analyzing data contained in the corporate database, legacy systems and other data sources.
ANALYTICAL SKILLS AND INTERPRETATIVE REASONING SKILLS:
• Proven analytical and interpretative reasoning skills to assess client I&IT needs and develop I&IT solutions that are cost effective and improve client program and service delivery.• Ability to determine all appropriate technical requirements, resources and cost estimates for developing, testing and implementing client application and recommend the improvements.
PROJECT MANAGEMENT SKILLS:
• Demonstrated project planning methodologies to plan and coordinate technical activities, plans and schedules of project teams.COMMUNICATION AND INTERPERSONAL SKILLS:
• Demonstrated interpersonal, conflict resolution, team building and client relationship management skills to discuss program requirements.• Oral and written communication skills to provide information with respect to technical and operational application policies, procedures and standards.
