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