Data Analyst + Bigdata + Data Modelling

Job Description

Job description

• Create and maintain conceptual logical and physical data models for databases and data warehouses
• Optimize data structures for performance scalability and reliability
• Work closely with business analysts data architects and software developers to understand data needs
• Collaborate with stakeholders to gather and analyze requirements for data related projects
• Define database structures to support business operations and analytics
• Develop and maintain data dictionaries and metadata
• Provide guidance on data storage solutions e g hive or cloud based databases
• Ensure data models align with organizational standards and governance policies
• Identify and resolve data inconsistencies and redundancy
• Document all data models and ensure they are up to date
• Develop and enforce data modeling best practices and standards
• Use data modeling tools such as Erwin or IBM Data Architect to create models
• Implement data solutions on platforms like Hadoop or Hive tables
• Analyze data models for performance bottlenecks and recommend optimizations

Required Skills and Qualifications

• Education Bachelors or Masters degree in Computer Science Information Systems Data Science or a related field
• Experience Proven experience in data modeling database design or related roles

Technical Skills

• Proficiency in data modeling tools e g Erwin IBM Data Architect
• Expertise in Big data database systems e g Hive Impala
• Expertise in Relational database systems e g Oracle
• Familiarity with ETL processes data warehousing and cloud technologie
• Knowledge Areas
• Data governance frameworks and best practices
• Advanced knowledge of normalization denormalization and schema design patterns
• Understanding of modern data architectures such as data lakes and lakehouses

Soft Skills

• Strong analytical and problem solving abilities
• Excellent communication and stakeholder management skills
• Ability to work collaboratively across teams

Preferred Qualifications

Experience with big data technologies e g Hadoop Spark

Skills

Mandatory Skills : Data Vault (ODS) Modeling, Dimensional Data Modeling, ER Studio, MS SQL Server
Good to Have Skills : ANSI-SQL