Skills

Communication Time Management Critical Thinking Python Data Analysis SQL Apache Spark Attention to detail Architecture Information Architecture Virtualization Programming apache power bi Analytical Skills Azure Agile Spark Databricks Microsoft Azure

Job Specifications

*** Please specify your security clearance level in resume, resumes without security clearance level will not be shortlisted for review for this client***

Duration: 12 Months

Location: Remote (Physically present in Canada + EST Time Zone)

Mandatory: Any GoC Reliability/Secret/Top Secret Clearance Required

We are seeking a Data Analyst for one of our client. The Data Analyst will lead the design and implementation of data and technology solutions for the enterprise data platform. The selected candidate will be responsible for analyzing information requirements, recommending options for business and technology solutions, deliver blueprints for design, and implement them so they are aligned with client's information strategies and governance standards. The individual is experienced in information requirements collection and analysis, data modeling, and data integration. The data analysis service provider needs to quickly come up to speed on current state information architecture and familiarize themselves with client's information management context.

Primary Responsibilities

Collects, documents, and analyzes information management and data requirements
Designs and implements data solutions using 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.

Project Requirements

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
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)

We thank you for visiting the job page. Only candidates closely matching the requirement will be contacted for interview. Wishing you all the best in your job search.

About the Company

Based in the vibrant National Capital Region of Canada, we specialize in cutting-edge services tailored for diverse industries. Our offerings include strategic Advisory solutions, thorough Assessments, seamless Implementation, Recruitment and Staffing services. We excel in Data (covering Maturity, Governance, Architecture, Analysis and Security), AI, ML, RPA, Cloud (Assessments, Migrations, Vendor Recommendations), Agile methodologies, and a range of other Professional Services. Trusted by the public sector, private sector, ... Know more