Our client is a boutique consulting firm based in the Greater Washington DC area. They have a contract/contract to hire need for a mid-level SQL Developer with experience in an enterprise data warehouse environment. This role is immediate, fully remote and interviews are all virtual. You must be located in the continental United States and be fully authorized to work in the US without sponsorship. No third parties please.
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
Want more jobs like this?
Get Data and Analytics jobs in Reston, VA delivered to your inbox every week.
- 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