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

Is Business Intelligence Analyst

United States, Mahwah · Job Posted May 04, 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
  • 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

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, and life and disability insurance
  • 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
  • Relevant experience in business intelligence, data analytics, or data engineering roles preferred
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, 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
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • eligible to enroll in our company 401(k) plan
  • Fulltime
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

Enterprise Business Intelligence Analyst

Location
Location
United States , Fort Smith
Salary
Salary:
Not provided
aegistherapies.com Logo
Aegis Therapies
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Computer Science, Data Science, MIS, Information Technology, or related field, plus three years of experience within a Power BI environment which includes developing worksheets, dashboards, and data extracts in Power BI, SQL, Stored Procedures, and writing complex queries.
  • Fulltime
Read More
Arrow Right
New

Business Intelligence Analyst

***CANDIDATE MUST BE US Citizen (due to contractual/access requirements)*** The ...
Location
Location
United States , Working at Home
Salary
Salary:
68400.00 - 105900.00 USD / Year
wv.highmarkhealthoptions.com Logo
Highmark Health Options
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree in Math, Computer Science, Analytics, Engineering, Information Science or related field
  • 3 years directly related work experience
  • Proficient to master level with Microsoft Office products including Excel, Power Point, Word, and Access
  • Basic understanding of SQL / querying capabilities
  • Experience with Oracle Cloud Business Intelligence, OTBI, BI Publisher, OACs, FRS, Smartview
  • Familiarity with the Software Development Lifecycle Process and Project Management Lifecycle
  • Strong written and verbal communication skills
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
  • Effective participation in team-based work
  • Ability to find solutions and deliver results within a rapid, fast changing, entrepreneurial, technology-driven culture
Job Responsibility
Job Responsibility
  • Elicit, analyze, document, and validate business requirements through interviews, workshops, and existing documentation
  • Create detailed process flows, use cases, and user stories to clearly define system and process changes
  • Collaborate with stakeholders to prioritize requirements and ensure alignment with business goals
  • Identify opportunities for process improvement and automation
  • Extract, transform, and load (ETL) data from various sources, including Salesforce
  • Perform data analysis to identify trends, patterns, and insights that support business decisions
  • Develop and maintain reports and dashboards using data visualization tools
  • Ensure data quality and accuracy
  • Customize and configure Salesforce to meet specific business needs (e.g., workflows, validation rules, custom objects)
  • Develop simple scripts in Python to automate data processing, system integration, or reporting tasks
  • Fulltime
Read More
Arrow Right
New

Business Intelligence Analyst

As a Business Intelligence Analyst, the beneficiary's job duties will include: ●...
Location
Location
United States , Quincy
Salary
Salary:
54.85 - 55.00 USD / Hour
sar-tech.net Logo
SAR Tech
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Information Systems, Information Technology, Business Analytics, Data Science, Engineering, Mathematics, Statistics, or a closely related field
  • Related experience in business intelligence, data analysis, reporting, dashboard development, and business data management
  • Strong experience working with SQL, data modeling, data warehousing concepts, and relational database management systems
  • Experience developing and maintaining dashboards, reports, and visualizations using business intelligence tools such as Power BI, Tableau, QlikView, or similar platforms
  • Strong knowledge of data analysis, data validation, data transformation, and data quality management techniques
  • Experience gathering business requirements, translating them into technical specifications, and delivering actionable insights to stakeholders
  • Experience working with large datasets and performing data extraction, cleansing, aggregation, and reporting activities
  • Understanding of data warehousing concepts, dimensional modeling, star schema, snowflake schema, and data governance principles
  • Experience using Microsoft Excel, Power BI, Tableau, SQL Server Management Studio (SSMS), and other reporting and analytics tools
  • Understanding of key performance indicators (KPIs), business metrics, forecasting, trend analysis, and decision-support systems
Job Responsibility
Job Responsibility
  • Design, develop, and maintain business intelligence solutions including dashboards, reports, and data visualizations to support organizational decision-making
  • Gather, document, and analyze business requirements from stakeholders and translate them into technical specifications for BI solutions
  • Build and maintain interactive dashboards and reports using BI tools such as Power BI, Tableau, or similar platforms to provide real-time visibility into key performance indicators (KPIs)
  • Conduct data quality assessments and implement data validation processes to ensure reliability of analytical outputs
  • Perform ad hoc analysis and present findings to business stakeholders and senior management to support strategic planning and operations
  • Identify trends, anomalies, and opportunities within business data and provide actionable recommendations to business leaders
  • Work with cross-functional teams including Finance, Operations, and Technology to understand reporting needs and deliver timely analytical solutions
  • Monitor and maintain existing BI infrastructure, proactively identifying and resolving performance bottlenecks and data discrepancies
  • Assist in the evaluation and adoption of new BI tools and technologies to improve analytical capabilities
What we offer
What we offer
  • Medical Insurance
  • 401(k) Retirement Plan
  • Fulltime
Read More
Arrow Right
New

Analyst, Business Intelligence

This position is responsible for analyzing and reporting on the performance of a...
Location
Location
United States , Bellevue
Salary
Salary:
66900.00 - 120600.00 USD / Year
https://www.t-mobile.com Logo
T-Mobile
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree plus 2 years of related work experience OR combination of education and experience deemed equivalent
  • Experience in conducting and communicating data-driven analyses
  • proven experience with quantitative and qualitative analysis and report writing
  • Experience with data analysis tools such as SQL, Google Analytics, or BI tools (Tableau, Looker, Power BI)
  • Excellent writing, editing and proofreading skills
  • Exceptional attention to detail and critical thinking skills
  • Excellent communication skills. Comfortable interacting with and presenting to management, and peers in various departments
  • Strong quantitative analysis skills and high proficiency with all Microsoft Office applications
  • Expertise in Excel, PowerPoint and Word required
  • At least 18 years of age
Job Responsibility
Job Responsibility
  • Develop and maintain dashboards and reports to track KPIs, including CTR, CPA, ROAS, conversion rates, and more
  • Partner with Customer Success and Sales teams to support client presentations and business reviews
  • Communicate insights and recommendations to both technical and non-technical stakeholders in clear and actionable ways to enhance campaign outcomes
  • Respond and produce additional ad hoc reporting analysis requests and assignments as required
  • Also responsible for other duties/projects as assigned by business management as needed
What we offer
What we offer
  • Competitive base salary and compensation package
  • Annual stock grant
  • Employee stock purchase plan
  • 401(k)
  • Free, year-round money coaches
  • Medical, dental and vision insurance
  • Flexible spending account
  • Paid time off and up to 12 paid holidays
  • Paid parental and family leave
  • Family building benefits
  • Fulltime
Read More
Arrow Right
New

Senior Business Intelligence Analyst

Location
Location
United States
Salary
Salary:
107000.00 - 150000.00 USD / Year
anaconda.com Logo
Anaconda
Expiration Date
August 12, 2026
Flip Icon
Requirements
Requirements
  • 5+ years of experience in business intelligence, analytics engineering, or a closely related function
  • Advanced SQL proficiency: complex joins, window functions, query optimization, and performance tuning at scale
  • Hands-on experience with dbt in a production environment: model design, testing, documentation, and incremental/snapshot strategies
  • Experience with a modern cloud data warehouse (Snowflake strongly preferred)
  • Demonstrated use of statistical methods in a business context with clear evidence of the outcomes produced
  • Strong data visualization skills with the ability to make complex data accessible to non-technical audiences and answering the WHEN, WHO, WHAT, HOW & if possible the WHY
  • Track record of partnering with cross-functional stakeholders and influencing how they use and interpret data
  • Authorized to work in the United States without sponsorship, now or in the future
Job Responsibility
Job Responsibility
  • Design, build, and maintain production-grade dbt models and SQL pipelines in Snowflake
  • Architect dashboards and analytical frameworks in OMNI
  • Own data quality end-to-end
  • Automate recurring reporting workflows and triage ad hoc requests efficiently
  • Move from reporting to recommending
  • Apply statistical methods (regression, cohort analysis, A/B test interpretation, time-series modeling) to uncover insights
  • Lead ROI analyses and quantitative deep dives on strategic initiatives
  • Proactively identify trends, risks, and opportunities in the data
  • Partner closely with finance, GTM, customer success, and marketing
  • Help stakeholders ask better questions over time
What we offer
What we offer
  • Flexible Vacation Policy
  • Medical, Dental, and Vision Insurance
  • Short Term and Long Term Disability
  • Paid Parental Leave
  • Monthly Wellness Stipend
  • Employee Assistance Program and Mental Health Resources
  • Fulltime
Read More
Arrow Right