Data Domain Architect - Headcount Reporting & Automation

Testing Site - JPMC; Ohio; On-site; USD 90,000 - 130,000; Full time

Job summary

Testing Site - JPMC is seeking a Data Domain Architect Associate to transform headcount reporting and strengthen data controls. You will own BAU processes and partner with Technology to deliver automated, auditable solutions.

You'll extract and analyze large datasets, translate complex requirements into repeatable reports, and contribute to governance, data lineage, and regulatory readiness across the organization.

Qualifications

• Advanced proficiency in SQL and relational databases, with ability to transform large datasets and develop robust reporting solutions.
• Practical experience with analytics and data-wrangling tools (e.g., Alteryx, SAS, Python), including design of repeatable, auditable workflows and automated pipelines.
• Proven experience in reporting development and testing, including interpreting unstructured or imperfect data to derive objective, defensible insights.
• Strong grounding in data management disciplines, including data lineage, metadata management, and data dictionary stewardship to improve discoverability and reuse.
• Working knowledge of controls frameworks, with experience anticipating audit requirements and instituting effective controls in response to process or architectural changes.
• Expertise in data quality management, including profiling, cleansing, and validation to sustain high-quality data across pipelines and reports.
• Demonstrated delivery of process improvement and automation initiatives, including KPI definition, outcome measurement, and operationalization of best practices.
• Exceptional written and verbal communication skills, with ability to convey complex technical concepts to technical and non-technical audiences.
• Effective stakeholder management and cross-functional collaboration across Finance, Operations, Risk, and Technology.
• Self-directed and intellectually curious, with strong analytical and problem-solving abilities and a preference for action and ownership.

Responsibilities

• Produce accurate, timely weekly and monthly headcount reporting for internal and external stakeholders.
• Coordinate with Finance and Technology to reconcile and validate data across sources and ensure alignment.
• Own day-to-day reporting operations, including triaging and resolving data issues and managing break/fix items.
• Maintain clear runbooks and SOPs to ensure consistent execution and effective knowledge transfer.
• Enhance preventive and detective data controls and quality rules; implement checkpoints as architectures and processes evolve to maintain compliance.
• Ensure audit readiness by maintaining complete evidence, sign-offs, and artifacts for reviews and testing.
• Identify manual pain points and deliver scalable automation; drive continuous improvement from ideation through deployment and post-implementation validation.
• Partner with Technology to prioritize and deliver system and data model enhancements; contribute to requirements, UAT, and change management.
• Translate complex analyses into clear reports and presentations that inform executive and operational decisions.
• Extract, analyze, and summarize large datasets to generate actionable insights for non-technical stakeholders.

Skills

SQL

Data wrangling

Alteryx

SAS

Python

Reporting development

Data governance

Data quality

Process automation

KPI definition

Communication

Stakeholder management

Analytical thinking

Tools

Alteryx

SAS

Python

Job description

Testing Site - JPMC is seeking a Data Domain Architect Associate to transform headcount reporting and strengthen data controls. You will own BAU processes and partner with Technology to deliver automated, auditable solutions.

You'll extract and analyze large datasets, translate complex requirements into repeatable reports, and contribute to governance, data lineage, and regulatory readiness across the organization.