Strategic Data Architect & Enterprise BI Leader

PTI Technologies Inc.; Oxnard (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

PTI Technologies Inc. in Oxnard, CA seeks a Data BI Architect to design, develop and maintain data business solutions, partnering with stakeholders to define reporting and analytics that drive strategic goals.

The role includes mapping data entities to SplashBI data warehouse and delivering monthly insights. You will provide consultative data analysis, review existing data architecture and implement improvements while ensuring regulatory compliance and robust data governance.

Qualifications

• Experience in architecting and implementing BI and data warehouse platforms.
• Knowledge of cloud-based data architecture best practices.
• Proficiency with Power BI, SplashBI, Oracle, and MS SQL stack.

Responsibilities

• Designs, develops and maintains Power platform dashboards for executive management.
• Develops and maintains reporting from ERP/CRM/Operations systems.
• Collaborates with stakeholders to gather data reporting requirements.
• Generates monthly insights and builds narratives using data.
• Provides consultative data analysis and dashboard guidance.
• Reviews data architecture and proposes improvements.
• Maps Business System data entities to SplashBI data warehouse for reporting and analytics.
• Identifies root causes of data issues and proposes solutions.
• Develops data flow architecture documentation and specifications.
• Provides maintenance and regulatory data solution support.

Education

Bachelor's Degree (B.A. or B.S.) from four-year college or university

MBA preferred

Tools

Power Platform (Power Apps, Power Automate)

SplashBI familiarity

Microsoft Teams

Excel

Word

PowerPoint

SQL

SharePoint 365

Oracle EBS

CMMC / NIST 800-171 controls

ITAR controls

Job description

PTI Technologies Inc. in Oxnard, CA seeks a Data BI Architect to design, develop and maintain data business solutions, partnering with stakeholders to define reporting and analytics that drive strategic goals.

The role includes mapping data entities to SplashBI data warehouse and delivering monthly insights. You will provide consultative data analysis, review existing data architecture and implement improvements while ensuring regulatory compliance and robust data governance.