Job Summary
The 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, 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 Reliance's 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.
Physical Requirements
Stand or Sit(Stationary position), Walk(Move, Traverse), Use hand / fingers to handle or feel (Operate, Activate, Use, Prepare, Inspect, Place, Detect, Position), Talk / hear(Communicate, Detect, Converse with, Discern, Convey, Express oneself, Exchange information), See (Detect, Determine, Perceive, Identify, Recognize, Judge, Observe, Inspect, Estimate, Assess), Reaching, Repetitive Motion
Function in the Job
Sedentary Work- Exerting up to 10 pounds of force occasionally, and / or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.
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.
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 domainsCollaborate with RTS management and Project Managers to ensure that assets in the IT portfolio are leveraged to the maximum extent possibleAnalyze 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 notionsDefine architecture principles, styles, and standards for systems across the enterpriseEnsure that standards are followed and develop plan for remediation when they are notAbility to apply advanced knowledge and experience to the design and development of both OLTP and DW systemsUnderstand where application domains overlap and collaborate with others on the design of solutions and / or impact of planned changesTolerant of a high-degree of ambiguity and good at resolving uncertainty and setting directionCollaborate with others to define architecture principles, styles and standards for the enterpriseLead 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 objectivesAnalyze decisions and collaborate with others on the design of solutions and / or impact of planned changesCollaborate with technology and application owners to manage lifecycle of data assets in the IT portfolio within domain expertise with broader knowledge of other domainsCollaborate 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 projectsTranslate business needs into architectural requirements using domain expertise and broader knowledge of other domains for medium to high complexity projectsParticipate 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 enterpriseEnsure that standards are followed and develops a plan for remediation when they are notCollaborate with others to define architectural principles, styles and standards for systems across the enterpriseReview non-standard technologies and help determine if there are standard solutions available and where there are not, makes a recommendation to RTS leadershipCollaborate with others to safeguard the organization's 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 enterpriseIdentify new technologies and capabilities that will give strategic advantage and / or achieve business objectivesLook 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 applicationsCollaborate with application and infrastructure teams to produce high-level, conceptual designs across one or more domainsDevelop analogies or metaphors to explain a situationDevelop new insights into situationsQuestions conventional approachesDesigns new methods where established methods and procedures are inapplicable or unavailableNotice 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 skillsAssist personnel in other RTS departments to resolve technical and / or application issuesOther duties as requestedRequired Skills
Bachelor's Degree in Computer Science, Mathematics, Engineering or equivalent work experience in a related field required5 years' data warehouse analysis and design required5 years' experience with data integration and / or data quality technologies requiredDemonstrated experience establishing enterprise-wide data governance policies and procedures requiredExpertise in Enterprise Data Architecture and data modeling requiredDeep understanding of the data warehouse, data lake, data farms and other data repositories requiredDeep understanding of the master data, transactional data and legacy data structures requiredAdvance knowledge of creating analytical data warehouses and data warehouse management requiredExperience with unstructured and semi-structured data preferredDemonstrated experience establishing master data management policies and procedures, Snowflake database management preferredDemonstrated experience in development of data models of new and reverse engineering of data models from legacy ERP systems preferredAdvance knowledge of Cloud IaaS architectural design, workflow, and implementation using Azure, AWS, or Google Cloud preferredDemonstrated experience in developing advance machine learning and business intelligence solutions to deliver outcome driven insights preferredDemonstrated experience in the implementation and usage of Hadoop, Hive, Pig, and Spark cluster environments preferredDemonstrated experience with SQL, JSON, Scala, Python and R language data development preferredDemonstrated experience developing best practices in data wrangling and Big Data environments preferredProficiency with Microsoft Windows and Microsoft Office products requiredMust be self-motivated and able to work independently, with minimal supervision and as part of a teamCapable of learning new systems and creating / implementing new system functionalityPossesses advanced knowledge of HTML and XMLUnderstands advanced internet and client / server architecturesStrong communication skills, both verbal and written, requiredDetail oriented with excellent interpersonal communication skills, verbal and written, at all levels including customers, vendors, peers, business stakeholders and management requiredExcellent customer service skillsCompensation Range
The anticipated compensation for this position is USD $142,500.00 / Yr. - USD $172,000.00 / Yr. depending on experience, qualifications, and location.
Salary : $142,500 - $172,000
