Description IS Business Intelligence Analyst (Individual Contributor)Employment Type: 17 Week Contract, Potential for Extension
Work Arrangement: Mahwah, NJ
Job SummaryThe IS Business Intelligence Analyst will support a large-scale ERP data migration initiative, focusing on validation and reconciliation activities to ensure data integrity as records transition from legacy systems into SAP. This individual contributor role requires advanced SQL expertise, strong analytical judgment, and the ability to operate independently while collaborating with cross-functional migration teams.
The role is highly hands-on and operational, supporting high-volume datasets, migration batch validation, and performance-optimized analytics used for reporting and decision-making.
Key Responsibilities- Support ERP data migration validation efforts to ensure accuracy, completeness, and integrity of data moving from legacy systems into SAP
- Write, troubleshoot, and optimize complex SQL queries and stored procedures to reconcile source and target record counts
- Identify data discrepancies by performing primary key matching across source, target, and error/reject tables
- Build and maintain stored procedures using a layered staging architecture
- Optimize SQL performance on large datasets, including:
- Indexing strategies
- Data type optimization
- Query refactoring and transformation tuning
- Materialize validation and reconciliation results into physical tables for Power BI reporting and analytics consumption
- Perform sampling-based validation when full dataset comparisons are impractical
- Provide on-call and live troubleshooting support during migration execution
- Participate in collaborative working sessions and cross-team problem-solving discussions
- Present validation findings, trends, and risks to technical and non-technical audiences as needed
Requirements Required Qualifications- Strong T-SQL / SQL Server experience
- Demonstrated proficiency with:
- Stored procedures
- Common Table Expressions (CTEs)
- Dynamic SQL
- Staging and layered data patterns
- Experience working with large, complex datasets and performance optimization techniques
- Ability to work independently with minimal supervision while exercising sound professional judgment
- Strong communication skills with the ability to explain technical findings clearly
Preferred Qualifications- ERP data migration experience (e.g., SAP, JD Edwards, Oracle)
- Familiarity with Azure Data Factory
- Awareness of Power BI reporting and data consumption patterns
- Experience supporting enterprise-scale data transformations and system integrations
Education & Experience- Bachelor's degree or equivalent practical experience
- Relevant experience in business intelligence, data analytics, or data engineering roles preferred
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use and Privacy Notice.
Never miss an opportunity! Create an alert based on the job you applied for.
