Senior Data Architect — BI & Data Warehouse Leader

PTI Technologies

Oxnard (CA)

On-site

USD 110,000 - 170,000

Full time

10 days ago

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

PTI Technologies is seeking an experienced BI Architect in California to design, develop, and maintain data solutions that advance strategic goals. You will collaborate with stakeholders across ERP, CRM, and operation systems to deliver comprehensive reporting and analytics.

Responsibilities include building executive dashboards with Power Platform, offering data-driven insights, mapping data entities to the SplashBI warehouse, and ensuring data accuracy while addressing regulatory and

Qualifications

5-10 years' experience in architecting and implementing BI and data warehouse platforms.
Knowledge of cloud-based data architecture best practices.
Comprehensive understanding of ETL, data transformation (ETL/ELT) and supporting technologies such as PowerBI, SplashBI, Oracle and MS SQL.

Responsibilities

Designs, develops and maintains Power platform dashboards for executive management.
Develops reporting from ERP, CRM, and operations systems to support the business.
Collaborates with stakeholders to gather reporting requirements and data needs.
Generates monthly insights and helps build a stronger data narrative for management.
Provides consultative services to help stakeholders understand data analyses and dashboards.
Reviews data architecture and recommends improvements.
Maps Business System data entities to SplashBI data warehouse for reporting.
Identifies root causes of data problems and proposes innovative solutions.
Creates architecture documentation and data flow specifications.
Provides maintenance and regulatory support for data solutions.