Description
You will design and maintain the data structures that power business intelligence, analytics, and operational systems.
This role is remote.
Responsibilities
- Design conceptual, logical, and physical data models for enterprise-wide analytics and operations.
- Translate business requirements into scalable data models by collaborating with stakeholders and engineering teams.
- 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.
- Partner with DBAs and developers to implement models, optimize queries, and improve database performance.
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 the Azure ecosystem: Azure Data Lake Storage, Azure Data Factory, Synapse Analytics, and Event Hub.
- Proficiency with Kafka, including 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.
Preferred Skills
- Deep understanding of data warehousing, ETL processes, and data lake architectures.
- Experience establishing data governance frameworks, including data lineage and quality metrics.