Job Title: Data Warehouse Architect
Summary: Looking for a consultant to help design and build new architecture implement new integration technology (Snaplogic) of SaaS cloud data for a fast moving company in the beverage alcohol space. Work largely from home in a highly flexible environment using a blend of open source and industry leading technology.
Responsibilities
Develop data and integration architecture to integrate standard client and 3rd party systems into core package applications. Integration needs to be regular (automated daily/hourly), reliable (error handling with minimal downtime), re-usable (available for nearly all clients and packages).
Develop and maintain data models for core package application and reporting databases to describe objects and fields for support documentation and to facilitate custom application development and data integration.
Lead design of core package application components and related data objects (Force.com); focus on consistency and re-use, ease of integration/data maintenance, and optimization for BI/reporting.
Support investigation and resolution for escalated data quality issues.
Desired Skills:
Integration architecture:
Understand data/integration architecture: vision/strategy, as-is architecture, to-be architecture, medium/long-term plan
Understand Integration architecture: application integration and data flow diagrams, source-to-target mappings, data dictionary reports
Some understanding of ETL, SOA, web services architecture
Experience with one or more of the following data integration platforms: Pentaho Kettle, Talend OpenStudio, Jitterbit, Informatica PowerCenter, or similar
Familiar with Web Services: XML, REST, SOAP
Experience with Git or similar version control software
AWS or Google Cloud Service offerings
Data architecture:
Understand Logical and physical data models (ERwin, PowerDesigner)
Awareness of Data governance and data quality principles
Ability to transform business rules into functional solutions
Data warehouse design: star-schemas, change data capture, denormalization
Database experience:
Broad experience multiple RDBMS: MS SQLServer, MySQL, PostgreSQL, Redshift
Familiarity with SaaS/cloud data systems (e.g. Salesforce)
Server Administration:
Experience deploying applications to cloud resources
Other
Effective communication with business (clients and business analysts) and technical teams (developers and support staff)
Useful documentation of development that can be easily leveraged for training and support
Preferred Experience
Industry experience in consumer packaged goods (ideally, beverage supply and distribution)
Experience with a software start-up company
BI and Data Warehouse design and integration
Technology in Play
Salesforce, SnapLogic, Kettle, MSSQL, S3/Athena, Redshift
BI and Data Warehouse design and integration, document (flat-file) management
No Recruiters please.
Candidates - Please apply using proper channels