Overview
On Site
0.0
Full Time
Part Time
Contract - W2
Skills
SNOWFLAKE
ETL
SQL
Job Details
ROLE: Data base Analyst Advisor (Data Engineer)
LOCATION:100% REMOTE
DURATION:6+ MONTHS
RATE:$65-$70/HR ON W2
Must Haves from Manager:
The main focus is someone that has strong experience with Snowflake.
Database maintenance and management in cloud-based environments (Aurora Postgres, MSSQL, Oracle, MySQL) in accordance with best practices and industry standards.
Snowflake - Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms including the creation & management of Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks.
Experience with AWS environments and AWS RDS.
Experience with SQL environments.
Bachelors Degree and 8-10years of experience.
Nice to haves:
A Snowflake Certification is a good nice to have for this manager
Any experience with CMS or other federal programs would be huge.
Job Description:
As a Database Analyst, Advisor, you will help ensure that today is safe and tomorrow is smarter. Our work depends on Database Analyst; Advisor joining our team to develop and maintain solutions for querying and matching large amounts of data while continuously enhancing and improving our data architecture strategy and database estate.
How a Database Analyst and Advisor will Make an Impact:
Improving system performance by conducting tests, troubleshooting, query tuning, and integrating new elements and features
Assist various support teams and stakeholders with the design, maintenance, problem resolution and operational troubleshooting of all database components with a user or service experience mindset.
Cross functionally works with stakeholders including the Executive, Product, platform, Data and Design teams to assist with data-related technical issues operating in a matrix structure.
Support stakeholders with data infrastructure needs including performing unit tests and code reviews to ensure all code is rigorously designed, elegantly coded, and effectively tuned for performance to provide the highest level of service and user experience. Regularly review database estate for improvements and optimizations including right-sizing for new or current database systems including coordinating with the project team to identify future needs and requirements
Design conceptual and logical data models and flowcharts supporting comprehensive compliance and documentation standards
May coach and review the work of less experienced professionals
Ensure deliverables are completed on time and of high-quality
Requirements:
Education:
Bachelors degree in computer science or related technical discipline, or the equivalent combination of education, technical training, or work/military experience
Required Experience:
10+ years of related experience in IT operations & development
Required Technical Skills:
Provide Database Admin functions (installing, managing, configuring, upgrading, optimizing, etc.) for cloud-based MSPSC databases which include SQL Server, Oracle, Aurora-Postgres, and MySQL.
Manage data in a Snowflake environment
Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms
Optimize the performance of data repositories such as Snowflake and AWS RDS
Deploy and configure tools to monitor and report on the performance of the Snowflake system
Create & manage Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks
User management, Implementation of RBAC best practices
Execute day-to-day Snowflake Administration in accordance with industry best-practices.
Maintain an automate first approach reducing toil and overhead by collaborating with data engineers/architects to transform data and integrate algorithms and models into automated processes
Maintains current knowledge of relevant technology and a curiosity for opportunities for improvement, innovation, and cost-reduction
Required Skills and Abilities:
In-depth understanding of database structure principles
Experience gathering and analyzing system requirements
Hands-on experience creating SQLs that will work on an existing Snowflake schema
Hands-on experience with Snowflake Administration, Snowflake development, Snowflake Utilities, Snow SQL, Snow Pipe
Snowflake certification is required and must be active
Expertise in SQL
Problem-solving mindset
High level of drive, self-motivation and initiative
--
--
---
----
Thanks & Regards,
Mohan Sai| Talent Acquisition Lead
Thoughtwave Software and Solutions
Mobile/Text Messages: EXTN: 143
Email:
linkedin:
LOCATION:100% REMOTE
DURATION:6+ MONTHS
RATE:$65-$70/HR ON W2
Must Haves from Manager:
The main focus is someone that has strong experience with Snowflake.
Database maintenance and management in cloud-based environments (Aurora Postgres, MSSQL, Oracle, MySQL) in accordance with best practices and industry standards.
Snowflake - Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms including the creation & management of Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks.
Experience with AWS environments and AWS RDS.
Experience with SQL environments.
Bachelors Degree and 8-10years of experience.
Nice to haves:
A Snowflake Certification is a good nice to have for this manager
Any experience with CMS or other federal programs would be huge.
Job Description:
As a Database Analyst, Advisor, you will help ensure that today is safe and tomorrow is smarter. Our work depends on Database Analyst; Advisor joining our team to develop and maintain solutions for querying and matching large amounts of data while continuously enhancing and improving our data architecture strategy and database estate.
How a Database Analyst and Advisor will Make an Impact:
Improving system performance by conducting tests, troubleshooting, query tuning, and integrating new elements and features
Assist various support teams and stakeholders with the design, maintenance, problem resolution and operational troubleshooting of all database components with a user or service experience mindset.
Cross functionally works with stakeholders including the Executive, Product, platform, Data and Design teams to assist with data-related technical issues operating in a matrix structure.
Support stakeholders with data infrastructure needs including performing unit tests and code reviews to ensure all code is rigorously designed, elegantly coded, and effectively tuned for performance to provide the highest level of service and user experience. Regularly review database estate for improvements and optimizations including right-sizing for new or current database systems including coordinating with the project team to identify future needs and requirements
Design conceptual and logical data models and flowcharts supporting comprehensive compliance and documentation standards
May coach and review the work of less experienced professionals
Ensure deliverables are completed on time and of high-quality
Requirements:
Education:
Bachelors degree in computer science or related technical discipline, or the equivalent combination of education, technical training, or work/military experience
Required Experience:
10+ years of related experience in IT operations & development
Required Technical Skills:
Provide Database Admin functions (installing, managing, configuring, upgrading, optimizing, etc.) for cloud-based MSPSC databases which include SQL Server, Oracle, Aurora-Postgres, and MySQL.
Manage data in a Snowflake environment
Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms
Optimize the performance of data repositories such as Snowflake and AWS RDS
Deploy and configure tools to monitor and report on the performance of the Snowflake system
Create & manage Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks
User management, Implementation of RBAC best practices
Execute day-to-day Snowflake Administration in accordance with industry best-practices.
Maintain an automate first approach reducing toil and overhead by collaborating with data engineers/architects to transform data and integrate algorithms and models into automated processes
Maintains current knowledge of relevant technology and a curiosity for opportunities for improvement, innovation, and cost-reduction
Required Skills and Abilities:
In-depth understanding of database structure principles
Experience gathering and analyzing system requirements
Hands-on experience creating SQLs that will work on an existing Snowflake schema
Hands-on experience with Snowflake Administration, Snowflake development, Snowflake Utilities, Snow SQL, Snow Pipe
Snowflake certification is required and must be active
Expertise in SQL
Problem-solving mindset
High level of drive, self-motivation and initiative
--
--
---
----
Thanks & Regards,
Mohan Sai| Talent Acquisition Lead
Thoughtwave Software and Solutions
Mobile/Text Messages: EXTN: 143
Email:
linkedin:
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.