Job Overview :We are seeking a highly skilled Data Architecture Specialist to join our team. The ideal candidate will have over 12 years of experience in designing and optimizing data models across various environments using leading platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse.
- Core Technical Skills & Qualifications :
- Strong expertise in database design and SQL, including DDL, DML, and DCL.
- Deep understanding of RDBMS platforms, including SQL Server, Oracle, PostgreSQL, and MySQL.
- Experience with cloud databases, including Azure Synapse, Snowflake, and Amazon Redshift.
- Knowledge of NoSQL systems, including MongoDB and Cassandra, and modeling for semi-structured data, including JSON and Parquet.
- Data Modeling Tools & Techniques :
- Proficiency in tools such as Lucidchart, Erwin, and Toad Data Modeler.
- Strong command of conceptual, logical, and physical data modeling.
- Ability to model for OLTP systems and OLAP environments.
- Familiarity with dimensional modeling, including star and snowflake schemas.
- ETL / Data Integration :
- Understanding of ETL pipelines and data ingestion processes.
- Collaboration experience with ETL developers to align data flows with models.
- Familiarity with tools, including Azure Data Factory, Informatica, Talend, dbt, and SSIS.
- Metadata, Data Governance & Lineage :
- Experience defining data dictionaries, business glossaries, and metadata repositories.
- Awareness of data quality, governance, and master data management principles.
- Understanding of data lineage and impact analysis.
- Performance Optimization :
- Knowledge of indexing, partitioning, normalization, and denormalization.
- Ability to optimize query performance through model design and database tuning.
- Soft Skills :
- Excellent communication skills, able to explain technical models to non-technical stakeholders.
- Collaboration with data engineers, analysts, and architects.
- Strong documentation and attention to detail.
- Ability to work in agile environments with iterative delivery.
- Education :
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.