CrawlJobs Logo
Robert Half Logo Robert Half · IT - Software Development

IS Business Intelligence Analyst

United States, Mahwah · Job Posted April 16, 2026
Apply Position
Job Link Share

Job Description

The 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.

Job Responsibility

  • 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

  • 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
  • Bachelor’s degree or equivalent practical experience
  • Relevant experience in business intelligence, data analytics, or data engineering roles preferred

Nice to have

  • 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

What we offer

  • medical
  • vision
  • dental
  • life and disability insurance
  • eligible to enroll in our company 401(k) plan
Robert Half - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

IS Business Intelligence Analyst

8 matching positions

Is Business Intelligence Analyst

The IS Business Intelligence Analyst will support a large-scale ERP data migrati...
Location
Location
United States , Mahwah
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 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
  • Bachelor's degree or equivalent practical experience
Job Responsibility
Job Responsibility
  • 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
  • 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
What we offer
What we offer
  • Medical, vision, dental, and life and disability insurance
  • 401(k) plan
Read More
Arrow Right

Business Analyst – Business Intelligence

We are seeking a Business Analyst – Business Intelligence to join our Financial ...
Location
Location
Philippines , Clark Freeport Zone, Pampanga
Salary
Salary:
Not provided
wyndhamdestinations.com Logo
Wyndham Destinations
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Degree in Economics, Statistics, Data Science, Engineering, Finance, or a related field
  • 3+ years of work experience in Business Analysis, Data Analysis, Business Intelligence, and/or Data Science
  • Experience developing and maintaining reports using business intelligence reporting tools (e.g., Tableau, Power BI)
  • Advanced Tableau reporting capability covering complex calculations (e.g., level of detail expressions, nested formulas, table calculations), multi-source data blending, and scalable data modelling is highly regarded
  • Strong analytical mindset
  • Excellent data management and systems skills
  • Meticulous attention to detail with a high level of accuracy and self-review
  • Advanced modelling skills using Microsoft Excel
  • Well-developed communication and interpersonal skills, with the ability to liaise effectively with senior management and business operations
  • Ability to multitask and work effectively to deliver results within strict timeframes
Job Responsibility
Job Responsibility
  • Develop and maintain accurate, meaningful reports and dashboards using Tableau software based on defined KPIs
  • Review existing information flows, define information and data requirements, and support the management of information and data to meet business needs while sustaining data integrity
  • Partner with the business to develop innovative solutions to problems and suggest new approaches to reporting, analysis, and business process improvement
  • Assist with project work, feasibility studies, and variance analysis
  • Provide modelling and analytical support to the FP&A team
  • Assist with the provision and review of data for current and future bonus plans, and help address related data queries
  • Support the budget and forecast processes
  • Fulltime
Read More
Arrow Right

Senior Business Analyst, Business Intelligence Center

Drive and lead initiatives to maximize opportunities as it relates to business p...
Location
Location
United States , Houston
Salary
Salary:
Not provided
sysco.com Logo
Sysco
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in mathematics, statistics, computer science or related field
  • 5 - 8 years’ experience with hands-on data visualization design and development in large-scale and complex environments
  • Experience with SQL
  • Experience with Tableau and Tableau Server
Job Responsibility
Job Responsibility
  • Collect and analyze data for potential business expansion
  • Identify specific business opportunities
  • Influence stakeholders to support business projects
  • Define projects and partner with other teams to produce better business outcomes
  • Ensure optimization and validation initiatives are implemented, tracked and reviewed postproduction
  • Test business processes and recommend improvements
  • Review and provide feedback on technical deliverables from peer and junior analysts
  • Fix and research highly complex or difficult technical problems
  • Visualize, design and prepare data in a framework that can be utilized by served and self-serving stakeholders
  • Shape, explore and propose data for business analysis or stakeholder initiatives using core Business Intelligence (BI) tools
  • Fulltime
Read More
Arrow Right
New

Analyst, Business Intelligence

Location
Location
Canada , Dorval
Salary
Salary:
Not provided
bombardier.com Logo
Bombardier
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • You hold a degree in Engineering, Computer Science, Data Analytics, Statistics, or a related field
  • You have experience in data analysis or business intelligence
  • You demonstrate strong analytical skills and excellent synthesis abilities
  • You have strong communication skills and can translate complex information into clear insights
  • You are autonomous, detail-oriented, and results-driven
  • You are comfortable working in cross-functional and performance-driven environments
  • You are proficient with BI tools (Power BI, PowerApps, Power Automate), as well as SQL and advanced Excel
Job Responsibility
Job Responsibility
  • Collect, structure, and analyze data from multiple sources (ERP systems, operations, quality, etc.)
  • Develop and maintain dashboards, reports, and Key Performance Indicators (KPIs) using BI tools (e.g., Power BI)
  • Identify trends, gaps, risks, and opportunities through data analysis
  • Deliver clear, structured, and actionable insights to operational teams and leadership
  • Collaborate with stakeholders to understand business needs and translate them into analytical solutions
  • Ensure data quality, consistency, and governance
  • Automate and optimize reporting and performance tracking processes
  • Support decision-making through robust analysis and data-driven recommendations
  • Contribute to the continuous improvement of processes related to data management and utilization
What we offer
What we offer
  • Insurance plans (Dental, medical, life insurance, disability, and more)
  • Competitive base salary
  • Retirement savings plan
  • Employee Assistance Program
  • Tele Health Program
  • Fulltime
Read More
Arrow Right
New

Business Intelligence Analyst

Location
Location
United States , Mansfield
Salary
Salary:
47.39 - 47.50 USD / Hour
sar-tech.net Logo
SAR Tech
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Business Analytics, Information Systems, Computer Science, Statistics, Mathematics, Finance, Economics, or a closely related field
  • Related experience in Business Intelligence, Data Analysis, Reporting, and Dashboard Development
  • Strong experience with BI tools such as Power BI, Tableau, Qlik Sense, Looker, or similar data visualization platforms
  • Proficiency in SQL, database querying, data modeling, and working with relational databases such as SQL Server, Oracle, MySQL, or PostgreSQL
  • Experience gathering business requirements, analyzing data, and translating business needs into actionable insights and reports
  • Strong understanding of data warehousing concepts, ETL processes, data integration, and data governance practices
  • Experience working with large datasets and performing data validation, cleansing, and quality assurance activities
  • Proficiency in Microsoft Excel, including advanced formulas, pivot tables, Power Query, and data analysis techniques
  • Strong analytical, problem-solving, communication, presentation, organizational, and stakeholder management skills
  • Ability to create clear reports, dashboards, and visualizations to support executive and operational decision-making
Job Responsibility
Job Responsibility
  • Design, develop, and optimize complex SQL queries, stored procedures, and data pipelines to process and analyze large-scale structured datasets from SQL Server and Snowflake environments
  • Create a delegate business analysis and test the data from end-to-end validation
  • Budgeting, Forecasting, Pricing, Reporting, Documentation, Planning, Monitoring, Reviews and variance analysis
  • Document all the test artefacts including test cases, test planes, Requirement analysis docs in JIRA
  • Validated all the Asset data validations and Regression on BUAT/UAT, JSIT, and Parallel PROD APIs
  • Engineer and deploy data validation and quality assurance frameworks using Python, SQL, and VBA to enforce data integrity, consistency, and referential accuracy
  • Test integration testing for UP stream and low stream services - API and DB, UI
  • Validate Core data, Custom data requirements on feed load, smoke test, daily load checks, regression activities, Indices and interfaces validations, PMAR data, MSCI data, and Benchmark data
  • Perform advanced data analysis, statistical evaluation, and reconciliation of multi-source datasets using Python (Pandas, NumPy) and SQL
  • Apply data modeling techniques, normalization principles, and schema design to build scalable and efficient data structures
What we offer
What we offer
  • Medical Insurance
  • 401(k) Retirement Plan
  • Fulltime
Read More
Arrow Right
New

Business Intelligence Analyst

Location
Location
United States , Irvine
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2+ years of experience developing Power BI reports and dashboards from scratch
  • Hands-on experience supporting Microsoft Dynamics 365 Finance & Operations (F&O), Dynamics 365 Customer Engagement (CE/CRM), or both
  • Understanding of Dynamics 365 data models, tables, entities, and business processes
  • Strong data visualization skills with the ability to present complex business data in a clear and actionable format
  • Experience working with relational data structures and integrating data from multiple sources
  • Ability to work directly with business users and executive stakeholders to define reporting requirements
  • Strong analytical and problem-solving skills
Job Responsibility
Job Responsibility
  • Develop and maintain Power BI dashboards and reports that support sales, inventory, finance, and operational reporting
  • Leverage expertise in Dynamics 365 F&O and Dynamics 365 CE/CRM to ensure accurate reporting and data interpretation
  • Analyze Dynamics 365 data structures, relationships, and workflows to build scalable reporting solutions
  • Partner with business stakeholders to gather requirements and translate them into executive-level dashboards and self-service reporting tools
  • Support companywide initiatives to integrate and unify data across Dynamics 365 platforms
  • Create reporting solutions that combine ERP and CRM data into a single source of truth
  • Improve report performance, usability, and adoption across the organization
  • Assist with the migration of reporting assets from Azure Synapse to Microsoft Fabric
  • Validate, test, and optimize reporting solutions within Microsoft's modern data ecosystem
  • Help reduce reliance on ad-hoc reporting by delivering trusted, centralized business intelligence solutions
Read More
Arrow Right

Business Intelligence Analyst

Our Edmonton client is seeking a talented Power BI Developer to join their team ...
Location
Location
Canada , Edmonton
Salary
Salary:
Not provided
https://www.randstad.com Logo
Randstad
Expiration Date
August 06, 2026
Flip Icon
Requirements
Requirements
  • Post-secondary degree, diploma, or certificate in Computer Science or a related field
  • Five years of experience designing advanced Power BI solutions and translating business requirements into BI tools
  • Five years of experience developing complex measures, calculated columns, and advanced time intelligence using DAX
  • Five years of experience using SQL for data transformations, querying, and analytical processing in large environments
  • Four years of experience implementing Power BI Service features like workspaces, data refreshes, and row-level security
Job Responsibility
Job Responsibility
  • Design and develop data models and visualizations using Microsoft Power BI and Azure data platforms
  • Create optimized, reusable data models using DAX and Power Query M for enterprise reporting
  • Build interactive dashboards, scorecards, and visual analytics tailored to specific business needs
  • Collaborate with business users, data architects, and data engineers to manage data pipelines
  • Gather reporting requirements and KPIs from various business units to translate into BI solutions
  • Implement data refresh strategies, row-level security, and performance tuning within Power BI Service
  • Integrate AI capabilities to automate data exploration, identify trends, and generate insights
  • Fulltime
Read More
Arrow Right

Business Intelligence Analyst

The Digital Planning Transformation program is a global initiative designed to m...
Location
Location
Mexico , Miguel Hidalgo
Salary
Salary:
Not provided
pepsico.com Logo
Pepsico
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience in management and performance reporting
  • Strong ability to translate business requirements into scalable reporting and dashboard solutions
  • Experience with data and systems management in a financial or performance reporting environment
  • Advanced technical proficiency in Tableau
  • Strong Excel skills for analysis, modeling, and reporting
  • 0–1 year of professional experience in finance, analytics, reporting, or a related field
  • Advanced English
Job Responsibility
Job Responsibility
  • Partner with Operating Units and Functions to gather and clarify reporting requirements
  • Design and develop end-to-end financial performance dashboards with drill-down capabilities
  • Build and deploy standardized reporting frameworks and harmonized dashboards
  • Continuously enhance and evolve dashboards, tools, and systems to improve usability and performance
  • Proactively identify improvement opportunities and lead the implementation of enhancements
  • Collaborate closely with S&T teams to ensure business requirements are accurately translated into Cockpit designs
  • Analyze how end-users (analysts and senior leaders) consume data and tailor solutions accordingly
  • Deliver new dashboard features and improve user experience and system performance
  • Ensure financial data security, compliance, and alignment with corporate and sector FP&A standards
  • Support training and enablement of Cockpit users
What we offer
What we offer
  • Opportunities to learn and develop every day through a wide range of programs
  • Internal digital platforms that promote self-learning
  • Development programs according to Leadership skills
  • Specialized training according to the role
  • Learning experiences with internal and external providers
  • Recognition programs for seniority, behavior, leadership, moments of life, among others
  • Financial wellness programs that will help you reach your goals in all stages of life
  • A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle
  • Wellness Line
  • thousands of Agreements and Discounts
Read More
Arrow Right