Requirements:
- Responsible for assisting with the development of an enterprise data warehouse, including migration of existing data warehouse data/schema/processes to a new data warehouse architecture
- Designs and develops Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources
- Designs and develops all aspects of the data warehouse processes including data modeling, ETL, data validation and implementation
- Documents and maintains business definitions, data dictionary and data mapping
- Implements data source integrations using various services like REST, flat file processing, etc.
- Evaluates data process optimization opportunities and develops recommendations and improvements
- Provides support to users in training and education on available data tools as required
REQUIREMENTS
- 5+ years of experience in Information Technology
- 4+ years in Data Warehouse applications
- 4+ years of experience with the BI/DW lifecycle components including Source Data Analysis, ETL, ODS, Data Marts, Data Mining
- 5+ years of analysis, development and programming experience
- Significant experience with data modeling skills
- Significant experience with SQL and Relational Databases (e.g. PostgreSQL, Oracle, SQL Server, etc)
- Experience with BI/reporting tools (i.e. Tableau, PowerBI, Domo, MicroStrategy, SAS, etc.)
- Strong verbal and written communication skills, with an ability to translate business requirements into actionable data warehouse processes, data, and reports
Preferred:
- Experience with Amazon Web Services, including Redshift and AWS Glue
- Experience with PostgreSQL
- Experience with Tableau and/or Domo reporting tools
- Experience with git, Jira, and Confluence
- Experience with Salesforce integration and/or development
- Experience with mortgage banking data/systems
- Some agile project management experience, for example managing tasks in Scrum or Kanban boards
IND 005-010