Maplesoft Group is currently seeking an Azure Synapse Developer for our client.

Tasks and Responsibilities include, but are not limited to the following:

Responsible to evaluate user business requirements and develop bilingual data solutions.  Is focused on meeting user needs and improving the efficiency of the client's operations through data solutions.

Possesses a strong understanding of Microsoft Azure Synapse and related tools. Strong programming skills to develop Dataflows, Pipelines and Notebooks for ELT ingestion, cleaning and transforming of data, building datasets, developing facts and dimensions. Defines and develops semantic bilingual models to be used in Power BI reports as well as self-serve use. Diagnoses, isolates and de-bugs data solution problems and performs problem resolution. Monitors data solutions performance and efficiency and optimization of ingestion and transformation processes. Prepares technical documentation of data solutions.

Education:
• Bachelor’s degree in Computer Science, Information Technology, Business Analytics or related field or an equivalent combination of education and experience. 

Experience:
• Minimum 3 years of experience in the development and implementation of system and software programs based on Microsoft Azure technologies.
• Experience with data manipulation, data analysis, analytic and reporting tools (Azure Synapse Analytics, Pipelines, Dataflows, Notebooks, PySpark, Power BI).
• Experience in data manipulation and integrity checking for a variety of data types to transform data for reporting and analytics.
• Knowledge and experience working within a Medallion Architecture (Raw, Silver and Gold layers).
• Knowledge and experience with business intelligence concepts (semantic data modelling, star schemas), databases with related functions (SQL queries, stored procedures, REST APIs, JIRA) and various data formats (Parquet, Delta formats, JSON).
• Knowledge and experience using statistical packages to analyze datasets (SQL Developer, R, Python, SPSS, SAS, etc.).
• Experience in big data and cloud technology Microsoft Azure (Synapse, Storage accounts).
• Experience with API or services integrations and a firm understanding of implementing solutions with multiple data sources.
• Experience translating data into KPIs meaningful to and accessible by specific bilingual audiences.
• Experience in developing bilingual dashboards, visualizations, and the use of tools like Power BI to garner business insights from social, client and time series data.
• Ability to handle conflicting work demands from multiple projects and deliverables.
• Critical thinking skills to understand business and convert to conceptual data models and inform analysis.
• Ability to understand business needs, build relationships, communicate with business users.
• Bilingualism - both French and English (spoken and written).

Responsibilities:
Overall responsibility: delivering data solutions that answers business needs.
• Business analysis: Conduct the evaluation and integration of multiple business and strategic needs, both implicit and explicit, as well as recommends sound and justified data solutions to help monitor timely quantitative data related to the client's operations and to solve business problems.
• Design: Designs data solutions to complex business problems applicable in a wide array of operations, including conceptual and logical data models, static and dynamic reporting tools and programming languages.  Ensures that each unique need is adequately served to maximize effectiveness and minimize the impact of obstacles.
• Data analysis: Provides quantitative processes/data analysis of client-wide data and prepares documentation explaining data source, trends, comparisons and business knowledge discoveries as it relates to the client population, operations and resources.  The data analysis would serve as a starting point for data solutions development.
• Development and Testing: Implements business intelligence projects and complex data solutions including scoping solutions, identifying data sources and business rules, and performs integration tests to ensure that the solution meets the requirements in term of flexibility, functionality, performance, reliability and security. Evaluates and diagnoses the impact of proposed solutions on existing systems, ensuring their coherence with those already in place. Track, monitor and demonstrate completion of a requirement, maintaining an emphasis on the end-user experience.
• Risk Assessment: Anticipate risks and issues in plans and requirements and takes appropriate action to mitigate and resolve them. Ensure that designs are implemented into a solution that is fully tested, functional and accurate.  Oversee the smooth transition of all system enhancements into the daily operations of users.
• Reporting: Ensures successful delivery of reporting for BI as required by executives, managers and campus-wide users to serve operational and strategic management needs. Oversees data quality and designs efficient data solutions that help users gain insights and make better fact-based business decision all while ensuring adequate performance. 
• Documentation: Writes data dictionaries, business process documentation as it relates to the programming of data solutions and semantic modelling work and ensures these are accessible and readily available to all clients, stakeholders and business owners for validation purposes and to serve as reference to understand what has been developed.
• Project management: Establishes project steps, milestones and timetables including analyzing and estimating feasibility, time and compatibility with application and other programs to ensure completion within the established timeframe.

Deliverables:
• Design and develop data domains to answer business requirements.
• Program ELT processes to ingest data from source systems and external files to Azure storage.
• Clean and transform data for use in data solutions.
• Build datasets, facts and dimensions relevant to a star schema approach.
• Develop bilingual semantic models for data domains to be used in Power BI reports and as self-serve datasets.
• Define security configurations required for data domains.
• Troubleshooting and debugging the data solutions.
• Work with the security team to implement security measures in all applicable areas.
• Preparing technical documentation for the developed solution.
• Collaborating with other team members and stakeholders.
• Knowledge transfer documentation.


Maplesoft Group prides itself on its distinct corporate culture and recognizes that success is a direct reflection of our most valuable asset - our people.  Therefore, attitude and ambition are key personality traits we seek out, along with skill and aptitude, in potential employees.

Maplesoft Group is committed to having a diverse, representative workforce and continuing to build an inclusive environment. We encourage applications from all qualified individuals. Maplesoft Group is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants irrespective of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans’ status, Aboriginal peoples or any other legally protected factors. 

All employment decisions are made based on business needs, job requirements, and individual qualifications. 

We are committed to developing inclusive, barrier-free recruitment and selection processes, and a work environment that supports our diverse workforce. Please let us know if you require accommodations at any stage of the recruitment process. We can be reached at Maplesoft Info at info@maplesoftgroup.com.

We thank you for your interest in Maplesoft Group and wish to advise you, that only candidates under consideration will be contacted.