Data Warehouse Developer in the USA or Canada

Cloud For Good • Asheville, NC

275d

About The Position

The Data Warehouse Developer should have extensive knowledge of designing and implementing off-platform data solutions for customers with Salesforce.com Sales, Service, Community, Non-profit, and Education Clouds. The Data Warehouse Developer will have experience with common Non-Profit and Education off platform storage use-cases and technologies. The Data Warehouse Developer 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. The Data Warehouse Developer 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.

Requirements

• Experience with design and implementation of common off-platform Data Warehouse / external cloud and on-prem storage technologies, Civis is preferred but other technologies such as MS SQL, Snowflake, AWS S3, Azure Datawarehouse, Redshift, Heroku, Postgres, etc are also acceptable
• Experience with common ETL and API-based integration tools (Jitterbit, Boomi, Mulesoft, Informatica, SSIS)
• Python Scripting experience
• Minimum of two years technical implementation experience, excellent organizational skills, and ability to handle multiple tasks simultaneously
• 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 Haves

• 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
• Snowflake Certification (Snowpro Core/Advanced)
• AWS Certification

Responsibilities

• Create and maintain application and system documentation used in design, testing or programming efforts, including ERDs, system landscapes, and data flow diagrams
• Work comfortably with large data volumes (LDV) and be able to make recommendations for handling LDV both on and off the Salesforce.com platform
• Build off-platform Data Warehouse solutions both within the context of larger engagements or as stand-alone projects
• Maintain expert-level knowledge of common off-platform Data Warehouse technologies
• 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

What This Job Offers

• Industry: Professional, Scientific, and Technical Services