The Data Architect is responsible for contributing to aspects of our data practice and participating in the definition of the overall data architecture for client projects as well as researching best practices based on client needs. The Data Architect participates in discovery sessions to understand client business, applications and data and translates findings into technical requirements supported by a documented design. They participate actively on the implementation team through all phases of the life cycle; including design, build, test, deploy, and maintenance.
Work that matters. Life that fits.
Looking for a role where you can live anywhere you want while delivering meaningful client work? You’re in the right place.
We’re looking for tech-savvy folks who know Salesforce inside and out and believe outstanding customer experience is table stakes. Join our team of talented, certified Salesforce consultants and industry experts and develop life-changing skills.
Work Environment
Flexible Work Options
Volunteer Time Off
Computer Allowance
Team Building Activities
Virtual Socials
Great Benefits
Medical & dental insurance
Flexible spending accounts
401(k) plan with company match
Short-term & long-term disability
Life & AD&D insurance
Paid holidays
Responsible Time Off (RTO)
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
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
Additional Requirements
Bachelor’s Degree preferred, or equivalent experience