Enterprise Data Architect

MAIN JOB RESPONSIBILITIES / COMPETENCIES The Enterprise Data Architect is a hands-on technical role focused on building and expanding the company’s enterprise data and analytics environment. This individual will design and deliver reliable data integrations, develop cloud data warehouse solutions, and help establish an effective Power BI and Power Apps environment. The role works directly with business and IT teams to turn requirements into working solutions.

Our environment uses Oracle Fusion, Snowflake, Fivetran, and Microsoft Power Platform. Candidates do not need prior experience with every product, but demonstrated success extracting Oracle Fusion data at enterprise scale, building production data pipelines, and delivering cloud-based analytics solutions is strongly preferred. The position emphasizes hands-on development, problem-solving, and consistent delivery through Agile ways of working.

Enterprise Data Integration & Architecture
• 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.

Power BI & Microsoft Power Platform
• Build and organize Power BI work spaces 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.

Agile Delivery & Collaboration
• 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.

AI & Analytics Innovation
• 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.

Other duties as assigned.

REQUIREMENTS EDUCATION & TRAINING
• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field preferred; equivalent combination of…