Lead, Database Architect

Return to List

City : Ottawa

Category : Accounting, Financial, Insurance

Industry : Business Services

Employer : Deloitte

Job Type:  Permanent 
Primary Location: Ottawa, Ontario, Canada 
All Available Locations: Ottawa 


Deloitte, one of Canada's leading professional services firms, provides assurance & advisory, tax, consulting, and financial advisory services through more than 8,000 people in 56 offices. Deloitte LLP, an Ontario Limited Liability Partnership, is the Canadian member firm of Deloitte Touche Tohmatsu Limited. Deloitte operates in Quebec as Deloitte s.e.n.c.r.l., a Quebec limited liability partnership.Your career is important to you. It's important to us, too. The time is right for you to join Deloitte.

Deloitte is committed to creating an environment that is inclusive and accessible to clients and employees of all abilities. We are dedicated to building a diverse workforce and encourage applications from all qualified candidates.

A career at Deloitte will offer you the opportunity to:


Overview of Role and Responsibilities;


  • Architect, size, and implement databases
  • Design and develops data repository and data models
  • Establishes data quality assurance guidelines
  • Support administration and performance of database
  • Perform data conversion and migration between systems
  • Provide solutions and/or recommendations to implement new functionality or resolve technical issues related to data architecture
  • Expect to interact with client technical resources and subject matter experts




Required Qualifications:


  • Completed undergraduate degree in technology related program or college diploma equivalent with work relevant work experience
  • Minimum 5 years of relevant experience
  • Experienced with project problem diagnosis, solution development, client communications, facilitation of decision making, documentation, technical managing client expectations , team work
  • Strong commitment to professional and client deliverable quality
  • Strong verbal and written communication skills


Technical Qualifications:


  • Extensive experience with data architecture, data modeling designs & architectures
  • Demonstrated experience with design, implementation  of data model and associated tools
  • Experience using data integration/ETL tools, such as Oracle Data Integrator (ODI) or Microsoft SSIS
  • Experience with working with Business Users to gather and translate requirements into necessary data structures
  • Excellent knowledge of SQL programming language and stored procedures such as PL/SQL or T-SQL
  • Experience with Oracle (11g or above) or Microsoft SQL server 2014 or above


Preferred Requirements


  • Data warehouse designs & architectures
  • Big Data
  • Experience with Java or .Net development platforms
  • ETL tools such as Informatica or DataStage
  • BI Applications data model and associated tools
  • Experience in multiple formal SDLC methodologies including Agile (SCRUM, SAFe, Kanban)
  • Cloud and architecture, AWS, replication, high availability
  • Open-source database (MySQL, PostgreSQL…)
  • NoSQL database (MongoDB, Couch DB, Cassandra…)

About Deloitte

Get your career off to a great start. What impact will you make?


We’re always looking for people with the relentless energy to drive and push themselves further to find new avenues and unique ways of reaching our shared goals. At Deloitte, we know that being the undisputed leader means empowering our people to be the very best they can be – so they can make an impact that matters for clients, colleagues and the community, and for their own careers.


We offer a truly differentiated talent experience that empowers our people with unlimited opportunities to do meaningful work and to grow, learn, and lead at every point in their career.  Deloitte’s newly designed offices offer unique workspaces that strengthen connections, inspire innovative ways of working, and provide the necessary tools to help you make an impact that matters. And with our global reach and network, you’ll always be part of the Deloitte community.


“Once Deloitte, always Deloitte.”



We thank all applicants in advance for their interest; however, only those candidates selected for an interview will be contacted.

Return to List


Subscribe to our newsletter & stay updated