Data Modeller & Analyst
Salary: $120,000 – $145,000 per year
We are HCLTech, one of the fastest-growing large tech companies in the world and home to 219,000+ people across 54 countries, supercharging progress through industry-leading capabilities centered around Digital, Engineering and Cloud.
The driving force behind that work, our people, are diverse, creative, and passionate, raising the bar for excellence on a regular basis. We, in turn, work hard to bring out the best in them as we strive to help them find their spark and become the best version of themselves that they can be.
Are you ready to be an important part of this ever-transformational journey?
At HCLTech Australia, we value the unique perspective and contributions of all individual and we actively encourage applications from Aboriginal and Torres Strait Islander people to apply for this role.
Duration: Fixed Term Contract for 6 months
Role : Data Modeller & Analyst
Required Capabilities ·
Data Modelling
Conceptual, logical (Entity Relationship) and physical data modelling.
Data models review with both IT and business audiences, communicating how the model meets requirements of both existing projects and the overall information architecture and strategy and any relevant deficiencies and gaps.
UML modelling using all of the following:
Class diagrams
Activity diagrams
Sequence diagrams
Component and package diagrams
Analyse and translate current application and data landscapes and future business requirements into detailed logical data models.
Strong metadata management (technical and business), incorporating metadata practices into all modelling activities.
Data analysis
Analysis of source system including database structures, semi-structured and unstructured data stores.
Understanding and assessment of source system schemas; table structures and relationships, primary / foreign keys, indexing, etc.
Determining reference data domains and ranges and relationship to transactional data. ·
Data mapping and transformation
Mapping of source data elements to target models and data schemas using detailed logical data models.
Ability to work with source system SMEs to determine correct mappings, transformations and gaps.
Analysis and documentation of source to target data lineage.
Data Discovery and Data Quality Assessment
Detailed analysis of source system data structures and content to assess “fitness for purpose”. Skills,
Experience & Qualifications
Experience in data analysis and modelling against transactional and analytical systems.
Experience in the use of data modelling tools and the management of data modelling repositories and solutions.
Experience in using data profiling, using both automated tools and hand coded SQL to determine data quality metrics, constraints, etc.
Experience in the delivery of large scale, information management, information governance and analytics solutions
At least 10 years of data modelling and analysis experience.
Business communication skills.
Working knowledge of large enterprise relational database management systems comprising of traditional databases (MS SQL Server, Oracle) and cloud based platforms and solutions within AWS.
Working knowledge of data governance frameworks, processes and technologies such as data catalogues and business glossaries.
Sparx EA experience is an added advantage.
Work Experience: 10+ years with domain expertise.
Equality & Opportunity for All
Representing 165 nationalities across the globe, we pride ourselves on being an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, Aboriginal and Torres Strait Islander people or any other protected classification, in accordance with federal, state, and/or local law.
Candidate Data Privacy Notice | HCL Technologies
We are committed to respecting your privacy and for the protection of your personal data. Your personal data will be collected and processed in line with our candidate privacy notice: https://www.hcltech.com/candidate-privacy-notice. This privacy notice will help you to understand what personal data we collect about you, how we use this personal data, and what rights you have regarding your personal data. By replying to this email or submitting any personal data to HCL Tech, you acknowledge that you have read and understood the candidate privacy notice and have provided your consent to the processing of your data for recruitment purposes as described in the privacy notice”.