Envista Sr. Data Architect (Remote-Brea, CA)

Envista Holdings; United States; Remote; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a Senior Data Architect to join their dynamic Data and Analytics team. This role involves modernizing data architecture and building cloud data pipelines while ensuring data quality and efficiency. You will guide and mentor team members, engage with stakeholders to translate business requirements, and create a self-service data ecosystem. If you possess extensive experience in data engineering, cloud platforms, and a passion for innovative data solutions, this is a fantastic opportunity to make a significant impact in a collaborative environment.

Qualifications

• 12 years of experience in data engineering or 8 years with a Master's.
• 4+ years with Azure and Snowflake cloud data platforms.

Responsibilities

• Architect complex data solutions in Azure and Snowflake environments.
• Implement data pipelines and perform unit testing for data quality.

Skills

Data Engineering

Data Architecture

SQL

Python

Cloud Data Platforms

Data Modeling

Education

Bachelor's degree in Computer Science/Computer Engineering

Master’s Degree in related fields

Tools

Azure

Snowflake

Azure Data Factory

Coalesce

Job description

Job Description:

JOB SUMMARY:

The Envista Senior Data Architect is a critical member of the enterprise data and analytics (D&A) team. This position works with D&A analysts to translate functional requirements into finished data and analytics products.

As a Senior Data Architect, you will be part of a Data and Analytics team that is modernizing and transforming our data and reporting capabilities implementing a new modernized data architecture. In this role, you should have hands-on data architecture experience, guide and mentor the team on the best practices and also perform hands-on coding on a day-to-day basis.

This position will perform a variety of duties including building and supporting cloud data pipelines around the enterprise data warehouse, migrating from On-Prem to Cloud, advocating for continuous improvement in data quality and efficiency in data pipeline management, while ensuring a strong data model strategy.

The Data and Analytics team currently supports more than 3,000 users across 30 sites globally through multiple BI tools including an enterprise data warehouse and a downstream master data management application.

PRIMARY DUTIES & RESPONSIBILITIES:

• 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.
• Perform code reviews.
• 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.

Job Requirements:

• 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).
• Demonstrated experience with Data Architecture, working in all phases of full life cycle data analytics development: Requirements, Architecture, Design, Testing, and deployment.

PREFERRED QUALIFICATIONS:

• 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.
• The ability to be an exceptional team player, act as a technical mentor, interested in sharing knowledge with other team members, and passionate about learning new technologies.
• Experience with Master Data Management tools like Profisee is highly desired.