Overview
On Site
USD 80.38 - 80.38 per hour
Contract - W2
Skills
Data Architecture
Data Migration
Business Requirements Gathering
KPI
Management
Reporting
Performance Tuning
Data Governance
Policies and Procedures
Data Quality
Regulatory Compliance
Data Warehouse
Star Schema
Database Administration
SQL
Database
Snow Flake Schema
PL/SQL
Teradata
BMC Control-M
Data Modeling
ERwin
Modeling
Data Integration
Extract
Transform
Load
Data Cleansing
Communication
Collaboration
Life Insurance
Screening
Writing
Career Counseling
Recruiting
Law
Testing
Job Details
Snowflake Architect - Contract or CTP - Charlotte, NC - $ 80.38- $ 80.38/hr.
The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.
Applicants must be legally authorized to work in the United States. Sponsorship not available.
Our client is seeking a Snowflake Architect in Charlotte, NC.
Role Description
5-10 years of experience in data warehousing. Understanding of data models and co-coordinate with Client to capture requirements.
Experience in snowflake and control M
Data Architecture Design: Develop/Modify the architecture for the EDW, including data models, data quality standards, data integration strategies, data migration and data warehousing technologies to effectively store and access data from various sources as per the requirements.
Business Requirements Gathering: Collaborate with business stakeholders to understand their data needs, identify key performance indicators (KPIs), and translate them into data warehouse requirements.
Data Integration and ETL Development: Oversee the design and implementation of ETL processes to extract data from various source systems, transform it into a consistent format, and load it into the EDW.
Data Modelling: Create dimensional data models to optimize querying and reporting on the data within the EDW.
Performance Optimization: Monitor and optimize the performance of the EDW to ensure efficient data access and query response times.
Data Governance: Establish data governance policies and procedures to ensure data quality, consistency, and compliance with regulations.
Overall Technical Leader: Provide technical guidance on data warehouse technologies, tools, and best practices to the relevant stakeholders.
Collaboration with Stakeholders: Work closely with business users, data analysts, and application developers to understand their data needs and deliver data-driven insights.
Skills & Requirements
Required Skills and Experience:
Data Warehousing Expertise: Deep understanding of data warehousing concepts, architectures, and technologies like dimensional modelling, star schema, snowflake schema, and ETL processes.
Database Management Systems (DBMS): Proficient in SQL's and Databases like Snowflake, Oracle, SQL Server, or Teradata , Control M
Data Modelling Tools: Experience with data modelling tools like Erwin, Power Designer, or other industry-standard modelling software.
Data Integration Tools: Familiarity with data integration tools for ETL development and data cleansing.
Communication Skills: Excellent communication skills to effectively collaborate with stakeholders from various departments
Benefits/Other Compensation
This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).
Why Hays?
You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.
Nervous about an upcoming interview? Unsure how to write a new resume?
Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.
Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.
In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .
Drug testing may be required; please contact a recruiter for more information.
#LI-DNI
The final salary or hourly wage, as applicable, paid to each candidate/applicant for this position is ultimately dependent on a variety of factors, including, but not limited to, the candidate's/applicant's qualifications, skills, and level of experience as well as the geographical location of the position.
Applicants must be legally authorized to work in the United States. Sponsorship not available.
Our client is seeking a Snowflake Architect in Charlotte, NC.
Role Description
5-10 years of experience in data warehousing. Understanding of data models and co-coordinate with Client to capture requirements.
Experience in snowflake and control M
Data Architecture Design: Develop/Modify the architecture for the EDW, including data models, data quality standards, data integration strategies, data migration and data warehousing technologies to effectively store and access data from various sources as per the requirements.
Business Requirements Gathering: Collaborate with business stakeholders to understand their data needs, identify key performance indicators (KPIs), and translate them into data warehouse requirements.
Data Integration and ETL Development: Oversee the design and implementation of ETL processes to extract data from various source systems, transform it into a consistent format, and load it into the EDW.
Data Modelling: Create dimensional data models to optimize querying and reporting on the data within the EDW.
Performance Optimization: Monitor and optimize the performance of the EDW to ensure efficient data access and query response times.
Data Governance: Establish data governance policies and procedures to ensure data quality, consistency, and compliance with regulations.
Overall Technical Leader: Provide technical guidance on data warehouse technologies, tools, and best practices to the relevant stakeholders.
Collaboration with Stakeholders: Work closely with business users, data analysts, and application developers to understand their data needs and deliver data-driven insights.
Skills & Requirements
Required Skills and Experience:
Data Warehousing Expertise: Deep understanding of data warehousing concepts, architectures, and technologies like dimensional modelling, star schema, snowflake schema, and ETL processes.
Database Management Systems (DBMS): Proficient in SQL's and Databases like Snowflake, Oracle, SQL Server, or Teradata , Control M
Data Modelling Tools: Experience with data modelling tools like Erwin, Power Designer, or other industry-standard modelling software.
Data Integration Tools: Familiarity with data integration tools for ETL development and data cleansing.
Communication Skills: Excellent communication skills to effectively collaborate with stakeholders from various departments
Benefits/Other Compensation
This position is a contract/temporary role where Hays offers you the opportunity to enroll in full medical benefits, dental benefits, vision benefits, 401K and Life Insurance ($20,000 benefit).
Why Hays?
You will be working with a professional recruiter who has intimate knowledge of the industry and market trends. Your Hays recruiter will lead you through a thorough screening process in order to understand your skills, experience, needs, and drivers. You will also get support on resume writing, interview tips, and career planning, so when there's a position you really want, you're fully prepared to get it.
Nervous about an upcoming interview? Unsure how to write a new resume?
Visit the Hays Career Advice section to learn top tips to help you stand out from the crowd when job hunting.
Hays is committed to building a thriving culture of diversity that embraces people with different backgrounds, perspectives, and experiences. We believe that the more inclusive we are, the better we serve our candidates, clients, and employees. We are an equal employment opportunity employer, and we comply with all applicable laws prohibiting discrimination based on race, color, creed, sex (including pregnancy, sexual orientation, or gender identity), age, national origin or ancestry, physical or mental disability, veteran status, marital status, genetic information, HIV-positive status, as well as any other characteristic protected by federal, state, or local law. One of Hays' guiding principles is 'do the right thing'.
We also believe that actions speak louder than words.
In that regard, we train our staff on ensuring inclusivity throughout the entire recruitment process and counsel our clients on these principles. If you have any questions about Hays or any of our processes, please contact us.
In accordance with applicable federal, state, and local law protecting qualified individuals with known disabilities, Hays will attempt to reasonably accommodate those individuals unless doing so would create an undue hardship on the company. Any qualified applicant or consultant with a disability who requires an accommodation in order to perform the essential functions of the job should call or text .
Drug testing may be required; please contact a recruiter for more information.
#LI-DNI
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.