Job Title: Business Analyst / Data Analyst with Testing Experience
Location: Princeton, NJ
Duration: Long-Term Contract

We are seeking a highly skilled Business / Data Analyst with strong expertise in data analysis, ETL testing, SQL validation, and business requirements gathering. The ideal candidate will bridge the gap between business stakeholders, data engineering teams, and QA by ensuring accurate data movement, transformation, and reporting integrity across enterprise systems.

Key Responsibilities

• Gather, analyze, and document business, functional, and data requirements from stakeholders, product owners, and technical teams.
• Translate business needs into detailed BRDs, FRDs, user stories, process flows, source-to-target mapping, and data lineage documentation.
• Perform end-to-end ETL testing for data warehouse, data lake, and reporting solutions across source, staging, and target environments.
• Design and execute complex SQL queries for data profiling, reconciliation, validation, and root cause analysis.
• Validate data transformations, joins, aggregations, filtering logic, stored procedures, views, and business rules implemented within ETL pipelines.
• Work closely with ETL developers to verify data extraction, transformation, load jobs, and batch workflows using tools such as Informatica, SSIS, Talend, DataStage, or cloud-native pipelines.
• Perform source-to-target data mapping validation to ensure field-level accuracy, referential integrity, and completeness of migrated data.
• Create and maintain test cases, test scenarios, test scripts, and defect reports for data integration and reporting solutions.
• Conduct data quality checks including null validation, duplicate detection, data type validation, boundary testing, and historical trend reconciliation.
• Support UAT, SIT, regression, and production validation testing for enterprise data platforms and BI reporting systems.
• Collaborate with business teams, developers, DBAs, and reporting teams to resolve data discrepancies, ETL failures, and performance bottlenecks.
• Analyze large datasets using advanced SQL involving CTEs, window functions, temp tables, joins, unions, indexing concepts, and query optimization.
• Ensure compliance with data governance, privacy, security, and audit requirements during data validation and reporting processes.
• Participate in Agile ceremonies, sprint planning, backlog grooming, defect triage, and release validation activities.

Required Skills

• Strong experience as Business Analyst / Data Analyst / ETL QA Analyst
• Excellent hands-on expertise in advanced SQL
• Solid experience in ETL testing and data warehouse validation
• Experience with source-to-target mapping and data lineage
• Strong knowledge of data models, fact/dimension tables, star schema, and relational databases
• Strong communication, documentation, and stakeholder management skills

Preferred Qualifications

• Knowledge of data governance and compliance standards
• Exposure to Python, shell scripting, or automation testing for data pipelines
• Experience working in Agile / Scrum delivery models