Responsibilities:

- Participate in requirements definition, analysis and the design of logical and physical data models for Dimensional Data Model, NoSQL or Graph Data Model

- Leading data discovery discussions with Business in JAD sessions and map the business requirements to logical and physical data modeling solutions.

- Conduct data model reviews with project team members

- Capture technical metadata through data modeling tools

- Ensure database designs efficiently support BI and end user requirements

- Drive continual improvement and enhancement of existing systems.

- Collaborate with ETL/Data Engineering teams to create data process pipelines for data ingestion and transformation.

- Collaborate with Data Architects for data model management, documentation, and version control.

- Maintain expertise and proficiency in the various application areas

- Maintain current knowledge of industry trends and standards

Required Skills

- Strong data analysis and data profiling skills

- Strong Conceptual, Logical and Physical data modeling for VLDB Data warehouse and Graph DB

- Hands on experience with modeling tool such as ERWIN or another industry standard tool

- Fluent in both normalized and dimensional model disciplines and techniques

- Minimum of 3 years' experience in Oracle Database

- Hands experience with Oracle SQL, PL/SQL, or Cypher

- Exposure to Databricks Spark, Delta Technologies, Informatica ETL or other industry leading tools

- Good knowledge or experience with AWS Redshift and Graph DB design and management.

- Working Knowledge on AWS Cloud technologies, mainly on the services of VPC, EC2, S3, DMS and Glue/Azure/GCP

- Bachelor's degree in software engineering, computer science or information systems (or equivalent experience)

- Excellent verbal and written communication skill including the ability to describe complex technical concepts in relatable terms.

- Ability to manage and prioritize multiple workstreams and confidence in making decisions about how to prioritize work efforts

- Data-driven mentality. Self-motivated, responsible, conscientious, and detail oriented

- Effective oral and written communication skills

- Ability to learn and maintain knowledge of multiple application areas

- Ability to work independently and in conjunction with a team

- Understanding of industry best practices pertaining to Quality Assurance concepts and procedures

Education/Experience Level:

- Bachelor's degree in Computer Science, Engineering, or relevant fields with 3+ years of experience as a Data and Solution Architect supporting Enterprise Data and Integration Applications or similar role for large scale enterprise solutions.

- 3+ years of experience in Big Data Infrastructure and tuning experience in Lakehouse Data Ecosystem including Data Lake, Data Warehouses, and Graph DB

- AWS Solutions Architect Professional Level certifications

- Extensive experience in data analysis on critical enterprise systems like SAP, E1, Mainframe ERP, SFDC, Adobe Platform and eCommerce system