Data Architect/Data Modeler for MS SQL (on-prem and Azure)(6-12 months contract)

Putting people first, every day BDO is a firm built on a foundation of positive relationships with our people and our clients. Each day, our professionals provide exceptional service, helping clients with advice and insight they can trust. In turn, we offer an award-winning environment that fosters a people-first culture with a high priority on your personal and professional growth. Your Opportunity BDO Digital is looking for a contractual Data Architect/Data Modeler for MS SQL (on-prem and Azure) to join our cloud engineering team, assuming the following responsibilities: Design, develop & test enhancements and support MS SQL, Azure SQL DB and Azure MI database systems. Provide technical analyses and recommendations in terms of new solutions and supporting existing ones. Ability to translate meta data and/or requirements into a DB design and understand the impacts of the design in terms of DB performance so we can ensure the full solution is optimal. Develop DDL/DML scripts and enhance DB performance (queries, stored procedures, views, data distribution patterns, etc.). Understanding the use of Source Code Management for tracking database scripts using Git or TFVC and its tools (Bitbucket and Azure DevOps). Understanding the impact of data encryption in database solutions using Always Encrypted and/or Tokenization. Ability to contribute in Agile environments with understanding of its methodologies (Scrum/Kanban) and its tools (Jira, Confluence, Azure DevOps). Experience developing ETL solutions with SSIS or Data Factory is an asset. Experience working with remote teams. 24x7 pager support on a rotating basis. Able to work individually or as part of a team. Possess good technical presentation and communication skills. Willingness to be accountable/responsible for assigned tasks/projects. Ability to prioritize work in a fast-paced environment. How do we define success for your role? You demonstrate BDO's core values through all aspect of your work: Integrity, Respect and Collaboration You understand your client’s industry, challenges, and opportunities; clients describe you as positive, professional, and delivering high quality work You identify, recommend, and are focused on effective service delivery to your clients You share in an inclusive and engaging work environment that develops, retains & attracts talent You actively participate in the adoption of digital tools and strategies to drive an innovative workplace You grow your expertise through learning and professional development. Your experience and education Strong experience in designing, developing, and supporting MS SQL, Azure SQL DB, and Azure Managed Instance (MI) database systems. Experience in logical database design (tables, relationship, unique keys, etc.) Erwin data modeling is a plus Knowledge of various index implementation. Proficiency in developing DDL/DML scripts, optimizing database performance (queries, stored procedures, views, data distribution patterns, etc.). Skilled in translating metadata or requirements into database designs, with a deep understanding of the performance impacts of various design choices. Ability to provide technical analysis and offer recommendations for new database solutions as well as support existing systems. Familiarity with source code management tools such as Git or TFVC, and experience with Bitbucket or Azure DevOps for tracking database scripts. Knowledge of data encryption techniques, including Always Encrypted and tokenization, and their impact on database solutions. Experience working in Agile environments (Scrum/Kanban) and familiarity with tools such as Jira, Confluence, and Azure DevOps. Experience with developing ETL solutions using SSIS or Azure Data Factory is an asset. Why BDO? Our people-first approach to talent has earned us a spot among Canada’s Top 100 Employers for 2024. This recognition is a milestone we’re thrilled to add to our collection of awards for both experienced and student talent experiences. Our firm is committed to providing an environment where you can be successful in the following ways: We enable you to engage with how we change and evolve, being a key contributor to the success and growth of BDO in Canada. We help you become a better professional within our services, industries, and markets with extensive opportunities for learning and development. We support your achievement of personal goals outside of the office and making an impact on your community. Giving back adds up: Where company meets community. BDO is actively involved in our communities by supporting local charity initiatives. We support staff with local and national events where you will be given the opportunity to contribute to your community. Total rewards that matter: We pay for performance with competitive total cash compensation that recognizes and rewards your contribution. We provide flexible benefits from day one, and a market leading personal time off policy. We are committed to supporting your overall wellness beyond working hours and provide reimbursement for wellness initiatives that fit your lifestyle. Everyone counts: We believe every employee should have the opportunity to participate and succeed. Through leadership by our Diversity, Equity and Inclusion Leader, we are committed to a workplace culture of respect, inclusion, and diversity. We recognize and celebrate the valuable differences among each of us, including race, religious beliefs, physical or mental disabilities, age, place of origin, marital status, family status, gender or gender identity and sexual orientation. If you require accommodation to complete the application process, please contact us. Flexibility: All BDO personnel are expected to spend some of their time working in the office, at the client site, and virtually unless accommodations or alternative work arrangements are in place. Our model is a blended approach designed to support the flexible needs of our people, the firm and our clients. It’s about creating work experiences that meet everyone’s needs and providing flexibility to adjust when, where and how we work to meet the expectations of our role. Code of Conduct: Our Code of Conduct sets clear standards for how we conduct business. It reflects our shared values and commitments and includes guiding principles to help us make ethical decisions and maintain trust with each other, our clients, and the public. Ready to make your mark at BDO? Click “Apply now” to send your up-to-date resume to one of our Talent Acquisition Specialists. To explore other opportunities at BDO, check out our careers page . LI-SA1

Location: Toronto, CA

Posted Date: 11/4/2024