RQ08928 Data ArchitectModeller

Advantages
- Hybrid work model with 2 days onsite per week
- Work with Azure Data Lake, Databricks, and MS SQL Server
- Hands-on experience with enterprise data modelling and BI reporting solutions
- Opportunity to optimize and design large-scale data warehouse solutions
- Competitive compensation and contract stability

Responsibilities
Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.

Qualifications
Must Haves:
- 7+ years in data modelling and data warehouse design.
- 2+ years Azure Data Lake and Azure Databricks SQL Warehouse.
- 5+ years SQL.

Desired Skills:
- Knowledge of Curam IBM COTS solutions (Social Assistance Management System).
- ETL/ELT design concepts.
- Knowledge of Enterprise Architecture tools and frameworks (ArchiMate, TOGAF, Zachmann).

General Skills:
- 7+ years of BI Data Architect experience in enterprise applications and solutions design/development related to data warehousing, data lake implementations and dimensional modelling.
- Collect business-level questions and propose approaches to address business needs and provide data insights.
- Expand documentation and knowledge of business processes relative to available data to provide contextual guidance for operation/project, reporting and insights generation.
- Ability to design and articulate complex technical concepts into executable development work packages.
- Knowledge of BI tools for metadata modelling and report design (e.g. Power BI).
- MS SQL Server Technology, Azure Data Lake, Azure Databricks.
- Expert knowledge in developing data warehouse solutions on MS Stack (Azure Data Lake, SQL, ADF, Databricks, PowerBI) to store and retrieve centralized information. Experience designing the data warehouse using dimensional and delta lake concepts.
- Create/maintain enterprise data model and data dictionary. Help the development team to optimize database performance. Coordinate with the business analysts to identify future needs and requirements.
- Extensive knowledge of data modelling tools (e.g. PowerDesigner, Visio).
- Review, install and configure information systems to ensure functionality and security. Analyze structural requirements for new data warehouse and applications.
- Experience using Oracle database server and tools, PL/SQL for development of Business Intelligence applications.
- Demonstrated skills in writing SQL stored procedures and packages for datamarts and reporting.
- Demonstrated experience in Azure DevOps.
- Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization.

Summary
Our client is looking for a Data Architect/Modeller with expertise in Azure Data Lake, Databricks, SQL Server, and BI reporting solutions. If you have experience in data modelling, data warehouse optimization, and cloud-based analytics, this is an excellent opportunity to work on large-scale data initiatives in a structured environment.

Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So even if this role isn’t for you, please update your profile so we can find you!

We look forward to supporting you in your job search! Good luck!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.