Data Migration Lead

OPENTEXT – THE INFORMATION COMPANY

As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management.

The Opportunity:

OpenText is looking for a candidate with strong data analysis and SQL skills to be part of a dynamic team with a focus on projects relating to data migration.

You will be the lead on data migration projects that deal with legacy data from acquired companies (M&A) into OpenText systems, ensuring business requirements are met and business processes are aligned.

Your role is to be the expert in extracting, analyzing and presenting relevant data points from a variety of sources to the business partners and IT leaders. You will be responsible to help design the data layer as part of migration projects, lead the offshore SQL developers in scripting out the tables for various migration objects and provide data cross-reference to downstream systems that consume migrated data.

Your expertise should be on the ERP related backend data – master data objects including Customer, Contacts, Vendor, Materials and its multiple attributes, transaction objects such as open orders, receivables, payables etc. An understanding of the flow and impact of master data objects to downstream systems and other transactional data objects.

You should be able to work with cross functional business as well as IT teams and be able to share the data analysis across these teams.

You Are Great At:

• Take ownership of design & development of all data extract, analysis and presentation activities Working with the project team to ensure that all ongoing data transformation, de-duplication, extraction and load functions once ready for production deployment are documented in detailed data lineage models
• Work with diverse backend systems such as Oracle ERP, Netsuite, Salesforce, support/ticketing systems to extract and map data in a SQL staging data layer.
• Own/execute process to de-duplicate and fuzzy match data
• Ability to run, recommend different extraction tools such as DBamp, Suiteanalytics to effectively and efficiently.
• Develop best practice, processes, and standards for effectively carrying out data migration activities.
• Help prepare data migration plans including migration risk, milestones, quality and business sign-off details.
• Understanding of data integrations, specifically how master data from SAP can impact downstream systems.
• Building and maintaining cross-functional relationships, including aligning opinions and approaches across disparate teams.
• Assisting with designing business processes to be aligned to the master data
• Ensuring data accuracy, integrity, and completeness.

What It Takes:

• Substantial experience working with databases, including T-SQL
• ETL tools capable of data cleansing and de-duplication
• Ability to engage clearly with client representatives to explain data migration concepts; support deep dive discussions to get answers for required data objects
• Passionate about understanding complex data and problem solving
• Demonstratable experience in migrating from other ERP systems to SAP S4 is a definite asset
• General understanding of project lifecycle & development
• Excellent collaboration & presentation skills
• Bachelor’s Degree in Computer Science, Engineering, or a related field or a combination of education and equivalent experience
• 8+ years of providing data solutions in a similar setting.
• Strong verbal, written and interpersonal communication skills

OpenText’s efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws. Should you require accommodations during the selection process, please contact accommodationrequests@opentext.com.