Senior Snowflake Engineer - MDM Architecture Job at Syncredible Solutions, West Virginia

  • Syncredible Solutions
  • West Virginia

Job Description

Job Description

About the Company:

\n

\n

At Syncredible Solutions, we believe in the transformative power of technology. we specialize in Digital transformation services, Enterprise solutions, Power BI Analytics solutions and staffing services.

\n

\n

Job Summary:

\n

\n

We are looking for an experienced Senior Snowflake Engineer with strong Master Data Management (MDM) architecture experience to join the EDH team. This role will be responsible for designing, developing, and supporting enterprise-scale data solutions using Snowflake, AWS, DBT, and modern data integration technologies , with a strong focus on MDM, data quality, data governance, and trusted enterprise data .

\n

\n

The ideal candidate will have deep hands-on experience with Snowflake and modern cloud data engineering, combined with a strong understanding of MDM architecture, master data domains, entity resolution, survivorship, matching, golden records, data quality, and data governance . The candidate should be able to translate MDM business requirements into scalable technical solutions and work across data engineering, architecture, governance, and downstream consuming systems.

\n

\n

Key Responsibilities:

\n

\n
    \n
  • Design, develop, and support enterprise-scale data pipelines using AWS, Snowflake, DBT, and related data engineering technologies .
  • \n
  • Design and implement scalable MDM and master data architecture within the enterprise data platform.
  • \n
  • Define technical solutions for managing master data domains such as Customer, Account, Product, Supplier, Organization, Location, or other enterprise entities .
  • \n
  • Design processes for entity identification, matching, merging, survivorship, golden record creation, and master data distribution .
  • \n
  • Develop data models and structures to support master data, reference data, relationships, hierarchies, and cross-reference mappings .
  • \n
  • Implement MDM solutions using Snowflake and surrounding data platform components while maintaining clear separation between master, transactional, analytical, and reference data .
  • \n
  • Develop and enhance metadata-driven data ingestion, transformation, and MDM processing frameworks.
  • \n
  • Design data pipelines to ingest and consolidate data from multiple source systems into trusted master data structures.
  • \n
  • Implement data quality rules, validation, standardization, cleansing, deduplication, and exception management processes.
  • \n
  • Develop mechanisms to establish and maintain golden records and trusted enterprise identifiers .
  • \n
  • Design and implement source-to-master and master-to-consumer data flows , including downstream distribution and synchronization requirements.
  • \n
  • Support MDM-related integration with operational systems, analytical platforms, APIs, and enterprise applications.
  • \n
  • Develop DBT models, macros, tests, and deployment configurations for data transformation and MDM processing.
  • \n
  • Implement Snowflake solutions including database design, data loading, transformation, security, performance optimization, and operational support.
  • \n
  • Troubleshoot and debug data pipeline and MDM processing issues across AWS, Snowflake, DBT, and PySpark .
  • \n
  • Perform root cause analysis of data quality, matching, integration, and master data issues.
  • \n
  • Establish monitoring and operational processes for data quality, MDM pipelines, master data completeness, and data reconciliation .
  • \n
  • Collaborate with data architects, business stakeholders, data governance teams, and engineering teams to define enterprise data standards and MDM requirements.
  • \n
  • Provide technical leadership, conduct code reviews, and mentor other engineers.
  • \n
  • Participate in architecture discussions and recommend improvements to the enterprise data and MDM platform.
  • \n
  • Support CI/CD, deployment automation, environment promotion, and production releases.
  • \n
\n

\n

Required Technical Skills:

\n

\n

Snowflake:

\n

Strong hands-on experience with Snowflake architecture and development, including database design, data modeling, data loading, transformation, performance tuning, security, and optimization.

\n

MDM Architecture:

\n

Strong experience designing and implementing Master Data Management solutions and architectures . Understanding of master data domains, golden records, entity resolution, matching and merging, survivorship, hierarchies, relationships, cross-reference identifiers, and master data distribution.

\n

Data Engineering:

\n

Strong hands-on experience building enterprise data pipelines and data integration solutions using cloud-based data platforms.

\n

AWS:

\n

Strong hands-on experience with AWS data services and building scalable cloud data ingestion and processing solutions.

\n

DBT:

\n

Strong hands-on experience developing DBT models, macros, tests, documentation, and deployment processes.

\n

Data Modeling:

\n

Strong experience with conceptual, logical, and physical data modeling, including dimensional models, normalized models, master data models, reference data, hierarchies, and relationships.

\n

Data Quality:

\n

Experience implementing data quality frameworks including profiling, validation, standardization, cleansing, deduplication, reconciliation, and exception handling.

\n

SQL:

\n

Strong SQL skills including complex queries, data transformation, performance tuning, and optimization.

\n

PySpark:

\n

Experience developing PySpark applications for data ingestion, transformation, cleansing, and large-scale data processing.

\n

Data Integration:

\n

Experience integrating data from multiple enterprise source systems and designing scalable source-to-target data flows.

\n

DevOps / CI/CD:

\n

Experience with Git, CI/CD pipelines, deployment automation, release management, and environment promotion.

\n

\n

Equal Opportunity Statement:

\n

\n

Syncredible Solutions is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Job Tags

Similar Jobs

Wolverine Cosmetic Dental

Dental Receptionist Job at Wolverine Cosmetic Dental

 ...include greeting patients, scheduling appointments, answering phones, collecting payments, filing insurance claims, managing patient records, maintaining office inventory, assisting patients, and keeping the office clean. Dentrix is a plus, experience required.... 

Firewatch Contracting of Florida LLC

Construction Estimating Assistant Job at Firewatch Contracting of Florida LLC

Job Description Job Description Job Overview: As an Estimating Administrator, you will play a critical role in supporting Senior Estimators and the estimating team in the preparation of proposals, bid documents, and managing subcontractor relationships. You will serve...

Kendall Dealership Holdings LLC

Automotive Salesperson Job at Kendall Dealership Holdings LLC

 ...career. Some of the benefits of working with Kendall as a Salesperson are ~ Competitive pay plan / no cap on earnings earn up to...  ...development opportunities ~ Competitive paid time off ~ Discounts on parts, service and vehicle purchases for you and your immediate... 

PJ Fitzpatrick

Part Time Brand Ambassador Job at PJ Fitzpatrick

 ...skills, and learn the foundation of closing dealsall while having fun and making money! What Youll Do: Represent our brand at exciting events like home shows, retail locations, and community expos Engage with potential customers, spark conversations, and... 

Comec Energy Services

Wellhead Packing Replacement Crew. Job at Comec Energy Services

Comec is looking to add local experienced wellhead servicing personnel to our growing company. The personnel should be experience with various well heads and used to various weather conditions. Packing crew will be responsible for the isolation, removal and replacement...