Develop and optimize complex SQL queries, views, and stored procedures to support analysis, reporting, validation, and defect resolution. Conduct deep data analysis and root-cause investigations to troubleshoot system and production issues. Extract, reconcile, and validate data across environments for solutioning, testing, and QA. Support performance tuning by analyzing queries, execution plans, batch jobs, and system throughput. Perform smoke testing and post-release validation to ensure data integrity and system stability.
Partner with data conversion teams on migration planning, data loads, reconciliation, and validation. Ensure converted data is accurate, complete, and aligned with business and policy intent. Validate configuration syncs (e.g., Redgate) across environments. Analyze and reconcile interface outputs, extracts, reports, and feeds. Validate X12 EDI transactions (834, 837, 835, 820, 999/277) for structure, content, and outcomes. Manage reference data and standard code sets, investigating discrepancies.
Translate business requirements into technical specifications and solution models in collaboration with Business Analysts. Utilize Data Element Dictionaries (DEDs) to understand structures and dependencies. Document data flows, integrations, and system relationships. Conduct feasibility analysis to identify constraints, impacts, and dependencies. Contribute technical insight in design workshops and present risks, impacts, or gaps to governance forums (ARB, CCB).
Support SIT, UAT, parallel, and performance testing by validating data and system behavior. Assist with test data setup, environment readiness, validation scripts, and reconciliation. Analyze and resolve defects related to data, configuration, interfaces, and performance. Support deployments, cutover, hypercare, and post-production issue resolution.
Act as a technical liaison across Business Analysts, developers, QA, configuration, conversion teams, and operations. Clearly communicate findings, risks, and resolutions. Collaborate on data mappings and validation with configuration teams. Mentor junior analysts on SQL, data standards, troubleshooting, and documentation. Lead sub-tracks within technical workstreams as needed.
Deliver accurate, actionable data insights supporting design and testing decisions. Produce clear documentation of data flows, integrations, and dependencies. Provide timely support for data validation and remediation across the SDLC. Foster strong cross-functional collaboration and alignment.
