Demo

Datawarehouse Solutions Architect

DirectedLINK
Cypress, CA Full Time
POSTED ON 4/21/2025
AVAILABLE BEFORE 5/16/2025

Job Description

Job Description

TITLE : SOLUTIONS ARCHITECT

TYPE : PERMANENT

LOCATION : CYPRESS, CA

WORK SCHEDULE : HYBRID

INDUSTRY : MANUFACTURING AND DISTRIBUTION; PUBLICLY TRADED

COMPENSATION : $125,000 - $160,000 BONUS

  • CLIENT IS NOT OFFERING SPONSORSHIP FOR THIS POSITION

COMPANY INFO

Our client is a Fortune 500 company. They are a leader in their industry, manufacturing and distributing discrete goods for the building industry.

  • Great company culture with emphasis on collaboration and team building
  • Growth opportunity
  • Minimal outsourcing
  • ROLE : The Solutions Architect establishes data-related development and platform architectural design standards, policies, and procedures throughout the organization. In addition, the Solutions Architect will lead the design, development and management of Consolidated Data Warehouse and data applications, ensuring that architectural standards and best practices are followed.

    JOB FUNCTION :

  • Assemble large, complex datasets that meet functional / non-functional requirements to develop custom data models and algorithms for applying to datasets
  • Mine and analyze data from modeling and simulation exercises
  • Study and describe the infrastructure required for optimal pulling, pushing, transformation, and loading of data from a wide variety of data sources using SQL, XML and other technologies
  • Keep data secure using industry standards and strategies for security
  • Create data tools for analytics and data scientist team members
  • Assess the effectiveness and accuracy of new data sources and data gathering techniques
  • Provide technical support in the research, experimentation, business analysis, and use of systems technology, including architecture, integration capabilities, and database management
  • Conduct data analysis and modeling to design medium to complex systems utilizing multiple technologies, including integrations with external systems
  • Collect and curate data from disparate sources to perform data wrangling to clean, prepare, and standardize data for consumption
  • Perform data profiling, classification, mappings, and integrity analysis to standardize and curate as part of the data onboarding process.
  • EXP NEEDED :

  • Bachelor's Degree in Computer Science, Mathematics, Engineering or equivalent work experience in a related field required
  • 5 years' data warehouse analysis and design required
  • 5 years' experience with data integration and / or data quality technologies required
  • Demonstrated experience establishing enterprise-wide data governance policies and procedures required
  • Expertise in Enterprise Data Architecture and data modeling required
  • Deep understanding of the data warehouse, data lake, data farms and other data repositories required
  • Deep understanding of the master data, transactional data and legacy data structures required
  • Advance knowledge of creating analytical data warehouses and data warehouse management required
  • Experience with unstructured and semi-structured data preferred
  • Demonstrated experience establishing master data management policies and procedures, Snowflake database management preferred
  • Demonstrated experience in development of data models of new and reverse engineering of data models from legacy ERP systems preferred
  • Advance knowledge of Cloud IaaS architectural design, workflow, and implementation using Azure, AWS, or Google Cloud preferred
  • Demonstrated experience in developing advance machine learning and business intelligence solutions to deliver outcome driven insights preferred
  • Demonstrated experience in the implementation and usage of Hadoop, Hive, Pig, and Spark cluster environments preferred
  • Demonstrated experience with SQL, JSON, Scala, Python and R language data development preferred
  • Demonstrated experience developing best practices in data wrangling and Big Data environments preferred
  • Salary : $125,000 - $160,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Datawarehouse Solutions Architect?

    Sign up to receive alerts about other jobs on the Datawarehouse Solutions Architect career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $96,585 - $120,828
    Income Estimation: 
    $128,151 - $159,004
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at DirectedLINK

    DirectedLINK
    Hired Organization Address Cypress, CA Full Time
    TITLE : IT SUPPORT ANALYST II DAYS / HOURS : M-F / 6AM-3PM mt HYBRID : 3 IN / 2 OUT TYPE : CONTRACT-TO-HIRE (6 months) L...
    DirectedLINK
    Hired Organization Address New York, NY Full Time
    Job Description Job Description A global law firm seeks a Billing Coordinator to join their dynamic team. This role will...
    DirectedLINK
    Hired Organization Address Los Angeles, CA Full Time
    Job Description Job Description TITLE : Senior Salesforce Programmer TYPE : CONTRACT (12-24 MONTHS) WORK SCHEDULE : M-F ...
    DirectedLINK
    Hired Organization Address Pasadena, CA Full Time
    We are a national Youth organization established in 1993, We are committed to providing year-round, educational and supp...

    Not the job you're looking for? Here are some other Datawarehouse Solutions Architect jobs in the Cypress, CA area that may be a better fit.

    Senior Cloud Solutions Architect

    Bowman Williams, La Verne, CA

    Industrial Solutions Architect Leader

    Jobleads-US, La Mirada, CA

    AI Assistant is available now!

    Feel free to start your new journey!