Systematix

We are Systematix and we are looking for a Data Analyst for an upcoming opportunity with a public sector client. This contract is expected to start in October and last until October 2026. The ideal candidate must possess a Reliability level security clearance.

About the Project

In 2021, the client embarked on a digital transformation journey to become a more customer focused digital organization. Key to achieving the digital transformation is the data and analytics strategy. Over the last year, to enable the Digital transformation and data analytics strategy, the client has invested in developing a consolidated enterprise data platform on Azure cloud.

About the Responsibilities

• Collects, documents, and analyzes information management and data requirements
• Designs and implements data solutions using the client’s data platform technologies
• Creates, reviews and validates conceptual, logical, and physical data models of applications to determine compatibility and fit with architectural principles and optimal solution design.
• Designs, creates and optimizes data flows for migration methods of existing data.
• Works collaboratively with information governance analysts and data architects to ensure that data models and structures are compliant with governance standards.
• Communicates requirements, issues, and options for resolutions to various stakeholders and tailors messages to the audience.
• Understand existing applications, data stores and structures, data flows and elements.
• Reverse engineer legacy ETL to modernize it for the enterprise data platform.
• Design and implement future state architectures and data solutions

About the Qualifications

• Over 7 years of demonstrated experience in SQL programming and refactoring.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Experience with reverse engineering legacy ETL builds (Data Manager) and source-to-target mappings to design and build future data assets.
• Well-rounded hands-on experience in the following data management domains: dimensional and relational data modeling, SQL programming and ETL development.
• Experience implementing medallion architecture in Databricks.
• Programming experience in SQL, Python and Apache Spark.
• Validation/ testing of developed data solutions by comparing to existing or proxy datasets.
• Experience with Microsoft Azure or other public cloud offerings.
• Experience in Agile delivery.
• Experience in IBM Data Manager.
• Ability to understand, interpret, develop and maintain requirements and design documents
• Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.

Assets:

• Experience with ERWIN or similar data modelling tool.
• Experience with Denodo data virtualization.
• Experience with Power BI report development.
• Experience working in an Agile environment/team.
• Bilingualism in both official languages (English and French).

Candidates must outline in detail how they meet the above requirements.

At Systematix, our core values-excellence, collaboration, respect, and knowledge as a pursuit—underpin our commitment to fostering an inclusive and equitable environment. We encourage everyone to be their authentic selves, and we are committed to ensuring that our employment decisions are entirely based on job requirements and individual qualifications. We welcome applications from qualified candidates of all backgrounds, including but not limited to race, ethnicity, gender identity or expression, sexual orientation, disability, age, and religious beliefs. If our values and the position advertised resonate with you, we encourage you to apply.