Sr Data Architect

Johnson Service Group is looking for a Sr Data Architect with 5-10 years of experience in architecting and implementing Business Intelligence and data warehouse platforms. This is a Direct job in Oxnard, CA for an Aerospace company.

Salary: $157K DOE

SUMMARY

Responsible for designing, developing and maintaining data business solutions. Collaborates with key stakeholders throughout the organization to determine what reporting and analytics are needed to achieve strategic business goals. Provides system support and troubleshooting expertise as needed to analyze data solutions for validity and accuracy. Reviews and recommendations for improvements to existing data architecture.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.

Designs, develops and maintains Power platform dashboards (or equivalent) for executive management team to achieve strategic business objectives.
Designs, develops, and maintains all types of reporting derived from ERP, CRM, Operation systems to support the business.
Collaborates with key stakeholders throughout the organization to gather and fully understand reporting and other data related requirements and needs.
Generate monthly insights and collaborate with the management team on how to build a stronger narrative using data.
Provides consultative services to key stakeholders to help them understand data analysis results and dashboards.
Review existing data architecture and recommend improvement opportunities.
Responsible for mapping key Business System data entities to SplashBI data warehouse for reporting and data analytics.
Identifies and understands root causes of existing data problems and proposes innovative solutions.
Develops architecture documentation and functional specifications for data flow analysis.
Provides maintenance and regulatory support in data solutions.
Will be required to perform other job duties as requested, directed or assigned.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

REQUIRED5-10 years of experience in architecting and implementing Business Intelligence and data warehouse platforms.
Bachelor’s Degree (B.A. or B.S.) from four-year college or university.
Knowledge of industry best practices around data architecture in cloud-based solutions.
Comprehensive understanding of data warehousing and data transformation (extract, transform and load) processes and supporting technologies such as PowerBI, SplashBI, Oracle and MS SQL.
Microsoft Power Platform (Power Apps, Power Automate, etc.)
Microsoft Teams
Advanced Microsoft Office – Excel, Word, Power Point
SQL
Microsoft SharePoint 365
Oracle EBS
Working knowledge of CMMC / NIST 800-171 controls
Working knowledge of ITAR controls

PREFERREDM.B.A. from an accredited program
SplashBI familiarity

SKILLS AND COMPENTENCIESGood command of the English language, both written and spoken.
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
Ability to write reports, business correspondence, and procedure manuals.
Ability to effectively present information and respond to questions from groups of managers, customers, employees, and the general public.
Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume.
Ability to apply concepts of basic algebra and geometry.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Ability to perform essential tasks, including primarily sitting (often >75% of the day), with occasional standing, walking (around office, to printer, etc.) and sometimes climbing stairs.
Occasional bending, stooping, reaching (overhead, low), twisting, and maintaining stationary positions.
Vision, hearing, and manual dexterity sufficient to perform necessary tasks such as using a mouse, handling document, operation phones and other office machinery.
Ability to occasionally lift or carry 10-35 pounds (files, boxes, equipment, etc).

BENEFITS:

Vacation. Medical Vision, Dental, ESPP, Profit share, Life Insurance, 401K

** Johnson Service Group (JSG) is an Equal Opportunity Employer. JSG provides equal employment opportunities to all applicants and employees without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, marital status, protected veteran status, or any other characteristic protected by law.

#D800
Skills:
Aerospace and Defense, Analysis Skills, Best Practices, Business Intelligence, Business Solutions, Business Support, Business Writing, Cloud Architecture, Customer Relationship Management (CRM) Systems, Data Analysis, Data Warehousing, DataArchitect Data Modeling Tool, Database Extract Transform and Load (ETL), Documentation, ERP (Enterprise Resource Planning), English Language, Government Regulations, Identify Issues, Lift/Move 35 Pounds, Manual Dexterity, Microsoft Excel, Microsoft Office, Microsoft PowerPoint, Microsoft Product Family, Microsoft SQL Server, Microsoft SharePoint, Microsoft Word, Office Equipment, Operational Support, Oracle, Oracle Database, Physical Demands, Power BI, Presentation/Verbal Skills, Printers, Regulations, Reporting Dashboards, Reporting Skills, Root Cause Analysis, SQL (Structured Query Language), Systems Administration/Management, Technical Support, U.S. National Institute of Standards and Technology (NIST), Writing Skills

Johnson Service Group

At JSG, We Understand People

It is our mission to empower people, help our clients reach their goals, and hire motivated individuals.

Since our start in 1984, we’ve worked hard to establish our present position as the most effective cross-industry staffing and consulting solution available.

Headquartered in Chicago, IL with local offices throughout the United States and Canada, JSG proudly serves a diverse range of industries with the right solutions to help clients reach their company goals. Our client-centric approach enables us to create personalized solutions for businesses in need of top-tier talent. Our dedication doesn’t stop at our clients. We strive to connect candidates with opportunities that match their skills and goals. More than just a go-between, we are a dependable bridge, uniting top talent with suitable opportunities, facilitating shared opportunities and growth.

Company Size:
1,000 to 1,499 employees

Industry:
Staffing/Employment Agencies

1984

Website:
https://www.jsginc.com/