Description

You will design and implement complex data architectures across cloud, big data, and on-premise environments.

Responsibilities

• Design normalized, denormalized, relational, dimensional, star, and snowflake schemas for large-scale programs involving over 100 entities.
• Collaborate daily with product managers, project managers, business users, developers, DBAs, and Data Governance teams to translate requirements into technical solutions.
• Implement Bill Inmon and Ralph Kimball methodologies to build and maintain data warehouses.
• Execute data modeling using Data Vault 2.0 methodologies within cloud data warehouse environments.
• Manage end-to-end data lifecycle processes including profiling, mapping, lineage, and master data management.

Required Skills

• 7+ years of experience in Data Modeling and Data Analysis.
• Expertise in Snowflake, Hive, S3, and Trino.
• Proficiency with Oracle, SQL Server, Redshift, or DB2.
• Hands-on experience with Data Lakehouse concepts and Big Data tools like Hue.
• Proven ability to use modeling tools such as Erwin, ER/Studio, or Toad Data Modeler.
• Deep understanding of Data Warehousing, Data Profiling, MDM, Data Quality, and Data Governance.
• Experience managing complex data mapping and data dictionary development.

Preferred Skills

• Financial domain knowledge.

Key Skills

Education

Any Gradute