Enterprise Data Architect
$160,000 per year
Apply (opens in a new tab)Enterprise Data Architect
Posted 3 days ago
SENIORITY
Lead
SALARY
$160,000 per year
About the role
- Design, build, and support scalable data pipelines that extract large volumes of data from Oracle Fusion Cloud Applications and load them into an enterprise cloud data warehouse.
- Implement bulk and incremental extraction strategies, including appropriate Oracle Fusion extraction tools and methods; address scheduling, throughput, monitoring, and recovery.
- Build and maintain data models, SQL transformations, and reusable datasets for enterprise reporting and analytics.
- Integrate additional enterprise applications and data sources as business needs expand.
- Diagnose and resolve pipeline failures, data discrepancies, and performance issues; improve reliability of production integrations.
- Help expand the existing Snowflake and Fivetran environment, applying transferable experience from comparable cloud data warehouse and ETL/ELT platforms.
- Build and organize Power BI workspaces for development, testing, and production, including access, deployment, and ongoing support.
- Develop and maintain Power BI semantic models, data connections, reports, and dashboards that are accurate, efficient, and easy to use.
- Develop and support Microsoft Power Apps connected to enterprise data and business processes.
- Use Power Automate and other integration capabilities where appropriate to support applications and reporting.
- Work directly with business users to translate requirements into practical reporting and application solutions.
- Own assigned solutions from requirements and design through development, testing, deployment, and production support.
- Work within an Agile delivery approach, participating in stand-ups and reviews, managing priorities, and delivering improvements in manageable increments.
- Coordinate with stakeholders to define deliverables, resolve blockers, and communicate progress and tradeoffs.
- Apply sound software development life cycle (SDLC) practices, including testing, version control, and documentation appropriate to the solution.
- Partner with Finance, Accounting, Supply Chain, Manufacturing, and IT teams to understand source systems and reporting needs.
- Work with Sales and Marketing teams as needed to integrate CRM and commercial data into enterprise reporting and analytics.
- Support practical AI-enabled analytics initiatives, including conversational interfaces or chatbots that help users query Power BI content or enterprise data sources.
- Evaluate new capabilities that make trusted business information easier to access and use.
- Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field preferred; equivalent combination of education/experience..EXPERIENCE
- Typically 8-10 years of relevant experience in data architecture, data engineering, business intelligence, or enterprise application integration.
- Fivetran and Snowflake experience, particularly in an Oracle Fusion-to-cloud-data-warehouse environment.
- Experience with AI-enabled analytics, chatbots, or natural-language access to Power BI or enterprise data sources.
- Oracle EPM experience, particularly financial planning, budgeting, forecasting, and reporting integrations.
- Accounting and Finance reporting and data integration experience.
- Salesforce experience in a customer-facing B2B commercial environment, including sales processes and relationships with physicians, healthcare providers, or other business customers.
- Experience with Sales and Marketing data, including customer and account information, sales pipelines, commercial performance, and marketing reporting.
- Supply Chain or Manufacturing experience, including inventory, planning, production, or operational analytics.
- Microsoft Azure data services and Power Automate experience. SKILLS
- Demonstrated hands-on experience extracting Oracle Fusion Cloud Applications data at enterprise scale-not solely running individual reports or ad hoc queries-including bulk and incremental loads into downstream platforms.
- Understanding of Oracle Fusion data extraction methods, such as BICC or comparable supported bulk extraction approaches, and their operational constraints.
- Experience designing, developing, and supporting automated production ETL/ELT pipelines, including monitoring, error handling, and performance tuning.
- Hands-on cloud data warehousing experience with Snowflake or a comparable platform (such as Azure Synapse, Databricks, or BigQuery).
- Strong SQL, data modeling, transformation, and troubleshooting skills.
- Hands-on experience structuring and administering Power BI workspaces, semantic models, access, and deployment processes.
- Proficiency developing Microsoft Power Apps and connecting them to business data sources.
- Practical experience with Agile delivery, including stand-ups, reviews, backlog priorities, and incremental releases; working knowledge of SDLC.
- Ability to work independently with business stakeholders and deliver maintainable production solutions. Pay range is $160K - $200K - Final compensation/salary will be dependent on experienceSTAAR Surgical is an Equal Opportunity/Affirmative Action employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran or disability status, or any other characteristic protected by law. #USA
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
