Database Architect (Azure and Snowflake) Job at SolutionIT, Remote

N1RPSjVEZEFhZDl4TUdsUDRQSkF5S1pi
  • SolutionIT
  • Remote

Job Description

Solution IT Inc. is looking for a Database Architect (Azure and Snowflake) one of its clients in Remote (Some travel to LA will be needed)

Job Title: Database Architect (Azure and Snowflake)

Duties
Architect complex data solutions in an Azure and Snowflake Cloud environment .
Guide team on migrating existing processes and data from On Premises Oracle/ SQL Server and other environments to Azure cloud and Snowflake
Maintain the Azure components and services .
Drive and build out Data Quality and Data Lineage tools and concepts
Create an ecosystem of Data Products and a Data Catalog that allows users to self-serve and explore the data in the Data Warehouse.
Enable end-to-end automation for deployment using continuous integration and continuous delivery.
Implement data pipelines to ingest data to the platform, standardize the data, and transform the data into business facing datasets.
Perform unit and integration testing of data pipelines.
Perform data integration at scale with Azure Data Factory
Work with Analysts and business SMEs to translate business requirements into curated datasets suitable for analytics solutions.
Document data pipelines for maintainability.
Work with source system owners and business owners to incorporate business changes into data pipelines.
Design data architecture for future platform growth including data warehousing, streaming analytics, and data visualization.
Assist in testing, governance, data quality, training, and documentation efforts.
Actively engage in business stakeholder requirement workshops to understand, interpret, and translate requirements into effective technical solutions.

Required Skills
Bachelor's degree in Computer Science/Computer Engineering or related fields AND 12 years of experience in data engineering, designing and building scalable and reliable data pipelines and infrastructure OR
Master's Degree with 8 years of experience in data engineering, designing and building scalable and reliable data pipelines and infrastructure.
4+ years of experience with cloud-based data platforms, such as Azure.
4+ years of experience working on cloud data warehouses, such as Snowflake.
Hands on Data Modeling Experience ( like Kimball, Imon methodologies ).
Strong experience with SQL and Python.
Proficiency in performance tuning the ETLs/ELTs and database solutions for large data sets.
Proficiency with modern Agile development methodologies.
Hands-on experience with Data Ingestion tools like ADF .
Experience with transformation tools like Coalesce is highly preferred.
Deliver maintenance and improvements for existing applications.
Experience with Master Data Management tools like Profisee is highly desired.
Demonstrated experience with Data Architecture, working in all phases of full life cycle data analytics development: Requirements, Architecture, Design, Testing, and deployment.

Work Site : Remote (Some travel to LA will be needed) - PST

Duration: 6+ Months Contract

Expected Start Date : Immediate

Number of Positions: 01
Please send your responses back to contracts@solutionit.com

About Solution IT
Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston, Massachusetts.

Job Tags

Contract work, Immediate start, Remote job,

Similar Jobs

Capital Vacations

Staff Accountant Job at Capital Vacations

Purpose:We are looking for a staff accountant to join our team for day-to-day accounting activities. The ideal candidate should enjoy working in a fast-paced environment where creative thinking, problem solving, analysis, efficiency, and initiative are required. The... 

Lake Veterinary Clinic

Veterinary Assistant Job at Lake Veterinary Clinic

 ...Lake Veterinary Clinic is a well-established, progressive, fast-paced multi-doctor general practice located in Mount Dora, FL. We...  ...communication of treatment plans with clients, surgical preparation and assistance, and anesthetic management. Must be able to withstand... 

Department of Justice

CalGang Unit Manager Job at Department of Justice

 ...Services Manager I serves as the Program Manager for the CalGang Unit and is responsible for the full range of oversight functions....  ...solutions. Ability to keep staff engaged and productive in a remote work environment. Excellent planning and organizational skills... 

Creative Chaos

Senior WordPress Developer Job at Creative Chaos

 ...Job Summary: As a Senior WordPress Developer, you will play a vital role in developing and maintaining WordPress-based solutions for our clients...  ...Familiarity with Git version control Knowledge of web standards and best practices for SEO and accessibility Strong... 

D1 TRAINING

Volleyball Performance Coach Job at D1 TRAINING

 ...or CPT ~ Volleyball and/or general athletic background ~1+ years of coaching experience ~ Confident with programming and coaching...  ...in on day 1 & work with anyone. We have classes for 7-11 year olds, 12-14 year olds, 15-18 year olds, & adults. You cant have an ego...