Current jobs related to Data Warehouse Modeller - Ottawa - RCGT Consulting
-
Data Warehouse Modeller
1 week ago
Ottawa, Canada Raymond Chabot Grant Thornton Full time**Summary** Elections Canada requires professional services to architect, design, provide specification documents and guide a team of IT professionals under the direction of the Manager in delivering a data warehouse solution to be used as Elections Canada’s primary source for reporting and business intelligence needs. Elections Canada (EC) business...
-
Data Warehouse Modeller
5 days ago
Ottawa, Canada Nortak Software Ltd. Full timeNortak Software is currently seeking Data Warehouse Modellers with the following qualifications: **Mandatory Requirements**: - 10+ years of experience as a Data Warehouse Modeller - 10+ cumulative years of experience designing Enterprise Data Warehouses and Business Intelligence Solutions - 10+ years of experience producing Real Time data movement...
-
Data Warehouse Modeller
5 days ago
Ottawa, Canada NORTAK SOFTWARE LTD. Full time**Description**: Nortak Software is currently seeking Data Warehouse Modellers with the following qualifications: **Mandatory Requirements**: - 10+ years of experience as a Data Warehouse Modeller - 10+ cumulative years of experience designing Enterprise Data Warehouses and Business Intelligence Solutions - 10+ years of experience producing Real Time data...
-
Data Modeler
5 days ago
Ottawa, Canada Maplesoft Group Full timeMaplesoft Group is currently seeking a Data Modeler for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Primary Responsibilities Under the direction of the Assistant Director, ITS Data Operations: - Assist with creation of Conceptual/Logical/Physical Models for data...
-
Ottawa, Canada Maplesoft Group Full timeMaplesoft Group is currently seeking a Database Modeler/Information Management Modeler - Level 2 for our Federal Government client. The following responsibilities are associated with the “Statement of Work” but are not limited to: Primary Responsibilities - The Data Architect has both strategic and tactical responsibility for developing and maintaining...
-
Data Modeler
3 days ago
Ottawa, Canada Geofirma Engineering Ltd Full timeWork Term: Permanent - Work Language: English - Hours: 40 hours per week - Education: Earned doctorate degree - Experience: 1 year to less than 2 years **Work setting**: - Consulting firm **Tasks**: - Conduct studies of groundwater flow and contamination - Develop models and applied software for the analysis and interpretation of data **Supervision**: - 1...
-
Data Modeler
5 days ago
Ottawa, Canada Geofirma Engineering Ltd Full timeWork Term: Permanent - Work Language: English - Hours: 40 hours per week - Education: Earned doctorate degree - Experience: 1 year to less than 2 years - Geotechnical and geoenvironmental engineering - Engineering, other **Work setting**: - Consulting firm **Tasks**: - Conduct studies of groundwater flow and contamination - Conduct business and technical...
-
Data Modeler
6 days ago
Ottawa, Canada Geofirma Engineering Ltd Full timeDurée de l'emploi: Permanent - Langue de travail: Anglais - Heures de travail: 40 hours per week - Education: - Expérience: **Education**: - Earned doctorate degree **Work setting**: - Consulting firm **Tasks**: - Conduct studies of groundwater flow and contamination - Develop models and applied software for the analysis and interpretation of...
-
Data Scientist and Modeler
5 days ago
Ottawa, Ontario, Canada Monograph Full timeMonograph is an innovative company at the forefront of harnessing the power of data science to drive business growth. As a Data Scientist and Modeler, you'll play a key role in developing and implementing data-driven solutions that inform key business decisions.With a strong foundation in machine learning, statistics, and optimization, you'll work alongside...
-
[Apply Now] SENIOR DATA ENGINEER
6 days ago
Ottawa, Canada Ward Technology Talent Full timeSENIOR DATA ENGINEER (Data Modeling Snowflake/dbt/ETL) Permanent | GTA/REMOTE, ON | August 27, 2024 SENIOR DATA ENGINEER (Data Modeling Snowflake/dbt/ETL) We are looking for a talented Senior Data Engineer to join our Client’s team. The ideal candidate will be responsible for designing, building, and maintaining ELT (Extract, Load, Transform) pipelines...
-
Application Data Modeling Lead
6 days ago
Ottawa, Canada Cpus Engineering Staffing Solutions Inc. Full timeWe are currently requesting resumes for the following position: Application Data Modeling Lead Resume Due Date: Monday, December 18^th, 2023 (5:00PM EST) Number of Vacancies: 1 Level: Band G Duration: 12 months Hours of work:35 Location: 700 University Ave (Hybrid, 2 days remote) Job Overview Overview - The Application Data Modelling Specialist will...
-
Data Modeling and Analytics Professional
6 days ago
Ottawa, Ontario, Canada ROSS Full timeCompany OverviewOur client is a pioneer in the business intelligence and analytics space, known for its cutting-edge solutions and commitment to excellence. With a rich history of innovation and growth, they continue to drive change and improvement in the industry.Job DescriptionThe role of Data Modeling and Analytics Professional at ROSS involves working...
-
Data Architect Data Analytics
8 hours ago
Ottawa, ON, Canada Persistent Systems Full timeAbout Persistent We are a trusted Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our 22,800+ global team members, located in 21 countries, have been instrumental in helping the market leaders transform their industries. We’re also pleased to...
-
Data Engineer
3 hours ago
ottawa, Canada ASB Resources Full timeJob Description :This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise in understanding Banking and Capital markets , especially in investment banking would be a...
-
Data Engineer
2 minutes ago
Ottawa, Canada ASB Resources Full timeJob Description :This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone that is comfortable working with business users along with business analyst expertise in understanding Banking and Capital markets , especially in investment banking would be a...
-
Senior Data Engineer
1 day ago
Ottawa, Canada Kaizen Technologies Full timeRole: Data Engineer Location: Kantana, Ottawa, Canada 3 Days Hybrid from Day 1 Must Have: • Snowflake • Databricks • SQL • Python • ADF • PySpark • Data Warehouse Concepts Job Description : This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The...
-
Data Scientist
2 weeks ago
Ottawa, Canada Ciena Full timeCiena is committed to our people-first philosophy. Our teams enjoy a culture focused on prioritizing a personalized and flexible work environment that empowers an individual’s passions, growth, wellbeing and belonging. We’re a technology company that leads with our humanity—driving our business priorities alongside meaningful social, community, and...
-
Data Architect Data Analytics
8 hours ago
Ottawa, ON, Canada Pyramid Consulting, Inc Full timeImmediate need for a talented Data Engineer. This is a 06+months contract opportunity with long-term potential and is located in Kanata, Ottawa, Canada(Hybrid). Please review the job description below and contact me ASAP if you are interested. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan,...
-
Senior Data Engineer
24 hours ago
Ottawa, Canada Kaizen Technologies Full timeRole: Data EngineerLocation: Kantana, Ottawa, Canada3 Days Hybrid from Day 1Must Have:• Snowflake• Databricks• SQL• Python• ADF• PySpark• Data Warehouse ConceptsJob Description :This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone...
-
Senior Data Engineer
1 day ago
Ottawa, Canada Kaizen Technologies Full timeRole: Data EngineerLocation: Kantana, Ottawa, Canada3 Days Hybrid from Day 1Must Have:• Snowflake• Databricks• SQL• Python• ADF• PySpark• Data Warehouse ConceptsJob Description :This position is for a Cloud Data engineer with a background in Python, Pyspark, SQL and data warehousing for enterprise level systems. The position calls for someone...
Data Warehouse Modeller
2 weeks ago
**Summary**
Elections Canada requires professional services to architect, design, provide specification documents and guide a team of IT professionals under the direction of the Manager in delivering a data warehouse solution to be used as Elections Canada’s primary source for reporting and business intelligence needs. Elections Canada business processes and business systems consist of people managing information and data. Diligence is critical for the Agency to support effective business processes and to enable efficient business systems.
**Main Responsibilities
All items listed below are services to be performed in the context of delivering, supporting and maintaining a Data Warehouse:
- Design, develop and maintain overall solution architectural model depicting components and flows from back end master data sources through to front end reports/visualizations. Typically documented in Microsoft Office (Word, Excel, PowerPoint, Visio) or Architect tool such as Sparx Enterprise Architect.
- Design, develop and maintain Conceptual, Logical and physical Data Models both in Microsoft Office (Word, Excel, PowerPoint, and Visio) and within the data modeling tool (ER/Studio).
- Document data lineage, metadata, data model designs and all specifications in the data modeling tool, ER/Studio
- 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 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
- Participate in data analysis as a result of new/updated requirements
- Provide input to refinement of requirements
- 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 and design
- Participate in data architecture and design refinement
- Define access strategies
- Produce ETL architectural design in the data modeling tool as well as Microsoft Office
- Participate in the development of specifications required by a data warehouse such as ETL, replication (Change Data Capture technology) and others
- Provide support and maintenance to all aspects of the data warehouse and Business Intelligence and reporting systems/solutions that leverage the data warehouse
- Provide support on Business Intelligence tool data modeling and kpi transformations and calculations, the tool used at Elections Canada is Cognos
- Provide Business Intelligence developers guidance on mapping Business Intelligence requirements to the data warehouse
- Provide guidance and assistance to other team members on the use of ER/Studio
- Provide generated data for each layer of the data warehouse through the use of a data generation tool, Elections Canada uses the RegGate solution.
- Provide guidance and assistance to the development team
- Provide guidance and assistance to business partners and other stakeholders
- Construct, monitor and report on work plans and schedules
**Mandatories**
- Hold a valid level II: Secret Clearance
- Fluently bilingual in both French and English
- 10+ cumulative years of experience as a Data Warehouse Modeller
- 10+ cumulative years of experience designing Enterprise Data Warehouses and Business Intelligence Solutions.
- 10+ years of experience producing Real Time data movement Architecture and Design including using project description
**Assets**
- Data Warehouse Modeller - Additional Experience
- Data Warehouse Design having multiple business lines and data sources
- Reverse Engineering Business Intelligence Requirements into Corporate Data Warehouse Operational Data Store and Data Marts data models
- Experience with KingwaySoft SSIS integration toolkit for Microsoft Dynamics
- Experience with Qlik Replicate and Qlik Compose
- Experience with Cognos BI Modeling, Data Modules, Dashboards, drill downs and Geography maps
- Experience with ER/Studio as a data modeling tool