A good candidate for the Data Warehouse Architect position will have extensive knowledge of designing and implementing off-platform data solutions for customers with Salesforce.com Sales, Service, Community, Nonprofit, and Education Clouds, as well as experience with common nonprofit and education off-platform storage use-cases. This role will work to gather business and technical requirements and to develop solutions which could include: design and build of off-platform data warehouse systems, ETL and API-based integration support requirements, storage and data retention strategies, on-platform system support requirements, and data health and governance guidance. Serving as the technical lead for implementation projects, the Data Warehouse Architect will provide additional technical guidance to the larger technical services team, supporting and contributing to the development of business and product strategies, development and curation of best practices, and internal syndication across the technical services team.
Location: Virtual Home-based office in the US or Canada
Work Authorization: Citizens or Permanent Residents of the USA or Canada preferred but can provide Visa sponsorship on a case-by-case basis. Cannot provide C2C
Travel: 10-20%
Qualifications and Education Requirements
- Experience with design and implementation of common off-platform Data Warehouse / external cloud and on-prem storage technologies (MS SQL, Snowflake, AWS S3, Redshift, Heroku, Postgres)
- Experience with common ETL and API-based integration tools (Jitterbit, Boomi, Mulesoft, Informatica, SSIS)
- Minimum of five years technical implementation experience, excellent organizational skills, and ability to handle multiple tasks simultaneously
- Snowflake Certification (Snowpro Core/Advanced)
- AWS Certification
- Experience with Agile methodologies including working within a sprint framework
- Experience developing large volume data migrations
- Applied knowledge of Salesforce and the Sales, Services, and Community functions
- Strong consulting skills, including project management and organization
- Solid experience with Data Modelling
Nice-to-Have Qualifications
- Strong Salesforce technical knowledge, data modeling skills, and understanding/awareness of other systems commonly found in non-profit or higher ed system landscapes
- Technical knowledge includes depth and breadth on SF platform across multiple clouds, ability to design scalable architectures for LDV, ability to design performant/efficient integration processes/strategies.
- ETL certification (Mulesoft Certified Platform Architect/Developer, Boomi Architect / Developer)
- Salesforce Platform Developer I
- Salesforce certifications (Admin); Salesforce Data Architect certifications preferred
Key Skills
- Problem-solving skills
- Logical and process-oriented thinking
- Excellent organizational skills
- Ability to handle multiple tasks simultaneously
- Strong attention to detail
- Strong project management skills
- Strong time management skills
- Strong written and verbal communication skills
- Intellectual curiosity
- Passion for continuous learning
- Teamwork/collaboration skills
- Presentation skills
Main Responsibilities
- Lead technical requirements gathering sessions
- Oversee and approve creation and maintenance of application and system documentation used in design, testing or programming efforts, including ERDs, system landscapes, and data flow diagrams
- Oversee project architecture and technical solutions for data warehouse implementation projects (structure and design, integration, release management)
- Work comfortably with large data volumes (LDV) and be able to make recommendations for handling LDV both on and off the Salesforce.com platform
- Design and build off-platform Data Warehouse solutions both within the context of larger engagements or as stand-alone projects.
- Guide the environment management plan and release strategies for projects, validating that the correct development environments, change controls, and deployment plans are in place.
- Maintain expert-level knowledge of common off-platform Data Warehouse technologies
- Work with Account Executives in a Sales Engineering function to scope project proposals with appropriate estimates for the level of effort to deliver solutions and present a vision to prospects of possible solutions and outcomes
- Oversee or review large data migrations to off-platform storage solutions
- Provide colleagues with one-off and ongoing technical assistance as needed
- Show a commitment to customer satisfaction
Equal Employment Opportunity
Cloud for Good provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, ancestry, age, sex, disability, genetic information, marital status, pregnancy status, amnesty, veteran status, medical condition, or any other characteristics protected by federal, state and local laws. Cloud for Good complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company operates. This policy applies to all terms and conditions of employment.