Sr Database Modeler to support the data repository and reporting development for a Network Support modernization project

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

Apply