Data Architect

About the role

We are looking for a Data Architect to lead the design, development, and optimization of our data pipelines, warehouse structures, and analytics solutions. The role will be central to enabling business intelligence and data‑driven decision making across the organization.

Key responsibilities

• Extract and integrate data from Oracle Fusion Database, understanding its table structures.
• Design and implement efficient ingestion pipelines using Azure Data Factory.
• Maintain data quality, consistency, and security throughout the ETL process.
• Develop and sustain a robust star schema in SQL Server Analysis Services (SSAS) and optimize models for performance.
• Translate business requirements into technical data models and maintain scalable database tables.
• Create interactive Power BI dashboards, paginated reports, and support self‑service BI initiatives.
• Collaborate with IT, analysts, and stakeholders to align data solutions with organizational goals.
• Establish best practices for data governance, documentation, and architecture standards.

Required profile

• 5–7 years of experience in data architecture, integration, and BI solutions.
• At least 3 years of hands‑on experience with Oracle Fusion Database and data‑warehousing integrations.
• Proven ability to design star schemas, dimensional models, and scalable databases.
• Strong communication, collaboration, and problem‑solving skills.

Required skills

• Oracle Fusion Database
• Azure Data Factory
• SQL Server Analysis Services (SSAS)
• Power BI (including paginated reports)
• SQL and performance tuning
• Azure Synapse Analytics (preferred)