Data Warehouse Architect/Engineer
Vacancy expired!
We are looking for candidates who can work independently on W2 without sponsorship only. No C2C options available for this role.
Job Duties:- Design and implement data architecture solutions, including data modeling, data integration, and data management
- Consolidate existing data sources into a new data warehouse
- Either validate or invalidate the existing data structures in place
- Help determine analytics and ETL tools
- Design efficient data pipelines to transform raw data sources into, reliable components ensuring data quality, efficient processing, and timely delivery of accurate and trusted data
- Design data models for optimal storage and retrieval to meet critical business requirements
- Work with stakeholders to assist with data-related technical issues and support their data infrastructure needs
- Maintain high standards of engineering excellence
- Define and enforce data governance policies and advocate for best practices
- 5+ years experience working with data warehousing
- Previous experience designing and implementing a new data warehouse (at least two projects)
- Experience with SQL Server
- Strong Data Modeling skills
- Experience with Star and Snowflake Data Warehouse Schemas
- Experience with multiple ETL tools such as SSIS, Informatica, DataStage, etc
- Experience with multiple BI tools such as SSAS, Congnos or Business Objects
- Experience with collecting data from tradition systems as well as shop floor systems and IOT devices