Do your areas of expertise include dimensional and relational data modeling, data quality, SQL programming, ETL development, metadata management and master data management?Is data lifecycle management second nature?Is your expertise in JSON, XML, and Databricks Parquet data structures and transformations going underutilized?If so, our Ottawa based client has a contract opportunity to consider... The position at hand is a Senior Data Analyst who will contribute to the detailed data analysis and design of a MDM solution.AdvantagesLong term contract opportunityPrestigious clientProviding strategic guidance. Responsibilities- Collecting, documenting, and analyzing MDM data requirements- Data profiling/analysis and data querying- Data cleansing, data transformation- Documenting/mapping business processes, SOPs- Building crosswalks and mapping tables for reference data- Analyzing source systems to find discrepancies/collisions for reference data- Working with team members to provide data analysis and design leadership and communicate about deliverables, schedule, possible risks, and appropriate contingencies- Working closely and collaboratively with management, stakeholders, and staff to optimize the overall MDM deliveryQualifications- Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.- Knowledge and demonstrated experience in data analysis and profiling, working with multiple data sources and stakeholder groups including end-user/business teams.- Demonstrated experience in data quality analysis and experience with reverse engineering the source to target mapping to gain data insights- 10+ years of broad experience in IM/IT solution design and delivery, including working knowledgewith infrastructure, database platform, middleware, and applications.- Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains: dimensional and relational data modeling, data quality, SQL programming, ETL development, metadata management and master data management, businessintelligence and database administration.SummarySenior Data Analyst who will contribute to the detailed data analysis and design of a MDM solution.Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to firstname.lastname@example.org to ensure their ability to fully participate in the interview process.