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