Description et exigences de la tâche
Role: BSA with Data Lake, Azure Data Factory, Synapse & SQL
Location: Toronto
Hybrid
BSA/DA Responsibilities -
• 6-8 years of BSA experience in data analytics/data warehouse/data integration through agile environment.
• Strong communication, interpersonal, collaboration, and negotiation skills to work seamlessly in an agile cross-functional team, with clients, vendor(s) and other stakeholders.
• Creative, innovative, and can think outside the box to visualize solutions that meet business needs.
• Strong experience in data analysis, profiling, clean-up, data wrangling and validation. Hands-on experience building data quality checks and writing complex SQL queries.
• Experience working in large scale Enterprise Data Lake ingestion and extraction projects.
• Experience working with Jira, Confluence, Bitbucket.
• Experience with Data Lake, Azure Data Factory, DataBricks, python, Synapse/SQL Server, Analytics Zone, Azure Scheduler, Tableau, Power BI.
• Demonstrable experience with conceptual, logical and physical data modeling techniques.
• Solid knowledge of metadata management principles, metadata modeling and writing metadata definitions.
• Good understanding of data Security Classifications, Risk Assessment (TRMIS) guidelines.
• Strong analytical, organizational, and technical skills to analyze, model and interpret data.
• Knowledge with Solutions Development Life Cycle (SDLC) and structured methodologies including agile, waterfall and iterative.
• Work Experience in investigating, analyzing, estimating system applications in a large integrated solution environment.
• Proven experience with all stages of automated system implementation in complex solutions, with online and batch processing of transactions.
• Proven experience with sprint facilitation, interpretation of business needs to technical requirements, facilitation of project meetings for reviews.
• Able to prioritize requirements, change requests for Business and work with Project team/Scrum Master in determining how best to address them.
• Experience with supporting legacy applications such as Mainframe, other on-prem applications and Migration of legacy solutions using COTS products.
• Experience in current state analysis through reverse engineering, identify source & downstream systems.
• Experience in conducting feasibility analysis, project scoping and providing project work estimates.
• Experience with requirements development involving requirements elicitation, analysis, specification and validation.
• Experience with documenting user stories, planning and managing product backlog, planning and managing sprints, and implementing in an iterative manner.
• Hand-on experience in capturing Data Lineage and Data Mapping between Source and Target systems.
• Demonstrated experience in the facilitation of project meetings for reviews.
• Experience in reporting progress of assignment(s) on a regular basis to Project Management and raise any issues / concerns and propose mitigation strategies.
• Experience with Production Support to investigate issues and propose solutions to fix them.
• Able to resolve issues in a timely manner, provide options and recommendations.
• AZ-900/DP-900 certifications preferred.e Data Factory, Synapse & SQL