Data Analyst

Summit Tech Partners LLC; Easton (Northampton County); Híbrido; USD 75.000 - 105.000; Jornada completa

Descripción de la vacante

Summit Tech Partners LLC seeks a Data Analyst to support trusted, well-understood enterprise data across source systems, MDM, EDW, analytics, and reporting environments. You will collaborate with business and technical teams to understand data creation, structure, transformations, and consumption.

This hybrid, contract-to-hire role emphasizes data mapping, profiling, governance, and documentation, with a focus on data quality and lineage across complex environments.

Formación

• Understand business processes and data requirements for technical teams.
• Strong SQL skills to profile, reconcile, and validate data.
• Knowledge of data governance concepts and data quality practices.

Responsabilidades

• Analyze and map data across source systems, MDM, EDW, analytics, and reporting environments.
• Develop and maintain source-to-target and field-level mappings; trace data through ETL/ELT.
• Profile, reconcile, and validate data using SQL; identify quality issues.
• Collaborate with stakeholders to document business and data requirements.
• Create repeatable approaches, standards, and templates for mapping and documentation.

Conocimientos

SQL proficiency

Analytical skills

Documentation

Communication

BI knowledge

Herramientas

Snowflake

Descripción del empleo

We are seeking a Data Analyst to support the development of trusted, well-understood enterprise data. This role analyzes, maps, profiles, and documents data across source systems, Master Data Management (MDM), the Enterprise Data Warehouse (EDW), analytics, and reporting environments.

You will work across business and technical teams to understand how data is created, structured, related, transformed, and consumed. The work supports data mapping and reconciliation, data quality analysis, technical lineage, business and data requirements, governed data domains, data modeling, and evolving Data Product initiatives.

This role is ideal for someone who is naturally curious and proactive, enjoys investigating data and learning how systems and business processes work, and follows questions across systems and stakeholders to find the underlying answer.

*This is a hybrid, contract-to-hire opportunity.*

Responsibilities

Data Mapping and Lineage

• Analyze and map data across source systems, MDM, EDW, analytics, and reporting environments to understand definitions, relationships, transformations, and usage.
• Develop and maintain source-to-target and field-level mappings. Analyze current- and future-state data flows and trace data through ETL/ELT processes to document upstream sources, transformation points, downstream dependencies, and potential impacts of data changes.

Data Profiling and Quality

• Use SQL to investigate, profile, reconcile, and validate data. Identify discrepancies, anomalies, and potential data quality issues.
• Partner with Data Engineering, BI, and business stakeholders, using Data Governance practices to investigate root causes, assess impacts, and support resolution of data quality and data alignment issues.

Requirements and Governed Data

• Partner with business stakeholders and subject matter experts to understand business processes, terminology, and data usage. Gather and document business and data requirements for technical teams.
• Help establish consistent definitions, mappings, quality expectations, and authoritative sources for governed data domains.
• Contribute to Data Product discovery and development, and to logical and dimensional data modeling as these capabilities mature.

Ownership, Documentation, and Analytics

• Proactively identify gaps in definitions, mappings, requirements, and documentation; determine appropriate next steps and engage the necessary business or technical stakeholders to help resolve them.
• Develop repeatable approaches, standards, and templates for mapping, profiling, analysis, and documentation to improve consistency and reuse.
• Document analytical findings so that discoveries about systems, business rules, mappings, and data relationships become reusable organizational knowledge.
• Create ad hoc analyses and reports as needed to investigate data questions, validate findings, and share results with stakeholders.

Qualifications

• 3 to 5 years of experience in data analysis, data mapping, or business/data analysis, with exposure to data governance practices.
• Experience working with complex enterprise business data, such as ERP, customer, product, order, inventory, supply chain, or similar operational data. Manufacturing experience is preferred.
• Strong hands-on SQL experience to explore, profile, reconcile, and validate data across relational datasets.
• Solid understanding of relational database concepts, including keys, joins, cardinality, and data grain, and how data moves through ETL/ELT into a data warehouse.
• Experience with data mapping, profiling, or reconciliation, and with gathering and documenting business and data requirements.
• Strong analytical, documentation, and communication skills, with the ability to work with both business and technical teams.
• Experience with Snowflake or a similar cloud data warehouse platform.
• Understanding of BI, analytics, and reporting principles, including how data models, dimensions, measures, calculations, and business rules support downstream reports, dashboards, and analytical solutions.
• Experience using BI or reporting tools to investigate data and communicate findings is a plus.
• Familiarity with data governance concepts, including metadata management, data catalogs, lineage, data quality, stewardship, and authoritative data sources.