Teamcenter Reporting and Analytics (TCRA) Lead - Remote
Posted 1 week ago by Square One Resources
Negotiable
Inside
Remote
Malmesbury, United Kingdom
Summary: The TCRA Reporting Lead will be responsible for developing, modifying, and running reports on product and engineering data within a Teamcenter database to facilitate data migration activities. This role requires expertise in Teamcenter Reporting and Analytics (TcRA) to assess and profile data, ensuring quality and consistency throughout the migration process. The position is a contract role lasting 2-3 months, with the possibility of extension. The role is remote, allowing for flexible work arrangements.
Key Responsibilities:
- Develop, modify, and run reports on product and engineering data stored within a Teamcenter database.
- Utilize TCRA to run reports for data profiling and gap analysis between TC12 and TC2412 data models.
- Define TC2412 data model and produce data mapping templates for migration.
- Execute profiling jobs within TCRA and analyze results for data quality and structure.
- Develop a data cleansing and transformation plan based on profiling results.
- Review and analyze profiling reports post-migration to identify data issues.
Key Skills:
- Expertise in Teamcenter Reporting and Analytics (TcRA).
- Strong understanding of data profiling and migration processes.
- Ability to define data models and mapping templates.
- Experience in data quality assessment and cleansing.
- Analytical skills to review and interpret profiling reports.
Salary (Rate): £700 per day
City: Malmesbury
Country: United Kingdom
Working Arrangements: remote
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
Job Title: TCRA Reporting Lead
Location: Remote
Salary/Rate: £600-700 Per Day
Start Date: 04/08/25
Job Type: Inside IR35 Contract (2-3 months initial + possible extension)
Company Introduction
We have an exciting opportunity now available with one of our sector-leading consultancy clients! They are currently looking for a TCRA Reporting Lead to join their team for an initial 2 or 3 month contract.
Job Responsibilities/Objectives
You will be responsible for developing, modifying and running reports on product and engineering data stored within a Teamcenter database and providing the report to enable decisions on data migration activities.
The resource skill we need is someone who has Teamcenter Reporting and Analytics (TcRA) knowledge
Job Description:
Data Profiling
To use TCRA to run reports on the data to understand the gap between the TC12 and TC2412 data models, which will be used for the migration of the data. We will define the TC2412 data model and produce the data mapping templates required to map the legacy TC12 and/or other partner systems to the new TC2412 model.
Use TCRA generate an assessment of the data either by utilising existing reporting capability or generating a new report. This will be run against the existing Teamcenter 12 data. The below is not exhaustive and will be refined but gives an indicative understanding.
Profiling Configuration within TCRA:
- Data Selection: Specify the tables or files within the source databases that need to be profiled. This might involve using selection criteria to include or exclude specific data subsets.
- Profiling Rules: Define the profiling rules to be applied. This includes specifying the types of analysis to be performed, such as:
- Data Type Detection: Automatically identify the data type of each column (e.g., integer, string, date).
- Data Quality Checks: Identify potential data quality issues, such as null values, duplicates, inconsistencies, and outliers.
- Data Distribution Analysis: Analyse the distribution of values within each column (e.g., histograms, frequency counts).
- Data Volume Estimation: Estimate the size and volume of the data to be migrated.
- Data Lineage Tracking (If applicable): Track the origin and transformation of data elements throughout the migration process.
- Custom Rules (Optional): May be need for the creation of custom profiling rules to address specific data characteristics or business requirements.
Execution and Review of Profiling Results:
- Run the Profiling Job: Execute the profiling job within TCRA. This will analyse the selected data according to the defined rules.
- Review and Analysis: Review the generated profiling reports. These reports should provide insights into the object type, linked objects, status, data quality, volume and structure (list is an example and not complete). Identify any potential data issues or inconsistencies that need to be addressed before the ETL process.
- Data Cleansing/Transformation Plan: Based on the profiling results, develop a plan for data cleansing and transformation to address any identified issues. This might involve data validation, data scrubbing, or data enrichment.
Post Migration - Execution and Review of Profiling Results:
- Run the Profiling Job: Execute the profiling job within TCRA. This will analyse the migrated data according to the defined rules.
- Review and Analysis: Review the generated profiling reports. These reports should provide insights into the data quality, volume, structure and comparison of the pre and post migration to identify any potential data issues or inconsistencies.
If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.
Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.
