Senior BI & Data Warehouse Architect (PowerBI)

JSG (Johnson Service Group, Inc.); Oxnard (CA); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

Vacation

Medical

Vision

Dental

ESPP

Profit share

Life Insurance

401K

Job summary

Johnson Service Group is seeking a Senior Data Architect in Oxnard, California, to design, implement and maintain BI and data warehouse platforms for an aerospace client. You will collaborate with stakeholders to define reporting needs, build executive dashboards, and ensure data accuracy across ERP/CRM systems.

The role emphasizes mapping data entities to SplashBI data warehouse, developing architecture documentation, and providing regulatory compliance support (ITAR, CMMC/NIST 800-171).

Qualifications

• 5-10 years of BI/data warehouse architecture and implementation experience.
• Bachelor’s Degree (B.A. or B.S.) from a four-year college or university.
• Cloud-based data architecture knowledge and best practices.
• Experience with PowerBI, SplashBI, Oracle and MS SQL.
• Familiarity with ITAR and CMMC/NIST 800-171 controls.
• Strong communication and stakeholder collaboration skills.

Responsibilities

• Designs, develops and maintains data solutions for executives.
• Builds Power BI dashboards and reporting from ERP/CRM systems.
• Gathers requirements from stakeholders and translates into data solutions.
• Maps data entities to SplashBI data warehouse for reporting.
• Identifies data issues and proposes innovative improvements.
• Documents architecture and data flow specifications.
• Provides maintenance and regulatory support for data platforms.

Skills

BI architecture

Data warehousing

PowerBI

SplashBI

Oracle

MS SQL

Cloud architecture

ITAR/NIST 800-171

SQL

SharePoint 365

Education

Bachelor’s degree

MBA preferred

Tools

PowerBI

SplashBI

Oracle

MS SQL

SharePoint 365

Job description

Johnson Service Group is seeking a Senior Data Architect in Oxnard, California, to design, implement and maintain BI and data warehouse platforms for an aerospace client. You will collaborate with stakeholders to define reporting needs, build executive dashboards, and ensure data accuracy across ERP/CRM systems.

The role emphasizes mapping data entities to SplashBI data warehouse, developing architecture documentation, and providing regulatory compliance support (ITAR, CMMC/NIST 800-171).