Our valued Public Sector client requires a Senior Database Modeler to support the data repository and reporting development for a Network Support modernization project .
The Database Modeler / Information Management Modeler has both strategic and tactical responsibility for analyzing, designing and developing the Architecture and Data Models for a DataMart and Network predictive analytics reports, utilizing Microsoft SQL Server, Azure Synapse, Power BI and related data manipulation technologies for corporate and project specific initiatives.
This responsibility includes the identification of data most valuable to the department, the integration of this data with cleansing / transformation options (Data sources may include Excel, flat file, CSV, SharePoint, API etc), and the development of core relating data models.
The resulting solutions will be based on data architecture and modeling design principles and tenets
Must haves :
- Experience designing, developing and maintaining Logical Data Models
- Relevant Certifications such as : Oracle DBA certified Professional, IBM Certified DBA, or Oracle Database SQL certified Associate Certification
- Canadian degree / diploma related to computer science, IT or engineering
- Valid Enhanced reliability clearance
Tasks :
- Analyze proposed changes to databases from the context of the Logical Data Model
- Provide technical expertise in the use and optimization of data modeling techniques to team members
- Provide technical assistance, guidance, and direction in terms of data analysis and modeling to team members
- Provide assistance to the project team and business users relating to data issues and data analysis concepts
- Participate in the development of data modeling and metadata policies and procedures.
- Determine and document the data and business requirements. Participate in data analysis as a result of new / updated requirements
- Apply approved changes to logical data models
- Comply with corporate data architectures, strategies, and frameworks, including enterprise data warehouse activities
- Analyze and evaluate alternative data architecture solutions to meet business problems / requirements to be incorporated into the corporate data architecture.
- Review corporate architecture strategies and directions, data requirements, and business information needs and devise data structures to support them
- Improve modeling efficiency through recommendations on how to better utilize current metadata repositories
- Comply with corporate repository metadata directions
- Provide input to refinement of data architectures
- Participate in data architecture refinement
- Define access strategies
- Construct, monitor and report on work plans and schedules
- Document lessons learned and conduct knowledge transfer and coaching of the team members
Part Time Intervenor to Support People Who Are Deafblind
The Intervenor supports communication and day-to-day living for individuals who are living with dual sensory impairment so that they may live independently. The Intervenor supports communication and day-to-day living for individuals who are living with dual sensory impairment so that they may live i...
Sports Medicine Physician for Toronto Rock Sports Medicine & Wellness Centre in Oakville, ONThe Toronto Rock Sports Medicine & Wellness Centre, a newly established state-of-the-art clinic located within the Toronto Rock Athletic Centre (TRAC) in Oakville. The TRAC is the official training facility of the Toronto Rock Lacrosse professional sports team and home to numerous youth and adult sports programs.View details
Qualified Candidates are invited to submit a cover letter and curriculum vitae via email to the Toronto Rock Sports Medicine & Wellness Centre: sportsmed@torontorock. The TRAC is the official training facility of the Toronto Rock Lacrosse professional sports team and home to numerous youth and adult...
Senior Business Transformation Architect to support software solution modernization.
The client's IM/IT sector is working in close partnership with the supervision sector to advance its transformation agenda in order to modernize its business operations and service delivery mode, with a goal of transitioning to risk-based supervision. Standards and Best Practices Documentation: Busi...
Japanese, Tamazight, Khmer Language Instructors for the International & Indigenous Languages Program (JK to Grade 8)
Ideal candidates will support the fulfillment of the Ottawa-Carleton District School Board’s (OCDSB) Strategic Plan to enhance the quality of education in the school, and the District, by creating a positive and inclusive school climate, learning and workplace environment. The Ottawa-Carleton Distri...
Sr uPerform Courseware administrator to assist and provide solutions for potential uPerform issues within a high performance, established SAP team
Senior uPerform Courseware administrator to assist and provide solutions for potential uPerform issues. Communicate effectively by visual, oral, and written form with individuals, small group, and in front of large audiences in classroom and using distance learning tools;. Provide timely and complet...
IT Manager, PMO–Learning & Performance Support
Coordinating and managing all stages of instructional design, development, and delivery, including learning needs analysis, strategy development, curriculum and learning path design, content development, approvals workflows, translation, delivery support, KPI reporting, end-user performance support,...
Netcracker Configuration and Support Specialist
Job Title:</b> Netcracker Configuration and Implementation Specialist</p> <p><b>Location:</b> Ottawa, ON</p> <p><b>Job Overview:</b> The Netcracker Configuration and Implementation Specialist will play a key role in the configuration, support,...
Care Coordinator - Multiple Eastern Ontario Locations
The Care Coordinator, through in person visits, assesses the patient’s care needs and develops, implements, and updates (as required) a care plan that is informed by the patient’s health and psychosocial needs; and, where possible, accommodates patient and caregiver wishes. As a member of the Commun...
Consultant/Senior Consultant, Oracle - Supply Chain & Procurement Functional Support
Collaborate closely with the KPMG Functional Leads to support project tasks and deliverables, encompassing planning, budgeting, performance tracking, gap analyses, progress reporting, and risk and resource management. Strong understanding of SCM and Procurement processes, policies, regulations, and ...
Sr Salesforce Support Engineer
Actual compensation offered will be dependent upon the individual's skills, experience, and qualifications as they directly relate to the requirements of the position, the budget for the position, and applicable employment laws. More than 200,000 organizations worldwide trust Barracuda to protect th...