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

Florida Crystals Corporation

Plant Operator Job at Florida Crystals Corporation

 ...generators, and all auxiliary equipment, normally through the local control stations. ~ Operates and regenerates the water treatment plant equipment including filters, RO units, makeup de-mineralizers and return condensate polishers. ~ Observes, records, and interprets... 

Meals Now

Catering Delivery Driver in Baton Rouge, LA Job at Meals Now

 ...times while representing our brand and presentation. To qualify, you must possess a valid driver's license, have current insurance, reliable transportation, a XXL/ XXXL hot bag/ catering bag and a smartphone. Being punctual and professional is a must. Compensation will... 

San Diego County Regional Airport Authority

Technical Coordinator, Facilities Management Job at San Diego County Regional Airport Authority

 ...the world. Why You'll Love Working at SAN: Location: Facilities Management Department (FMD) Administration Building, located on San Diego...  ..." includes all persons employed by the state or any county, city, state agency, or public district. Disaster service workers... 

Cathay Pacific Airways Limited

Cargo Services Officer Job at Cathay Pacific Airways Limited

Cargo Services Officer+ CSD - Cargo Services Delivery+ San Francisco, California, USA+ Cathay Pacific+ Application Deadline09 May...  ...your passion fly! We're proud to be one of the world's leading airlines. Our reputation is built on a long track record of success, an... 

HNTB

Industrial Facility Designer Job at HNTB

 ...exciting time to join our team of employee-owners. This opportunity entails being responsible for the production and modification of design calculations, technical reports, engineering plans and specifications for assigned projects. This position works closely with the...