Principle Data Architect, Data Integration Hub

IDEXX
US, SC, 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

16 days ago
Related jobs
IDEXX
US, SC, Virtual

Our team includes a range of data engineers, data architects, and data-centric business system analysts, focusing heavily on cloud-based "big data" projects. Understand business requirements and translate them into conceptual, logical, and physical modelsArticulate and define architectural patterns ...

PricewaterhouseCoopers Advisory Services LLC
Spartanburg, South Carolina
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...

ADP
Enterprise Drive, Florence, SC, US

A successful candidate will possess the ability to utilize pre-defined file and non-file based (API) data intake methods to recommend and complete integrations for the purpose of acquiring customer data in support of ADP Tax Credits product administration. Defining data requirements specific to the ...

Crossroads
Charleston, South Carolina

Strong knowledge of data architecture, data warehousing, business intelligence, data integration, data analysis, reporting, and/or machine learning. Experience in the design and development of cloud data solutions including data lake storage, relational data, semi-structured data, streaming data, an...

Bob Jones University
Greenville, South Carolina

Database and Systems Management: Manage The Raiser’s Edge software, including database management, data entry, reporting, training, and data integrity. Develop and implement policies and procedures for donations, stewardship, and database management. Analyze fundraising data to identify trends and c...

Alcoa
Duncan, South Carolina

Provide guidance and oversight to Alcoa’s secure utilization of Data Security - at rest, in motion, in processing including interface / integration methods or technologies. Coordinate with the Security and Risk team to ensure adequate risk management within the application and data security domain. ...

Global Lending Services LLC
Greenville, South Carolina

This role will be responsible for architecture, technology solutions, and services to build and maintain a robust and highly available data hub that will include Data Lake, Data Warehouse, and Data Marts. The Director, Data Integration is responsible for leading a data integration team to build busi...

Genworth Financial
South Carolina
Remote

Creating solution frameworks integrating large or complex data sets. Recommending and creating data and design patterns for common business functionality. ...

PricewaterhouseCoopers Advisory Services LLC
Columbia, South Carolina
Remote

We provide comprehensive consulting, system integration and implementation services across multiple SAP applications, products and technologies. Leading SAP SuccessFactors data migration implementations including from SAP HCM to SAP SuccessFactors;. ...

Highmark Health
SC, Working at Home, South Carolina

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