Technical Solution Architect

Akkodis is seeking a Solution Architect for a Full Time job with a client in Cypress, CA.

Rate Range: Base Pay Range: $148K - $158K. The salary may be negotiable based on experience, education, geographic location, and other factors.

Key Skills & Responsibilities

• Database Administration & Management – Strong experience managing and optimizing databases.

• Database Design & Architecture – Ability to design and implement scalable database solutions.

• Cloud Database Expertise – Experience with cloud databases; Snowflake is a plus.

• Data & Data Flows – Understanding of data pipelines, ETL processes, and data governance.

• Snowflake Data Warehouse Management – Responsible for maintaining, releasing, and optimizing our Snowflake environment, including credit usage efficiency.

• Semantic Layer Development – Design and build semantic layer views and materialized views in Snowflake.

Work Schedule & Location:

• Hybrid schedule – In-office Monday & Tuesday (Cypress location).

Overview:

The Solution Architect III establishes data-related development and platform architectural design standards, policies, and procedures throughout the organization. In addition, the Solution Architect III leads the design, development and management of Consolidated Data Warehouse and data applications, ensuring that architectural standards and best practices are followed.

The Solution Architect III provides leadership ensuring data assets are effectively cleansed, governed, conformed, and developed with best practices to derive outcome driven insight and is responsible for designing, creating, deploying and managing the company’s data architecture and defining how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as applications using or processing that data.

Responsibilities:

• 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
• 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.
• Architecture – Knowledge of architectural methodologies used in the design and development of information systems, including the physical structure of a system's internal operations and interactions with other systems.Extensive knowledge of a domain (i.e., applications, data, infrastructure, security) and broad knowledge of other domains
• Collaborate with RTS management and Project Managers to ensure that assets in the IT portfolio are leveraged to the maximum extent possible
• Analyze the current architecture to identify weaknesses and develop opportunities for improvements in medium to high complexity projects (i.e., business processes, expanding capacity, reducing time, cost and increasing effectiveness)
• Ability to apply advanced knowledge and experience to the design and development of both OLTP and DW systems
• Understand where application domains overlap and collaborate with others on the design of solutions and/or impact of planned changes
• Lead the design of high-quality database systems in support of business objectives
• Consultant – Able to provide extensive business and technical guidance.Collaborate to establish broad data governance policies and processes in support of business objectives
• Collaborate with technology and application owners to manage lifecycle of data assets in the IT portfolio within domain expertise with broader knowledge of other domains
• Collaborate with various RTS departments to evaluate designs and identify potential gaps or weaknesses early so they can be addressed within domain expertise integrating broader knowledge of other domains for medium to high complexity projects
• Translate business needs into architectural requirements using domain expertise and broader knowledge of other domains for medium to high complexity projects
• Governance – Develops, oversees, and organizes the standards, policies, and procedures of technology throughout the organizationSupport defining architecture principles, styles, and standards for systems across the enterprise
• Ensure that standards are followed and develops a plan for remediation when they are not
• Collaborate with others to define architectural principles, styles and standards for systems across the enterprise
• Develop analogies or metaphors to explain a situation
• Other duties as requested

Qualifications:

• 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 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
• Proficiency with Microsoft Windows and Microsoft Office products required
• Must be self-motivated and able to work independently, with minimal supervision and as part of a team
• Capable of learning new systems and creating/implementing new system functionality
• Possesses advanced knowledge of HTML and XML
• Understands advanced internet and client/server architectures
• Strong communication skills, both verbal and written, required
• Detail oriented with excellent interpersonal communication skills, verbal and written, at all levels including customers, vendors, peers, business stakeholders and management required
• Excellent customer service skills

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

If you are interested in this job in then please click APPLY NOW. For other opportunities available at Akkodis go to www.akkodis.com. . If you have questions about the position, please contact Pragya Jain at 408-962-4980 or pragya.jain@akkodisgroup.com

Equal Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.

To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit https://www.akkodis.com/en/privacy-policy.

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

· The California Fair Chance Act

· Los Angeles City Fair Chance Ordinance

· Los Angeles County Fair Chance Ordinance for Employers

· San Francisco Fair Chance Ordinance