Search jobs > Ottawa, ON > Data architect

Data Architect with AWS Data Lake & Redshift expertise

Brainhunter
Ontario, Ottawa
$60K a year (estimated)
Full-time

Data Architect - #61310

About the Job :

Mindwire is currently seeking a Senior Data Architect to work for our valued Federal Government client.

The position is remote.

Responsibilities :

  • Increase clients data handling capacity by orders of magnitude (provide more data to consumers)
  • Make data accessible, shareable and understandable (democratize data and increase value extraction)
  • Provide data security and data access auditing
  • Support data governance (automated data quality, data transformation, data assets, etc.)
  • Support standardization (data concepts, master data, aggregation, trending, etc.)
  • Streamline and automate data flows and business processes
  • Ability to adjust system capacity to meet variable demand
  • Support remarkable customer experiences with client data

Requirements and Qualifications :

  • Expert data modeling for complex operational transactional solutions with more 100+ entities.
  • Expert dimensional data modeling for data warehouse or data lake solutions with 20+ dimensions.
  • Demonstrated experience designing complex Enterprise, Common or Canonical Data Models.
  • Practical experience leveraging Industry Reference Data Models preferably in healthcare, such as HL7 FHIR, RIM, Ontario CIM, etc
  • Demonstrated experience implementing physical data models with new generation AWS Redshift data warehouse.
  • Demonstrated experience with Data Lake concepts on a AWS platforms ideally with Informatica (AWS S3, Glue, EMR, Athena, Redshift Spectrum, Kinesis, VPC and Informatica Big Data management platform).
  • Advanced understanding of Enterprise Data architecture concepts, patterns, and standards.
  • Experienced in Data Architecture and Data Management approaches and implementation methodologies.
  • Demonstrated project delivery experience providing data architecture leadership in large scale data architecture and data migration projects.
  • Very good understanding of data warehouse methodologies including design patterns, data mapping, data integration, data testing and application performance tuning.
  • 30+ days ago
Related jobs
Great Canadian Gaming Corp.
Ottawa, Ontario

Demonstrated experience with Data Lake concepts on a AWS platforms ideally with Informatica (AWS S3, Glue, EMR, Athena, Redshift Spectrum, Kinesis, VPC and Informatica Big Data management platform). Expert dimensional data modeling for data warehouse or data lake solutions with 20+ dimensions. Demon...

Promoted
CloudLabs Inc
Canada
Remote

Proven experience as a Data Engineer or similar role, with a strong focus on AWS data services. The ideal candidate will have strong expertise in AWS data services, particularly Athena, Glue, S3, and other storage services. Expertise in AWS data services such as Athena, Glue, S3, and other storage s...

S.i. Systems
Ottawa, Ontario

Power Bi (DAX) expert to support a Financial client with data modelling and dashboards. Expertise in performance tuning and optimization of. A bachelor’s degree in computer science, data analytics or a relevant field. Microsoft Data and/or BI certifications are a strong asset. ...

360insights
Hybrid Remote, Ontario, Canada
Remote

Proven experience as a Data Architect with 5-10 years of experience, with a focus on data lakes, data pipelines, and master data management. Lead the design and implementation of robust and scalable data architectures across enterprise and 360 SaaS platform, with an initial focus on data lakes/wareh...

S.i. Systems
Ottawa, Ontario

Our client is looking for a Project Manager with telecom industry experience to work on new Voice /Data product introduction into their service offerings to all customers: Mobility, Residential, and SMB. Maintain the Project Management Office Library with a lessons learned database, and apply lesson...

Tiger Analytics
Ottawa, Ontario
Remote

The right candidate will have broad skills in database design, be comfortable dealing with large and complex data sets, have experience building self-service dashboards, be comfortable using visualization tools, and be able to apply your skills to generate insights that help solve business challenge...

S.i. Systems
Ottawa, Ontario

The client requires expertise in data management and analytics services to provide assistance in designing, developing and operationalizing data management and analytics services and solutions managed by the Chief Data Office (CDO) team, to further enable the Data and Digital Transformation initiati...

TELUS
Ottawa, Ontario

Strong experience in data modelling and data architecture with a strong foundation in data warehousing and dimensional data modelling. Architect and design data governance solutions such as Metadata management, data privacy, data quality controls. In this role you will work collaboratively with diff...

TV2 Consulting
Ottawa, Ontario

Hands-on experience with building secure, scalable, performant, and highly available database applications. The candidate is expected to be able to communicate well with remote teams, adapt rapidly and learn fast. Familiarity and hands-on experience with profiling, code efficiency, and building soft...

Redpanda Data
CANADA
Remote

This could range from running workshops with customers to getting them up and running on Redpanda products, and/or helping to architect a full end-to-end data streaming system with Redpanda as the core solution. Come and join our rapidly growing Customer Success Engineering team! As a Solutions Arch...