• Location: USA, Georgia, Thomasville
  • Salary: Negotiable
  • Technology: AWS Jobs
  • Job Type: Contract
  • Date Posted: 13th Sep, 2019
  • Reference: JFI239579_1568399190
JOB TITLE: Data Warehouse / Data Integration Consultant

Location: Thomasville, GA

Contract duration: 6 months

Exciting new opening for a Data Warehouse / Data Integration Consultant to my clients team and work on-site at our Global Corporate Headquarters. This positon is responsible for implementing and optimizing the functions associated with a data warehouse for a high profile product development project. Working alongside IT and business teams this role will be instrumental in helping the company to deliver a new differentiating and market disrupting product.

Experience: 3 to 7 years of IT work experience in designing, implementing, and tuning data warehouse environments. Experience in the business areas of manufacturing and/or e-commerce preferred but not required.

Essential Duties:

* Develop a data warehouse roadmap, by assessing the existing data warehouse environment and suggesting improvements in design, process, and operations
* Implement enhancements and additional components of the data warehouse
* Provide documentation on the design, implementation, and ongoing operations of the data warehouse environment
* Assess the existing data integration environment and suggest improvements in design, process, and operations
* Enhance, design, develop, and implement additional data/system integrations
* Provide documentation on the design, implementation, and ongoing operations of the data integration environment
* Define metadata governance and best practices to ensure accuracy, validity, reusability and consistency of the data warehouse
* Participates as necessary in the development of test cases, test scenarios, and test plans to support the data warehouse and data integration environments
* Implement a data dictionary
* Develop data quality policies and procedures as necessary
* Develop data steward policies and procedures

Soft Skills:

* Knowledge and experience in the business areas of manufacturing and/or e-commerce
* Highly analytical with the ability to work on small to large complex projects
* Ability to develop solutions requiring analysis and research
* Exceptional problem solving, analytical, and customer-facing skills
* Ability to cultivate an understanding of what the business is trying to achieve while working with a standard technology stack to define effective and efficient solutions
* Proven ability to deliver projects within short timelines
* Excellent verbal and written communication skills, with the ability to summarize and present findings or challenges to all levels of staff and management
* Ability to work on one or more projects as a project team member; may coach more junior technical staff
* Ability to work in decentralized team and communicate using virtual communications tools (phone, conferencing, web meetings)
* Ability to work independently with minimum guidance and be a self-starter; takes actions to achieve goals; proactive

Technical Skills:

* In depth knowledge and experience with the design, implementation, tuning, and troubleshooting of a corporate data warehouse environment
* Experience with relational and dimensional data modeling including constructing database normalization utilizing data modeling tools to record, update, reverse engineer and generate DDL creating logical and physical data models for current and proposed states
* Knowledge and experience with snowflake data warehouse
* Ability to architect a complete data warehouse environment with supporting constructs (data marts, data lakes, operational data stores, etc.)
* Demonstrate experience with the design, implementation, tuning, and troubleshooting of data integration tools (ETL, ESB, MDM, etc.)
* Knowledge and experience with with Talend ETL suite of tools
* Knowledge and experience with Talend Data Governance suite of tools (Data Dictionary, Data Quality, Data Preparation, Data Stewardship)
* Experience implementing a data dictionary against a data warehouse
* Knowledge and experience working with/in multiple database environments (Oracle, SQL, MySQL, Dynamo)
* Experience in multiple technical environments
* SSRS experience is a plus
* Experience with Redshift a plus