Enterprise Data Architect
staar surgicalLake Forest, CA
About the role
Overview:
In this hands-on Enterprise Data Architect role, you will design and scale the company’s data and analytics landscape, integrating Oracle Fusion data into Snowflake and enterprise reporting via Power BI and Power Apps. You will own end-to-end data pipelines, data models, and BI solutions while collaborating with business and IT to translate requirements into production solutions. You will advance cloud data warehouse capabilities, governance, and Agile delivery. A focus on AI-enabled analytics and practical data access will shape decision-making.
Responsibilities:
Design, build, and support scalable data pipelines that extract Oracle Fusion data and load into an enterprise cloud data warehouse Implement bulk and incremental extraction strategies with Oracle Fusion tools; manage scheduling, throughput, monitoring, and recovery Create and maintain data models, SQL transformations, and reusable datasets for reporting and analytics Integrate additional enterprise applications and data sources as needs grow Diagnose and fix pipeline failures, data discrepancies, and performance issues; improve reliability of production integrations Expand Snowflake and Fivetran environments using transferable cloud data warehouse experience Organize Power BI workspaces and manage access, deployment, and support Develop and maintain Power BI semantic models, data connections, reports, and dashboards Develop and support Power Apps connected to enterprise data; utilize Power Automate for integrations Collaborate with business users to translate requirements into practical reporting and application solutions Own solutions from requirements to deployment and production support within an Agile delivery framework Coordinate with Finance, Accounting, Supply Chain, Manufacturing, IT to understand source systems and reporting needs Work with Sales and Marketing to integrate CRM and commercial data into reporting and analytics Apply SDLC practices, testing, version control, and documentation to solutions Partner with cross-functional teams to understand source systems and reporting needs Support AI-enabled analytics initiatives and evaluate capabilities for easier access to trusted information
Key requirements:
8–10 years of relevant experience in data architecture, data engineering, BI, or EII Experience with Fivetran and Snowflake in an Oracle Fusion-to-cloud-warehouse environment (preferred) Experience with AI-enabled analytics, chatbots, or natural-language access to Power BI or enterprise data Oracle EPM experience in financial planning, budgeting, forecasting, and reporting integrations (preferred) Accounting and Finance reporting and data integration experience (preferred) Salesforce experience in a B2B environment including sales processes and healthcare-related customer interactions (preferred) Experience with Sales and Marketing data and CRM analytics (preferred) Supply Chain or Manufacturing analytics experience (preferred) Microsoft Azure data services and Power Automate experience (preferred) collaboration with cross-functional teams strong problem-solving abilities independence and accountability in delivering production solutions Oracle Fusion data extraction (bulk and incremental) SQL programming and data modeling ETL/ELT pipeline design and monitoring
Matching similar jobs
JOB OVERVIEW
Experience level
Lead
Location
Lake Forest, CA
Occupation
Data Warehousing Specialists
Industry
Computer Systems Design Services
Posted
yesterday
Tired of running searches?
Rank the roles you'd take once, and matches like these arrive on their own.
CREATE PROFILE (opens in a new tab)