Data Architect
Job Summary
What you'll do
- Design and maintain enterprise data architectures, data models, semantic layers, and reusable data products.
- Lead the implementation of Microsoft Fabric solutions, including Data Warehouse, Lakehouse, OneLake, Data Factory, and Power BI.
- Design enterprise-scale cloud data warehouse and lakehouse architectures that support reporting, analytics, and AI initiatives.
- Build and optimize ETL/ELT pipelines using modern data engineering and ingestion patterns.
- Integrate data from Oracle, SQL Server, SAP, APIs, cloud applications, and file-based sources.
- Design and support data replication and Change Data Capture (CDC) solutions.
- Establish and govern data quality, security, metadata, lineage, and access management standards.
- Develop semantic models and curated datasets to enable trusted enterprise reporting and self-service analytics.
- Optimize data platforms for performance, scalability, reliability, and cost efficiency.
- Create solution designs, technical specifications, and implementation roadmaps while partnering with business, IT, Quality, and Data Governance teams.
Qualifications and need-to-know
- Bachelor's degree in Computer Science or a related field.
- 5+ years of experience in Data Architecture, Data Engineering, Data Warehousing, Business Intelligence, or Analytics.
- Demonstrated expertise in Microsoft Fabric, including Data Warehouse, Lakehouse, OneLake, and Data Factory.
- Extensive experience with Power BI, including semantic modeling and enterprise reporting.
- Advanced SQL, dimensional modeling, and data warehouse design skills.
- Experience designing and supporting enterprise-scale cloud data platforms.
- Experience with ETL/ELT development, data integration, and CDC technologies such as Oracle GoldenGate.
- Experience working with Oracle, SQL Server, SAP, APIs, and other enterprise data sources.
- Knowledge of Azure, Databricks, Python, Spark, and modern cloud data technologies.
- Experience implementing data governance, security, data quality, and data lineage practices.
- Experience working in a regulated environment; Life Sciences, Pharmaceutical, or GxP experience preferred.
- Experience with Git, CI/CD, and DevOps/DataOps practices.
- Strong communication and stakeholder management skills.