Data Engineer/Architect Consultant

at  MSP Corp

Softlanding helps organizations achieve their best by providing technology solutions and services that make them more productive. Our offerings focus on professional services as well as managed services. Softlanding specializes in Microsoft enterprise technology platforms, leveraging a combination of cloud, on-premises and hybrid configurations to increase productivity from the data center to end business users.
At present the company is growing at a rate of over 30% year-over-year, employing staff all across Canada. We have acquired five of six Microsoft partner designations, several Advanced Specializations, and have been written up in the Globe and Mail as the fastest-growing Microsoft partner in Canada.
Softlanding offers all employees the choice for work arrangement: the opportunity to work from our Vancouver office, remotely, or a combination of both/hybrid.
We’re looking for an experienced Data Engineer/consultant to work as part of our data analytics team, supporting clients with requirements gathering, prototyping, development, and support. Client scenarios range in complexity. This individual must have a good blend of people, functional, and technical skills for cross-team collaboration and support. We are looking for individuals who will interface with multiple business and technology stakeholders and teams to evaluate and improve existing processes using multiple technology platforms.

The successful candidate will have:

• 5+ years hands-on experience in Microsoft Data Stack incl. SQL Server, Data Warehousing, Synapse, Spark/Databricks, Fabric
• 3+ years hands-on experience in Microsoft BI Stack incl. Power BI, SSAS, SSRS, SSIS
• Proficiency in the development and administration of at least one of the following areas: Back-end data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development (e.g. ADF), and performance tuning, front-end reporting and analytics platforms including OLAP cube design, tabular data modeling, Performance Point, Power Pivot, Power View
• Strong Data Modeling skills for Star-Schema
• Strong Programing skills in T-SQL, Spark (pyspark,sql,scala, etc), DAX, Power Query
• Strong analytical thinking for translating data into informative visuals and reports
• Experience developing visual reports including custom visuals, dashboards and KPI scorecards using Power BI
• The ability to implement row level security on data and have an understanding of application security layer models in the data platforms of SQL Server, Azure, Synapse, Fabric, and Power BI
• Foundational knowledge of the following areas: Metadata management; Master Data Management; Data Governance; Data Analytics
• Good understanding of standard and premium connectors
• Strong written and verbal communications skills

• Knowledge of Azure data analytics technologies such as Databricks, Synapse, or Fabric
• Knowledge of Power Apps and Power Automate
• Knowledge of Azure AI and Machine Learning stack
• Knowledge of other BI tools such as Tableau, DOMO, Denodo, Cognos
• Knowledge of Purview and configuring the platform

Responsibilities include:

• Architecting, designing, and developing end to end analytical data solutions from source raw data all the way to Power BI front end
• Providing oversight and expertise in Data Modeling and Database Design
• Working with business/project team members to understand the requirements
• Defining BI framework model, semantic layers and Metadata repositories to support reporting and administration
• Developing and managing BI end user presentation layer training and documentation.
• Technical documentation
• Supporting business development efforts (proposals and client presentations)
• Estimating effort for development and support engagements in Data Engineering and related technologies
• Status reporting
• Interacting with various client and management stake holders to get the work completed
• Keeping up to date with the Data Platform technologies in Azure
• Acquiring and renewing Microsoft Certifications.

You would represent Softlanding in the market and must reflect the core values of the company which include:

• Continuous improvement as a way of life
• Fair and generous relationships with our people and customers
• A never give up attitude
• Optimistic by nature
• Resourcefully independent yet aligned with the team

Certifications applicable to role:

• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Certified: Azure Data Engineer Associate
• Microsoft Certified: Fabric Analytics Engineer

Certifications helpful to role:

• Microsoft Certified: Azure Fundamentals
• Microsoft Certified: Azure Data Fundamentals
• Microsoft Certified: Azure AI Fundamentals
• Microsoft Certified: Security, Compliance, and Identity Fundamentals
• Microsoft Certified: Customer Data Platform Specialty
• Microsoft Certified: Azure AI Engineer Associate
• Microsoft Certified: Azure Data Scientist Associate
• Microsoft Certified: Azure Solutions Architect Expert
• Databricks Certifications

Softlanding is headquartered in Vancouver, BC and has a growing team across Canada, with all positions being 100% remote. We encourage qualified applicants from any Canadian province to apply. We thank you for your interest in Softlanding, and look forward to hearing from you.
(Your resume is kept in confidence and will not be shared with any 3rd party or agency