Senior Data Integration Architect in Sacramento, CA at SBM Site Services

Date Posted: 7/26/2020

Job Snapshot

  • Employee Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Job Overview
Serves as the technical resource in the strategic oversight and design of data models and database structural design and development. Responsible for improving SBM’s data integration processes / procedures with its’ key business systems such as ERP, HRIS and Data Warehouse. Provides technical, strategic advice and guidance in the creation and implementation of new data standards and database designs.

Roles & Responsibilities
  • Develop technical best practices for data movement, data quality, data cleansing, and other ETL related activities
  • Design, develop, deploy and maintain integration processes between applications across cloud and on-premises systems using the Dell Boomi platform.
  • Analyze Integration requirements, perform gap analysis.
  • Design, development and deployment of Integration solutions for Cloud, On-Premises and Hybrid scenarios.
  • Prepare / update technical specifications and architectural artifacts as needed
  • Design and develop across various integration technologies (Data Integration, Application Integration, Business Process Integration, UI Integration, etc.)
  • Ensure adherence to locally defined standards for all developed components
  • Design, develop and implement enterprise-class Data Warehousing solutions, including a Standard Integration Framework
  • Provide data analysis and technical documentation for both Source and Target mappings
  • Automates manual tasks and implements stabile, reliable and self-correcting data movement solutions.
  • Ensure that the ETL requirements are adequately understood and documented; participate in requirements, design and development reviews
  • Conduct/participate in meetings with key system owners to understand current data and systems environments, resolve source data issues and refine transformation rules
  • Analyze source system data to assess data quality; work with technical and business representatives to determine strategies for handling data anomalies identified
  • Design ETL processes and develop source to target data mappings, Integration Workflows and load processes
  • Develop, test, integrate and deploy ETL routines using ETL tools and external programming/scripting languages, as necessary
  • Administer and maintain the ETL environment, including performing configuration management activities related to the ETL environment
  • Assist with performing source data quality assessments

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Other duties, responsibilities and activities may change or be assigned at any time with or without notice.

Education and/ or Experience
  • Bachelor’s degree in business, communications, or a related field from a four-year college or university; or equivalent combination of education and experience.
  • At least 2 to 3 full cycle project implementations involving integration (at least 1 implementation), Salesforce, Ultipro, Netsuite, on-premise and Cloud/hybrid integrations
  • May be required to have a valid driver’s license.
  • Boomi Integration Developer Certification - (Preferable)

Knowledge, Skills, and Abilities
Good grip on fundamentals/key concepts such as Troubleshooting of fail over processes, load-testing, disaster recovery, data security, change-control best practices
Experience supporting high-volume transactions Platform • Experience in Java, Javascript, Groovy, similar programming languages.
Experience on building and designing REST, SOAP , XML over HTTP APIs
Expertise in development of integration processes using Dell Boomi
Worked on Dell Boomi and should be well versed on the solutioning part was well as the product capabilities
Very strong experience on Enterprise Data Integration and management and should have Hands on experience on Middleware technologies.
Ability to drive architectural and design discussions with the stakeholders