Responsibilities

• During the planning and analysis phase:
  • Bring knowledge of data architecture options to the project team and research solutions that will properly meet the business needs at hand
  • Provide input on the best components to include in the enterprise architecture, including all Salesforce clouds (i.e. Sales, Service, Health Cloud, FLS, CPQ/QTC, Heroku, MuleSoft, etc.), as well as non-Salesforce infrastructure such as GCP, AWS or Azure, and how to integrate these cloud offerings with a client’s on-prem or private cloud systems.
  • Identify when a data migration will be necessary to retire a legacy system or seed required data to a new system
  • Contribute to source data analysis for data migrations and produce mappings and transformation instructions to reach the target database
  • Assess the need for data quality tools to assist in de-duplication, merging, and validation (i.e. addresses, email, phone numbers, etc.)
  • Know when to apply the basic integration patterns in the architecture; including batch/ETL, event triggered, etc.
  • Awareness of security best practices in all aspects of the data architecture
• During the implementation phase:
  • Provide assistance in data modeling to the project team
    • Become proficient in the appropriate phases of the implementation to perform conceptual, logical, or physical modeling
    • Become proficient on when to normalize vs. denormalize a data model based on technology, use case, and performance requirements
    • Understand the appropriate scenarios for relational or dimensional data modeling
    • Provide detailed artifacts from the data modeling process, including Entity Relationship Diagrams (ERDs) and comprehensive data dictionaries
  • Contribute to the implementation of all tools identified during the planning phase, including tools for integration, migration, quality, enrichment, analytics, visualization, master data, metadata and security
• During the testing phase:
  • Assist in planning for data needs during all phases of testing; including unit, system, integration, performance/stress, user acceptance, and regression
  • Become proficient at testing tools to ensure high-quality and repeatable steps
  • Assist with build and maintaining test data to ensure all edge cases are tested with production-like data
  • Take direction and implement measures to protect sensitive production data as needed for testing, including obfuscation and/or masking
• During the deployment phase:
  • Become proficient at tooling to ensure high-quality and repeatable deployment activities take place
  • Assist in using the Salesforce metadata and tooling APIs
  • Research the use of Salesforce metadata deployment tools such as the SFDX, CLI, Copado, GearSet, Flosum, or other relevant tooling
• In support of Coastal Cloud’s people, methods and tools:
  • Assist in the development of best practices in all areas of the data discipline
  • Mentor our novice analysts and data engineers to develop skills and promote interest in the data career path
  • Support the development of accelerators in all areas of data to help our teams deliver more consistently and efficiently
  • Provide input for the improvement of our estimating models in the data disciplines
  • Become involved in nourishing vendor relationships in the data space so that Coastal Cloud can bring the appropriate toolset to bear with our clients

Required Skills, Education and Experience

• Understanding of data and architecture-oriented tools and platforms (examples below):
  • Platforms: Salesforce (all clouds), Heroku, Google Cloud, AWS, Azure
  • Reporting: Tableau, Tableau Prep, CRM Analytics, PowerBI
  • Integration: Tibco Cloud Integration, MuleSoft, Jitterbit, Boomi, Informatica
  • API Management: Tibco Mashery, Google APIgee, MuleSoft
  • Quality: DemandTools, Plauti
  • Enrichment: D&B, ZoomInfo, Wealth Engine, Populi
  • Back-Up: OwnBackUp
  • Security: Salesforce Shield, Okta, Active Directory, SAML, OAuth2, JWT
  • Testing: Selenium, Provar, Postman, SOAP UI
  • Metadata Management/Deployment: Copado, GearSet, Flosum, SFDX, GitHub
• 2 years of data migration experience from complex enterprise systems and preferably to Salesforce
• 4 years experience as a Senior Consultant (or equivalent seniority)
• Knowledgeable at implementing common enterprise integration patterns, including ETL, batch, event, etc.
• Aware of API Management solutions, especially with REST standards, including awareness of developer portals, API monitoring, OAS/Swagger specifications
• Learn client business processes and relate to source data to help discover data to answer business questions. Provide input to clients when defining the optimal to-be data architecture.
• Ability to adapt to a fast-paced, ever-changing environment and manage multiple projects simultaneously
• Proficient in relational database design, logical data modeling, data warehousing, and relational database management systems. Experience in the top RDBMS systems (SQL Server, Oracle, PostgreSQL, MySQL)
• Experience in using design tools (i.e. LucidChart, Visio, ERwin, etc.) for ERDs and other deliverables
• Experience in tool implementation to support governance policies, such as Salesforce Shield or Fairwarning
• Ability to provide input to client security questionnaires and audits during the sales evaluation process. Understand the implications of data in implementing security guidelines such as HIPAA, PCI, SOX, ISO, NIST, etc.
• Awareness of industry-specific data integration standards such as EDI, HL7, FIHR, etc.
• Hands-on expertise in SQL, SOQL, SOSL, and SAQL query languages
• Must have full-time permanent US work authorization

• Bachelor’s Degree preferred, or equivalent experience
• Tableau Certifications (Desktop Specialist, Desktop Certified Associate or Tableau Certified Associate Consultant)
• Salesforce Certifications
• Mulesoft Certifications (Dev, Platform Architect)
• Other integration (Tibco, Boomi, Informatica, Jitterbit) or IaaS certifications (i.e. AWS, GCP, Azure)
• Programming skills in a language appropriate for data wrangling (i.e. Javascript, Python, R, SAS, C#, etc.)
• Web application development experience