Data Architect | ERP, SQL, Power BI

AppleOne Employment Services; Oxnard (CA); On-site; USD 94,000 - 155,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401(k)

Employee stock purchase program

Profit sharing program

Paid time off

Job summary

AppleOne Employment Services is seeking a Senior Data Architect for a direct hire in Oxnard, CA. The role focuses on turning complex enterprise data into actionable insights to support strategic decisions.

You will design data warehouse architectures, ETL processes, and reporting frameworks, while integrating data from ERP/CRM systems for scalable reporting solutions. A strong Power BI, SQL, and data modeling background is required.

Qualifications

• Lead enterprise reporting, analytics, and BI initiatives.
• Design and optimize data warehouse architecture, ETL, data models.
• Develop Power BI dashboards and reporting solutions for operational and executive users.
• Integrate data across ERP, CRM, and other enterprise systems.

Responsibilities

• Lead enterprise reporting, analytics, and BI initiatives.
• Design and optimize data warehouse architecture, ETL, data models.
• Develop Power BI dashboards and reporting solutions for operational and executive users.
• Integrate data across ERP, CRM, and other enterprise systems.
• Strong collaboration with business leaders to translate requirements into data architecture.
• Ensure data quality, governance, and documentation across environments.

Skills

Power BI

SQL

Data modeling

ETL processes

Enterprise reporting

Oracle EBS

SplashBI

Microsoft Power Platform

Cloud data architecture

5+ years experience

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Systems

Bachelor’s degree in Business

MBA

Job description

Job Summary

We are seeking a Senior Data Architect for a direct hire opportunity in Oxnard, CA. This role is ideal for a data architecture, business intelligence, or data warehousing professional who enjoys turning complex enterprise data into actionable insights that support strategic business decisions.

Key Responsibilities

• Design and develop Power BI dashboards, enterprise reports, and analytics solutions for business and executive users.
• Build, enhance, and optimize data warehouse architectures, ETL processes, data models, and reporting frameworks.
• Integrate data from ERP, CRM, and operational systems to create reliable and scalable reporting solutions.
• Partner with business leaders to understand reporting needs and translate requirements into effective data architecture solutions.
• Improve data quality, governance, accessibility, performance, and documentation across enterprise data environments.
• Deliver actionable business insights that support leadership decision-making and operational improvement.

Compensation and Benefits

• Direct hire opportunity.
• Location: Oxnard, CA.
• Salary range: $94,447 to $155,413 annually.
• Comprehensive benefits package.
• Medical, dental, and vision coverage.
• Life insurance.
• HSA and FSA options.
• Paid time off and vacation.
• 401(k).
• Employee stock purchase program.
• Profit sharing program.
• Employee discounts.
• Employee snack and beverage program.

Required Qualifications and Skills

• Lead enterprise reporting, analytics, and business intelligence initiatives.
• Design and optimize data warehouse architecture, ETL processes, and data models.
• Develop Power BI dashboards and reporting solutions for operational and executive users.
• Integrate data across ERP, CRM, and other enterprise systems.
• 5+ years of experience in data architecture, business intelligence, data warehousing, or a closely related field.
• Strong experience with Power BI, Oracle EBS experience, SplashBI experience and Microsoft Power Platform.
• Advanced SQL skills and strong data modeling expertise.
• Experience building ETL processes and enterprise reporting solutions.
• Knowledge of cloud-based data architecture best practices.
• Bachelor’s degree in Computer Science, Information Systems, Business, or a related field.
• Ability to work effectively with business leaders, technical teams, and executive stakeholders.
• Strong analytical thinking, documentation skills, communication skills, and attention to data quality.
• Must be eligible to work in an ITAR-regulated environment.
• Must successfully pass a background check.

Preferred Qualifications

• MBA.
• Experience in regulated or compliance-focused environments.
• Knowledge of CMMC, NIST 800-171, and ITAR requirements.

Equal Opportunity Employer / Disabled / Protected Veterans

The Know Your Rights poster is available here: https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf

The pay transparency policy is available here: https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf

For temporary assignments lasting 13 weeks or longer, AppleOne is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required.

We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team.

AppleOne participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program. https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf

We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.