Description
You will design and maintain conceptual, logical, and physical data models to support business intelligence, analytics, and operational systems.
Responsibilities
- Collaborate with stakeholders and engineering teams to gather data requirements and translate them into effective models.
- Develop and enforce data modeling standards to ensure consistency and integrity across systems.
- Conduct data profiling and analysis to understand source systems and support accurate modeling.
- Partner with development teams and DBAs to implement models, optimize queries, and improve database performance.
- Assist in establishing data governance frameworks, including data lineage and quality metrics.
Required Skills
- 15+ years of professional experience in Data Architecture or Data Modeling.
- Bachelor’s degree in computer science, Information Systems, Data Science, or a related field.
- Proficiency in data modeling tools such as Erwin, PowerDesigner, or ER/Studio.
- Strong understanding of relational, dimensional, and NoSQL data modeling techniques.
- Experience with SQL and major RDBMS platforms including Oracle, SQL Server, PostgreSQL, or MySQL.
- Expertise in the Azure ecosystem, specifically Azure Data Lake Storage, Azure Data Factory, Synapse Analytics, Event Hub, and Kafka.
- Familiarity with data warehousing, ETL processes, data lake architectures, and real-time data processing.