Data Integration Architect
Position Summary
The Data Integration Architect is responsible for integrating multiple data sources into Salesforce.com and/or business intelligence platforms. This position is responsible for reviewing Salesforce integration requirements with a solid understanding of various integration options to implement a cohesive data architecture solution that aligns with the overall technology ecosystem while serving the customer’s business needs.
Primary Responsibilities Include:
- Design data integration strategies utilizing Salesforce.com
- Translate business requirements and corresponding processes into technical requirements for Salesforce configuration and data architecture
- Analyze and profile the source data as input into the overall data architecture solution
- Review existing application platforms to establish the system of record and build effective data flows across the technical ecosystem
- Design, develop, and implement data integrations (SSIS packages) to migrate data between client data sources and Salesforce, per overall data architecture solution. Integrations may be between cloud, on-premise and hybrid platforms.
- Collaborate with Salesforce Consultants on solution design and implementation, configuring the Salesforce platform as required and incorporating nuances of client’s Salesforce solution into SSIS integrations
- Design and conduct any one-time data migration / data conversion activities, as needed per client
- Identify anomalies, errors, patterns, and trends in source data and apply these findings to reduce future rework or errors
- Write Source-to-Target documents to identify how source data will map to target tables and specify any data transformations required
- Build relevant Salesforce reports and dashboards for clients to review data migration results
- Recommend and implement best practices as it pertains to data quality
- Adapt ETL processes to accommodate changes in source systems and new business user requirements
- Work with stakeholders at all levels to assist with data-related technical issues
- Ensure architecture and design is compliant with client specific technical, security, and regulatory standards
- Lead proof of concept activities for new tools, technologies, infrastructure, and processes related to integration initiatives
- Proactively research new vendors, technologies, and industry best practices. Determine relevancy and impact of implementing new solution architecture methodologies.
- Keep up with the latest Salesforce technology and releases with the expectation to support Salesforce consulting projects, as needed.
- Other duties as assigned.
Education and Experience Required:
- Bachelor's degree in Technology, Computer Science or related field preferred; or 8+ years of experience implementing technology solutions and data migration and integration projects
- Proficiency in implementing reliable, complex, secure, high performance and scalable data integration solutions on the Salesforce.com platform
- Ability to lead architectural discussions and identify & assess solution alternatives
- Hands on experience with middleware, integration architecture patterns, and web service technologies
- Experience collaborating with business and IT teams on requirements, design, security, infrastructure, networking, QA areas to ensure alignment and compliance.
- Ability to work collaboratively within a team environment of cross functional and cross vendor teams.
Required Technical Skills
- Strong SQL skills
- Strong experience in designing data models as part of Salesforce solutions
- Strong experience with SSMS, SSIS, and integration tools such as KingswaySoft
- Salesforce Administrator and/or Salesforce App Builder certification, or equivalent experience with Salesforce configuration
- Solid understanding of data integration methodologies and expert level experience with ETL from a variety of data sources
- Proficient in MS Office Suite
Preferred Technical Skills
- Experience with business intelligence software (Power BI, DOMO, Tableau, or similar products)
- Experience with cloud-to-cloud and hybrid integration architecture
- Familiarity with Internet security protocols such as SSL/TLS, SSO, SAML, OAuth
- Experience architecting for Big Data solutions a plus
Professional Qualifications – Skills and Abilities Required:
- Strong analytical and organizational skills
- Coachable, dedicated to improvement
- Strong attention to detail, a must
- Hands on and effective in a fast moving, creative environment
- Ability to process questions, problems, comments, objections and apply appropriate feedback, professionally and quickly
- Ability to prioritize and balance multiple tasks while successfully achieving deadlines for client delivery
- Possesses relationship building skills combined with a collaborative personal style with desire and drive for results
- Strong interpersonal communication skills, both written and verbal.
Expected hours of Work:
This is a full-time position with regular office hours Monday through Friday. This position may require occasional after hours or weekend work, depending on work demands.
Travel Expectations:
This position may require some domestic US travel, up to 10% of the time, for strategic client meetings, sales presentations, industry events, team meetings and client events.