Data Analysis Lead

LeverageTek is actively seeking a Data Analyst / Manager for a 12-month contract with it’s Ottawa based customer.Work Location : RemoteKey Tasks- Collecting, documenting, and analyzing data requirements through document analysis and reverse engineering legacy ETL builds.- Designs and implements data solutions using 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.Key Qualifications- 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 refactoringSpecific 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 solutionsOther Qualifications- 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- Bilingualism in both official languages (English and French)About LeverageTek Staffing SolutionsFounded in 2003, LeverageTek provides end-to-end, cross-functional staffing solutions throughout North America. We are a trusted partner to leading private and public sector organizations and experts in talent solutions that create optimal business outcomes.Don’t let our name fool you. Our roots are in technology, but we are also a proven leader in accounting and finance, sales and marketing, human resources, supply chain, and legal talent acquisition. We offer contract and permanent staffing, executive search, talent mapping, management consultancy, and contractor payroll management.LeverageTek is an equal opportunity employer. We offer a welcoming and inclusive environment in service to one another, our customers, the candidates we represent, and the diverse communities we call home. We do all of this with kindness, empathy, and respect for each other. LeverageTek is committed to employment equity and creating a diverse and inclusive workplace. We welcome applications from all qualified individuals regardless of race, religion, gender, national origin, age, disability, and marital status.Accessibility accommodations are available upon request