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

enVista; 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 pivotal role involves transforming data architecture and implementing innovative data solutions to enhance reporting capabilities. You will work closely with analysts to design and maintain cloud data pipelines, ensuring high data quality and efficiency. The ideal candidate will have extensive experience in data engineering, particularly with Azure and Snowflake, and a passion for mentoring team members. Join this forward-thinking company and help shape the future of data analytics while enjoying a collaborative and growth-oriented environment.

Qualifications

• 12 years of experience in data engineering and building data pipelines.
• Hands-on experience with Azure and Snowflake cloud environments.

Responsibilities

• Architect complex data solutions in Azure and Snowflake environments.
• Drive data quality and automation in data pipeline management.

Skills

Data Engineering

Cloud Data Platforms (Azure)

Data Architecture

SQL

Python

Data Modeling

Agile Methodologies

Education

Bachelor's degree in Computer Science/Computer Engineering

Master’s Degree

Tools

Azure Data Factory

Snowflake

ETL/ELT Tools

Data Ingestion Tools

Master Data Management Tools (Profisee)

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.