Sr Database Modeler to support the data repository and reporting development for a Network Support modernization project
3 days ago
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
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur 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 has both strategic and tactical responsibility for developing and maintaining the Architecture and Data Models for corporate and project specific initiatives. This...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Database Modeller / IM Modeller to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Design, develop and maintain Logical Data Models. b. Analyze proposed changes to databases from the context of the Logical...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Database Administrator to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Develop, customize and implement data conversion procedures which extract, transform and load data from source systems to a data...
-
Senior Software
3 days ago
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client is looking for a Senior Software (.NET) Developer to support the maintenance and development of a centralized data repository and analysis system. Our client currently is currently working on one of the largest projects within their department focusing on their Internal information management system and strategic initiatives for...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector Client is looking for a Senior Secret Cleared Project Manager to support the Network/Email Modernization to support multiple departments and agencies within the Public Sector The Project Management and Delivery Branch (PM&D) is responsible for providing various Departments and Agencies with a bundle of the client's network,...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client is looking for a Senior Data Engineer to develop data connections and processes for data models within an existing data infrastructure Our client is modernizing its IM/IT environment to support digital operations and enable technology excellence in service to Canadians. There is a requirement to support and evolve the Data and...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued client is looking for a Sr. Data Analyst to support the decommissioning of mainframe systems.Tasks include:Use new and existing applications to create a future state that does not rely on mainframe application(s) to support the underwriting, risk management and account receivable processesCarry out data analysis activities by evaluating current...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Intermediate MS Dynamics Developer to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilites: a. Translate functional and business requirements into technical requirements and design specifications. b. Participate in...
-
Sr. Information
1 month ago
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued private sector client requires a Sr. Information & Knowledge Management Specialist to support the discovery, creation, and dissemination of knowledge in the organization. Responsibilities: Provide experience and expertise in Information Management and Decision Support in a R&D environment in the following S&T topics: Knowledge Representation -...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior MS Dynamics Developer to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Lead a team of Programmer Analysts and provide guidance, advice and assign tasks. b. Translate functional and business requirements...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued private sector client requires a Sr. Cognitive Engineering Specialist to conduct research in areas such as cognitive modeling, training and decision-aiding for complex systems, human behavior simulation, intelligent-agent technologies, and eye-voice interfaces. Responsibilities: Develop, administer, and analyse questionnaires and interviewing...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public-sector client is currently searching for an Intermediate Business Analyst to support defining current state and target end state business process using SPARX Enterprise Architecture as part of a major, ongoing Application Rationalization Initiative. Tasks: Defines current state and target end state business processes and conduct business...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Application/Software Architect to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilities: a. Perform application integration, maintenance, upgrades, and migration. b. Run diagnostic tests and perform debugging...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued client is looking for a Sr. Scrum Master to continuously promote and support the team's use of Agile and Scrum in a data management environmentTasks include:Develop a new and innovative solution for aggregating and displaying company informationEnsure compliance and continuous improvement of Agile events and project/program management...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client requires the services of a Sr Business Analyst to create dashboards and process flows for IT security team. Tasks:Develop, review and document business requirementsPlan, coordinate, capture and follow up on meetings with partner departments and agencies for business requirements gathering along with their prioritization,...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector Client requires a Senior Secret Cleared Project Manager to provide support on multiple on-going large-scale Cyber Security and Cloud Transformation initiatives within the Public Sector The resource will be working on all aspects of the business required to deliver on the client's Cyber Security and Cloud Operations mandate for...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued public sector client is looking for a Sr Business Analyst (Secret cleared) to support an App Dev project on an Agile environment.The successful candidate will play a crucial role in the LaunchARP (Air Readiness and Performance) project by analyzing client requirements and developing user stories that accurately capture these requirements. This...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur valued Public Sector Client is looking for a Senior Project Manager to support the Workplace Collaboration Services (WCS) Project. Scope: Development, procurement, and transition to an enterprise Workplace Communication Service providing: The WCS IP Telephony solution was developed as a planned replacement for the SSC Partner departments’ telephone...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires a Senior Java Developer to support the implementation of several incident management response initiatives. Responsibilities:Write software in a Linux and MS Windows development environmentPerform programming in Java, Python and JavaScript (React) to develop and transition new or extend existing modulesPerform UX design...
-
Ottawa, Ontario, H2B, Montréal, Canada S.i. Systems Full timeOur public sector client requires an Enhanced Reliability Cleared Senior Business Analyst to support the modernization projects as well as the maintenance of its legacy systems in the public sector. Responsibilites: a. Evaluate existing procedures and methods, identify and document items such as database content, structure, and application subsystems. b....
