Job description
The following responsibilities are associated with the “Statement of Work” but are not limited to:
Primary Responsibilities
- Collecting, documenting, and analyzing information/data requirements from stakeholders
- Collaborating with Data Architects, Data Engineers and Data Governance Analysts on the analysis and solution
- Developing a plan/approach for data quality analysis, and on-going data quality monitoring.
- Developing Source to Target Mapping (STM)
- ETL Design
- Creating data flow diagrams and communicating requirements, issues and options to various stakeholders, data architects and data engineers
- Creating reviews and validating conceptual, logical, and physical data models of applications to determine compatibility and fit with architectural principles and optimal solution design.
- Designing, creating and optimizing data models (in collaboration with data architects) and deriving conversion and migration methods for existing data.
- Maintaining an enterprise view of data across various systems. Working collaboratively with information governance analysts to ensure that data models and structures are compliant with governance standards.
Specific Project Requirements
- 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 of Oracle Enterprise Data Quality (OEDQ) tool is required.
- Strong knowledge and demonstrated experience in Data Quality Analysis is required.
- Knowledge and demonstrated experience of IBM Infosphere – Information Analyzer is an asset.
- Understand systems data elements, and existing data structures.
- Validate source files for completeness and quality of format, content location and values.
- Identify qualified/approved records for system upload.
- Identify and resolve discrepancies (format, content, values).
- Deliver data analysis reports that clearly articulate the data quality dimensions.
- Generate status reports to stakeholders on a weekly basis, and liaison with Business Lead on data analysis results and reporting.
Skills
Top Skills Required: Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
- 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 design, metadata management and master data management, business intelligence and database administration.
- Experience with reverse engineering the source to target mapping to gain data insights
Other Skills Required:
- Experience with Azure Data Platform technologies or other public cloud offerings
- Experience with IBM: Data Manager, InfoSphere DataStage
- Experience with Spark SQL
- Programming experience: SQL, R, Python
- Experience with Power BI report development
- Understanding of Denodo platform
- Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills.
- Ability to understand and interpret requirements and design documents
- Ability to write and maintain documentation
Assets:
- Experience working in an Agile environment/team
- Bilingualism in both official languages (English and French)
Maplesoft Group prides itself on its distinct corporate culture and recognizes that success is a direct reflection of our most valuable asset - our people. Therefore, attitude and ambition are key personality traits we seek out, along with skill and aptitude, in potential employees.
Maplesoft Group is committed to having a diverse, representative workforce and continuing to build an inclusive environment. We encourage applications from all qualified individuals. Maplesoft Group is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants irrespective of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans’ status, Aboriginal peoples or any other legally protected factors.
All employment decisions are made based on business needs, job requirements, and individual qualifications.
We are committed to developing inclusive, barrier-free recruitment and selection processes, and a work environment that supports our diverse workforce. Please let us know if you require accommodations at any stage of the recruitment process. We can be reached at Maplesoft Info at [email protected].
We thank you for your interest in Maplesoft Group and wish to advise you, that only candidates under consideration will be contacted.
About Maplesoft Group
CEO: Jody Campeau
Revenue: $5 to $25 million (USD)
Size: 51 to 200 Employees
Type: Company - Private
Website: www.maplesoftgroup.com
Year Founded: 1996