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

Envista Holdings; Brea (CA); Remote; USD 96,000 - 179,000; Full time

Job summary

Join a forward-thinking company as a Senior Data Architect, where you'll be integral to transforming data and analytics capabilities. This role involves architecting complex data solutions in Azure and Snowflake, mentoring a talented team, and driving innovation in data quality and automation. With a focus on building cloud data pipelines and enhancing data architecture, you'll contribute to a dynamic environment that supports thousands of users globally. If you're passionate about data and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• 12 years of experience in data engineering with a focus on scalable data pipelines.
• Hands-on experience with cloud platforms like Azure and Snowflake.

Responsibilities

• Architect complex data solutions in Azure and Snowflake environments.
• Implement data pipelines and ensure data quality and lineage.

Skills

Data Architecture

Data Engineering

SQL

Python

Data Modeling

Agile Methodologies

Data Quality

Data Integration

Education

Bachelor's degree in Computer Science/Computer Engineering

Master’s Degree

Tools

Azure

Snowflake

Azure Data Factory

ETL/ELT Tools

Master Data Management Tools

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 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.

Target Market Salary Range:

$96,300 - $178,900

Operating Company:

Corporate

Envista is a global family of more than 30 trusted dental brands, united by a shared purpose: to partner with professionals to improve lives. Envista helps its partners deliver the best possible patient care through industry-leading products, solutions, and technology. Our comprehensive portfolio, including dental implants and treatment options, orthodontics, and digital imaging technologies, covers an estimated 90% of dentists’ clinical needs for diagnosing, treating, and preventing dental conditions as well as improving the aesthetics of the human smile.

Envista and all Envista Companies are equal opportunity employers that evaluate qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity, or other characteristics protected by law.