Senior Data Engineer - RFR 23015

• Developing dashboards and reports using Microsoft technologies (SSRS reports, SSAS / Tabular cubes, Power BI),
• Building data warehouses, analytics, and dimension modeling using IDE
tools such as Visual Studio, Eclipse or Jupyter Notebook

Advantages
Great opportunity to join the broader public sector and support an ongoing initiative.

Responsibilities
• Consult with management on the operational requirements of software solutions
• Mentoring junior data engineers to ensure effective management of data pipelines
• Managing the continual development of the BI data pipeline
• Completing code and script updates as well as resolving product implementation errors
• Perform complex data analyses with large data volumes
• Translate BI architectural diagrams into working solutions
• Develop scalable ETL solutions to deliver data pipelines
• Conforming to best practices in network administration and cyber security
• Assists with BI project work efforts estimation
• Develops detailed technical specifications, User Guides and ETL
documentation including training of users
• Serves as Subject Matter Expert in BI tool development concepts
• Researches into the current state of BI marketplace to make recommendations and selection criteria for the procurement of new BI tools and technologies
• Coordinates and supports development efforts of technical and corporate staff with database tuning efforts as well as ongoing application implementation, support and upgrades
• Supports production issues and maintenance as necessary – acting as second level support for troubleshooting and resolving BI related applications / databases
• Participates in BCP and DR planning, ITSM process improvement, run book creation and service catalog updates

Qualifications
**MANDATORY EXPERIENCE**
Formal Education & Certification
• University degree in software engineering, computer science, information technology, information systems or equivalent

Experience Technical Skills:
• 10 years’ experience in designing / architecting high performance ETL programs using T-SQL and SSIS,
• Developing dashboards and reports using Microsoft technologies (SSRS reports, SSAS / Tabular cubes, Power BI),
• Building data warehouses, analytics, and dimension modeling using IDE tools such as Visual Studio, Eclipse or Jupyter Notebook

Technical Skills/Qualification/Certification/Designation:
• Deep understanding of multidimensional and tabular data models
• Minimum of 5 years of Power BI development
• Minimum of 5 years of working experience in a data engineering department preferably as a data engineer
• Demonstrated experience in building and maintaining reliable and scalable ETL on big data platforms as well as experience working with varied forms of data infrastructure such as SQL, Hadoop, Spark and Azure Databrick
• Experience in data warehousing using dimensional modeling concepts demonstrating proficiency in scripting languages
• Excellent oral and written communication skills and ability to present to client groups, to consult with technical and non-technical staff and to prepare reports and proposals
• Advanced knowledge of best practices related to data encryption and cyber security

**Additional Skills and Experience**
• 5+ years’ experience with master data management, development on big data platforms (Hortonworks, Cloudera or Azure) and languages such as Python, R or SPARQL
• 10 years’ experience with data modeling multidimensional and tabular models, data management, data migration, data cleansing and synchronization and working with business clients directly by consulting with them to gather requirements to deliver projects
• Extensive experience in data engineering, team management and collaboration in an agile environment
• ITIL certification

Summary
If interested and qualified for this role, please apply today for immediate consideration!!!

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.