Data Analyst Full Time

We are looking for a Data Analyst for our client who meets the following criteria:

• Language: Bilingual (English and French).
• Security Clearance: Reliability.
• Location of Work: Remote.
• Mandatory requirements:
  • Must have understanding of existing applications, data stores and structures, data flows and elements.
  • Must have experience in reverse engineering legacy ETL to modernize it for the enterprise data platform
  • Must have experience in designing and implementing future state architectures and data solutions
  • Must have over 7 years of demonstrated experience in SQL programming and refactoring
  • Must have strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
  • Must have experience with reverse engineering legacy ETL builds (Data Manager) and source-to-target mappings to design and build future data assets
  • Must have well-rounded hands-on experience in the following data management domains: dimensional and relational data modeling, SQL programming and ETL development.
  • Must have experience implementing medallion architecture in Databricks
  • Must have programming experience in SQL, Python and Apache Spark
  • Must have experience in validation/ testing of developed data solutions by comparing to existing or proxy datasets
  • Must have experience with Microsoft Azure or other public cloud offering
  • Must have experience in Agile delivery
  • Must have experience in IBM Data Manager
  • Must have the ability to understand, interpret, develop and maintain requirements and design documents
  • Must have excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills
  • Must have experience with ERWIN or similar data modelling tool
  • Must have experience with Denodo data virtualization
  • Must have experience with Power BI report development
  • Must be bilingual (English and French)

If interested, please reach out to Girlie at girlie@mdosconsulting.com