Solutions Architect - Data Warehouse
Company: Plan B Solutions
Location: Long Beach
Posted on: April 8, 2021
|
|
Job Description:
Job DescriptionSolution Architect III (Data Warehouse)Direct
Hire Cypress, Ca. MUST BE US Citizen OR GCJOB SUMMARYThe Solution
Architect III (Data) is an integral member of the Reliance
Technology Solutions (RTS) staff. 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 and development of new applications, Consolidated Data
Warehouse, ensuring that architectural standards and best practices
are followed.The Solution Architect III provides leadership
ensuring Reliances 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 companys 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.ESSENTIAL FUNCTIONS 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.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) Easily makes connections with previously unrelated
notions Define architecture principles, styles, and standards for
systems across the enterprise Ensure that standards are followed
and develop plan for remediation when they are not 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 Tolerant of a high-degree of
ambiguity and good at resolving uncertainty and setting direction
Collaborate with others to define architecture principles, styles
and standards for the enterprise Lead the design of high-quality
database systems in support of Reliance business
objectivesConsultant Able to provide extensive business and
technical guidance. Collaborate to establish broad data governance
policies and processes in support of Reliance business objectives
Analyze decisions and collaborate with others on the design of
solutions and/or impact of planned changes 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 Participate and provide
leadership within domain expertise and broader knowledge of other
domains for medium to high complexity projects in implementing
systems and ensuring design is consistent and well integrated with
existing conceptual, logical and physical architecturesGovernance
Develops, oversees, and organizes the standards, policies, and
procedures of technology throughout the organization Support
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 Review non-standard technologies and
help determine if there are standard solutions available and where
there are not, makes a recommendation to RTS leadership Collaborate
with others to safeguard the organizations data assets from damage,
theft or other unauthorized accessTechnical Strategy Ability to
identify long-term technology vision and strategy. Develop
strategies and roadmaps that span database design, master data
management, data governance, and data quality activities for the
Reliance enterprise Identify new technologies and capabilities that
will give strategic advantage and/or achieve business objectives
Look for opportunities to leverage existing technologiesInnovation
Ability to introduce new concepts, ideas, and technologies to form
effective and innovative solutions. Create proofs of concepts to
demonstrate innovative approaches for complex ideas and
applications Collaborate with application and infrastructure teams
to produce high-level, conceptual designs across one or more
domains Develop analogies or metaphors to explain a situation
Develop new insights into situations Questions conventional
approaches Designs new methods where established methods and
procedures are inapplicable or unavailable Notice trends in the
industry or marketplace and develop plans to prepare for
opportunities or problemsSUPPLEMENTAL DUTIES & RESPONSIBILITIES
Pursue training and development opportunities; strive to
continuously build knowledge and skills Assist personnel in other
RTS departments to resolve technical and/or application issues
Other duties as requestedREQUIRED & PREFERRED QUALIFICATIONS
Bachelors 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 associated with analytics data required Deep
understanding of the master data, transactional data and legacy
data structures associated with analytics tools required Experience
with unstructured and semi-structured data preferred Demonstrated
experience establishing master data management policies and
procedures 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 Advance knowledge of creating
analytical data warehouses and data management of master data
required 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 skillsby Jobble
Keywords: Plan B Solutions, Long Beach , Solutions Architect - Data Warehouse, Other , Long Beach, California
Click
here to apply!
|
Didn't find what you're looking for? Search again!
Other Other JobsLot Associate Description: Lot Associate 393203315 Yucaipa, California, US, 92399 Lot Associates assist customers with the loading Company: The Home Depot Location: Yucaipa Posted on: 04/15/2021 Groundskeeper Description: Are you someone who could describe yourself as a green thumb Do you have a penchant for planting We are looking for an immediate hire of a passionate Groundskeeper if you are ready to see if the grass (more...) Company: PeopleReady Location: Santee Posted on: 04/15/2021 Waste Sorter Description: Waste Sorter--gather garbage and other discarded materials set out by customers along designated routes in urban and rural communities and transport the materials to sanitary landfills or incinerator (more...) Company: PeopleReady Location: San Gabriel Posted on: 04/15/2021 Senior Scientist, CMC & Assay Development Description: Yoh has an exciting opportunity for an experienced br Senior Scientist br with expertise in CMC and Assay Development br to join our Client's team in San Diego, CA. This well-funded, highly-buzz-about (more...) Company: Yoh, A Day & Zimmermann Company Location: Santee Posted on: 04/15/2021 Make up to $19/hour - Deliver with DoorDash Description: Your time. Your Goals. What is DoorDash Available in over 4,000 cities in the U.S., Canada, and Australia, DoorDash is about connecting people with possibilities: bigger savings accounts, wider nets, (more...) Company: Doordash Location: Rosemead Posted on: 04/15/2021 Remote Esthetician Description: Los Angeles, CA Join the top rated on-demand wellness service in the world Soothe connects licensed professionals directly to clients via our app, making the wellness industry more accessible and lucrative (more...) Company: Soothe Location: Rosemead Posted on: 04/15/2021 FT & PT Package Handler - Warehouse Description: Auto req ID: 271187BR br br Job Summary br br FedEx Ground is an essential business that needs people to help us support the economy, handling life-saving medications and other items that keep (more...) Company: FedEx Location: Yucaipa Posted on: 04/15/2021 Senior Cybersecurity System Engineer-ESG Description: Boeing is currently looking for a Senior Product Security Engineer to join the Boeing team in Seal Beach, CA, or Aurora, CO. This position will focus on supporting a proprietary program with activities (more...) Company: BOEING Location: Rosemead Posted on: 04/15/2021 Groundskeeper Description: Are you someone who could describe yourself as a green thumb Do you have a penchant for planting We are looking for an immediate hire of a passionate Groundskeeper if you are ready to see if the grass (more...) Company: PeopleReady Location: Poway Posted on: 04/15/2021 Make up to $25/hour - Deliver with Postmates Description: Postmates has the largest on-demand fleet in the U.S. with 200,000 Postmates, and an equally extensive network of merchants. While some companies try to build a warehouse outside of a city and funnel (more...) Company: Postmates Location: Rowland Heights Posted on: 04/15/2021 |