Description
You will design and maintain the data structures that power our business intelligence, analytics, and operational systems.
Responsibilities
- Design conceptual, logical, and physical data models to support enterprise-wide analytics and operations.
- Collaborate with stakeholders and engineering teams to translate business requirements into scalable data models.
- Develop and enforce data modeling standards to ensure consistency and integrity across all systems.
- Conduct data profiling and analysis to understand source systems and support accurate modeling efforts.
- Manage data dictionaries, entity relationship diagrams (ERDs), and metadata repositories.
- Partner with DBAs and developers 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.
- Expertise in Azure ecosystem, including Azure Data Lake Storage, Azure Data Factory, Synapse Analytics, and Event Hub.
- Proficiency with Kafka and knowledge of structured streaming and real-time data processing.
- Advanced experience with data modeling tools such as Erwin, PowerDesigner, or ER/Studio.
- Strong command of relational, dimensional, and NoSQL data modeling techniques.
- Extensive experience with SQL and major RDBMS like Oracle, SQL Server, PostgreSQL, or MySQL.
- Deep understanding of data warehousing, ETL processes, and data lake architectures.