Principle Data Architect, Data Integration Hub

IDEXX
US, MI, Virtual
$170K-$190K a year
Full-time

As Principle Data Architect , you will drive the vision and create the architecture for data solutions, ensuring access, performance, and security of data systems and applications, aligning data architecture with overall enterprise architecture, and maintaining extensive knowledge of databases and their relation to business operations.

You will translate strategic requirements into a usable enterprise data framework and guide data solutions development while facilitating consistent data design, optimization, archiving, and recovery strategy.

Our team includes a range of data engineers, data architects, and data-centric business system analysts, focusing heavily on cloud-based "big data" projects.

Some team members provide knowledge and support over our traditional data warehouse applications, building upon these environments with SQL and traditional ETL methods.

At the same time, our newest technology expands our data models via Snowflake, bringing the best of cloud scale and compute capabilities and long-lived data engineering practices.

Our stack : AWS (S3, EMR, Glue, DocumentDB, DynamoDB, OpenSearch), Snowflake, Oracle, MySQL, Python, Scala, Terraform, git

In this role :

  • You will develop and maintain the overall system's technical architecture
  • You will collaborate with technology and management teams to understand structural requirements and define standards for storing, consuming, integrating, and managing data across the organization and translating it into a usable blueprint
  • You will build an inventory of data needed to implement the architecture and create a vision for how data will flow through the organization
  • You will design and build complex data models and approve modifications to and implement systems
  • You will implement measures to ensure data accuracy and accessibility, constantly monitoring and refining the performance of data management systems.
  • You will produce and enforce database development standards
  • You will provide architectural design and planning of technical activities, including application architecture, system landscape, installation sizing and planning, system change management, performance monitoring, performance tuning, troubleshooting, problem analysis, and problem resolution
  • You will ensure interoperability at the data level across a full range of relevant Company products and services
  • You will ensure data integrity and the data's strategic value is understood and practiced throughout the Company
  • You will mentor other development and business teams on data architecture design and requirements
  • You will manage incoming technical requests and design systems for optimum performance; proactively identify potential problems;

create and modify strategies to resolve problems; document issues and resolutions

You will maintain descriptions of data, structures, and metadata

What you will need to succeed :

  • You have experience as Data Engineer, ETL developer, or report metadata designer
  • You can build distributed and cloud-based data pipeline architectures
  • Your tech stack includes SQL-based technologies like Oracle, PostgreSQL, and MySQL, NoSQL technologies like Cassandra and MongoDB and of course Python
  • You are familiar with industry-standard entity relationship modeling software
  • You are good at analyzing and solving problems
  • You are an excellent communicator, both in writing and verbally
  • You are driven and take the initiative
  • You have skills in : Data and information modeling for relational, semi, and non-structured datasetsGeneral DevOps, such as building infrastructure and CI / CD pipelinesDevelopment management
  • You have a solid understanding of : Data warehousing solutionsData distribution service models and methods, including API-based publish and subscribe architecturesSoftware development lifecycle, including internal enterprise projects and commercialized software products
  • You know how to : Understand business requirements and translate them into conceptual, logical, and physical modelsArticulate and define architectural patterns for data pipelines and ecosystems resilient to growth and changeUse SQL to examine data and load or modify data in relational tablesUse Python or equivalent high-level language to review, load, or modify data in relational tablesCreate reusable scripts to implement, load, and test physical modelsMulti-task, prioritize, and meet deadlines

Why IDEXX?

We’re proud of the work we do, because our work matters. An innovation leader in every industry we serve, we follow our Purpose and Guiding Principles to help pet owners worldwide keep their companion animals healthy and happy, to ensure safe drinking water for billions, and to help farmers protect livestock and poultry from diseases.

We have customers in over 175 countries and a global workforce of over 10,000 talented people.

So, what does that mean for you? We enrich the livelihoods of our employees with a positive and respectful work culture that embraces challenges and encourages learning and discovery.

At IDEXX, you will be supported by competitive compensation, incentives, and benefits while enjoying purposeful work that drives improvement.

Let’s pursue what matters together.

What you can expect from us :

  • Base annual salary target : $170,000-190,000 (yes, we do have flexibility if needed)
  • Opportunity for annual cash bonus and equity package
  • Health / Dental / Vision Benefits Day-One
  • 5% matching 401k
  • Additional benefits including but not limited to financial support, pet insurance, mental health resources, volunteer paid days off, employee stock program, foundation donation matching, and much more!

LI-REMOTE

15 days ago
Related jobs
Promoted
VirtualVocations
Warren, Michigan

A company is looking for a Data Integration Engineer for a remote opportunity. ...

Promoted
Aptiv
Troy, Michigan

Aptiv is seeking a highly skilled and experienced Cloud Data Architect to join our team. This role requires a strategic thinker with strong technical skills and a deep understanding of cloud computing and data architecture. Configure and optimize database instances, automate repetitive tasks, and en...

PricewaterhouseCoopers Advisory Services LLC
Detroit, Michigan
Remote

Managing and developing SAP SuccessFactors integrations using the integration suite on SAP Business Technology Platform (SAP BTP);. We provide comprehensive consulting, system integration and implementation services across multiple SAP applications, products and technologies. Use data and insights t...

V2Soft
Dearborn, Michigan

Lead design discussions, create conceptual data models, logical data models and data dictionaries. Have a deep understanding of data modeling principles and architecture concepts. Guide product teams to create physical data model design and data dictionary. Facilitate discussions to understand sourc...

Highmark Health
MI, Working at Home, Michigan

As a member of the Medicaid Data Integration team, you will provide value to customers by delivering outstanding integration solutions. You will have an opportunity to provide input to Data Integration strategy, helping to set and drive standards and best practices. In this role you will have hands ...

V2Soft
Dearborn, Michigan

Lead design discussions, create conceptual data models, logical data models and data dictionaries. Have a deep understanding of data modeling principles and architecture concepts. Guide product teams to create physical data model design and data dictionary. Facilitate discussions to understand sourc...

ATC
Lansing, Michigan

This position will collaborate with GIS data authors and consumers, Center for Shared Solutions (CSS) GIS Administrators, Roads & Highways specialists, MDOT SDE (Spatial Data Engine) Geodatabase Administrators, information management staff, solution developers and business domain stakeholders, such ...

V2Soft
Dearborn, Michigan

Lead design discussions, create conceptual data models, logical data models and data dictionaries. Have a deep understanding of data modeling principles and architecture concepts. Guide product teams to create physical data model design and data dictionary. Facilitate discussions to understand sourc...

GovServicesHub
Lansing, Michigan

This position will collaborate with GIS data authors and consumers, Center for Shared Solutions (CSS) GIS Administrators, Roads & Highways specialists, MDOT SDE (Spatial Data Engine) Geodatabase Administrators, information management staff, solution developers and business domain stakeholders, s...

Tephra
Detroit, Michigan

Big Data) projects•Must have proven data architecture experience across multiple large scale data warehouse / data lake projects•Experience in data modeling of conceptual, logical and physical models for Enterprise Warehouse environment. This position is for Data and Insights group to expand, streng...