CrawlJobs Logo

Is Business Intelligence Analyst

https://www.roberthalf.com Logo

Robert Half

Location Icon

Location:
United States , Mahwah

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided
Save Job
Save Icon
Apply Position

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

Additional Information:

Job Posted:
May 04, 2026

Work Type:
On-site work
Icon
Robert Half - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Is Business Intelligence Analyst

Business Intelligence Analyst

We are looking for a skilled Business Intelligence Analyst to join our team in H...
Location
Location
United States , Hartford County, Connecticut
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum of 3 years of experience in business intelligence or data analytics roles
  • Proficiency in Microsoft Power BI and other BI tools
  • Strong ability to create and test dynamic reports and dashboards
  • Familiarity with Business Intelligence and Reporting Tools (BIRT) or similar platforms
  • Solid understanding of database administration and management
  • Excellent analytical skills with a strong attention to detail
  • Effective communication skills for presenting data insights to stakeholders
  • Knowledge of data governance principles and best practices
Job Responsibility
Job Responsibility
  • Design, develop, and maintain business intelligence dashboards and reports using Microsoft Power BI
  • Collaborate with stakeholders to understand reporting needs and translate them into actionable data solutions
  • Conduct thorough testing of reports to ensure accuracy and reliability
  • Manage database systems and ensure proper administration for optimal performance
  • Review and analyze data to identify trends, patterns, and opportunities for business improvement
  • Present findings and insights to stakeholders in clear and compelling formats
  • Set up and maintain workspaces in business intelligence tools to streamline reporting processes
  • Provide technical support and guidance to team members on BI tools and methodologies
  • Ensure compliance with data governance policies and best practices
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • 401(k) plan
  • free online training
  • Fulltime
Read More
Arrow Right

Business Intelligence Analyst

Business Intelligence Analyst positions! Permanent Position / Direct Hire!
Location
Location
United States , Boston
Salary
Salary:
47.50 USD / Hour
sar-tech.net Logo
SAR Tech
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree or its foreign equivalent in Computer Science, CIS, MIS, Business, or related field
  • Ability to work in a project driven environment
  • Experience or desire to work in an agile environment
Job Responsibility
Job Responsibility
  • Analyze and re-engineer client onboarding processes for State Street Front to Back-office services (Transaction Management, Recording Keeping, Corporate Actions, OTC derivatives, Performance & analytics, etc.)
  • Conduct Gap Analysis and ensure product modules fit overall business solutions, collaborating with technical units for order management and compliance
  • Identify critical modules, confirm inventory with Client SMEs, and improve architecture implementation for efficiency
  • Validate daily data updates in CRIMS and create model orders in CRD to verify workflow and trade validation
  • Design ETL architecture for data transfer to ESP, manage ETL processes for Data Completeness, Transformation, and Quality, and map client legacy data
  • Collaborate with ESP development team to resolve issues, provide automation requirements, and integrate Front, Middle, and Back Office frameworks
  • Manage Program Plan and Roadmap, ensuring efficient client management, monitoring high-risk items, and establishing escalation plans
  • Review test approaches and SQL/PL/SQL codes, performing various testing methods (backend, frontend, UI, database, integration, etc.)
  • Ensure performance attribution methodologies meet client requirements, participate in Agile/Scrum meetings, and manage the testing pipeline and automation tasks
  • Provide support and expertise in performance-related projects and ad-hoc requests
  • Fulltime
Read More
Arrow Right

Sap business intelligence analyst

Location
Location
Salary
Salary:
Not provided
tranzeal.com Logo
Tranzea
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s Degree in Business, Computer Science, Engineering Management is a must
  • Strong understanding of SAP BW, SAP HANA, SAP Business Objects
  • Preferred 8 years of IT experience in the technical and Analysis areas, Database SQL knowledge
  • Knowledgeable in BI Best Practices, Information Management, Data Management
  • Strong understanding of business intelligence and data warehouse principles and technology.
  • Demonstrated ability to work effectively as a leader in a team environment.
  • Good verbal and written communication skills.
Job Responsibility
Job Responsibility
  • Conduct requirements gathering workshops, Feasibility analysis and solution evaluation, Requirements elicitation and translation to Functional specifications utilizing SAP HANA views, SQL queries, ABAP routine, data base tables, extractors and transformation (ETL), SAP Business Objects Cloud and SAP predictive analytics 2.0 to devise and apply robust and critical reporting solutions
  • Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products, Assessing legacy reporting solution written in Batch scripts, SQL scripts, and providing and revising reporting solutions to satisfy business requirements using SAP BW, SAP S/4 HANA, SAP Native HANA, and Reporting solutions
  • Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability
  • Anchor proof of concept (POC) development to validate proposed solution and reduce technical risk, developing systems requirements, designing and prototyping testing and training, defining systems strategy and support procedures, and implementing practical business solutions using SAP Business Warehouse (BW), SAP HANA Database, and SAP and non-SAP Reporting tools
  • Design applications based on identified architecture and support implementation of design by resolving complex technical issues faced by the IT project team during development, deployment and support and responsible for database design showing entity relationship diagrams for SAP BW model created
  • Perform query performance optimizations on Business Objects, SAP BW writing code to tune Performance SAP BW code and SAP Bex query code
  • Formulate cut-over strategies for transitioning SAP Reporting applications to productive environment
Read More
Arrow Right

Business Intelligence Analyst II

As a BI Analyst, you will be responsible for working closely with many divisions...
Location
Location
United States , Bethesda
Salary
Salary:
Not provided
aledade.com Logo
Aledade, Inc.
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 3+ years of experience in business intelligence
  • 2+ years of experience in data management and data manipulation skills, including a strong foundation in SQL programming
  • 1+ years of experience working with healthcare data (e.g. claims, EHR, clinical)
  • Sitting for prolonged periods of time
  • Extensive use of computers and keyboard
  • Occasional walking and lifting may be required
Job Responsibility
Job Responsibility
  • Working with teams across Aledade to translate your findings into action
  • Build interactive dashboards, reports and powerpoints that effectively communicate insights and motivate action among our internal business operations and partner practices
  • Directly responsible for the design and implementation of data warehouse tables or views to support analysis and reporting
  • Consults with engineering teams to articulate BI reporting needs in upstream data tables
  • Provides insight to decision-makers, creating specifications for reports and analyses to meet business needs
  • Consults with product managers to define reporting metrics for product success
  • Provides technical support and subject matter expertise to peers (e.g. code review)
What we offer
What we offer
  • Flexible work schedules and the ability to work remotely are available for many roles
  • Health, dental and vision insurance paid up to 80% for employees, dependents and domestic partners
  • Robust time-off plan (21 days of PTO in your first year)
  • Two paid volunteer days and 11 paid holidays
  • 12 weeks paid parental leave for all new parents
  • Six weeks paid sabbatical after six years of service
  • Educational Assistant Program and Clinical Employee Reimbursement Program
  • 401(k) with up to 4% match
  • Stock options
  • Fulltime
Read More
Arrow Right

Healthcare Business Intelligence & Analytics Analyst

Premium Health Center, a rapidly growing FQCH in Brooklyn, is seeking a detail-o...
Location
Location
United States , Brooklyn
Salary
Salary:
110000.00 - 145000.00 USD / Year
premiumhealth.org Logo
Premium Health
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Data Science, Public Health, Health Informatics, Computer Science, or a related field
  • 4+ years of experience in a BI, data analyst, or similar role, preferably in a healthcare or FQHC setting
  • Strong proficiency in SQL, including complex joins, window functions, and data transformations
  • Hands-on experience with Power BI, or similar BI platform, including DAX, data modeling, and visualization design
  • Experience working with scripting languages (Python, R, etc) and APIs to support data integration and automation
  • Experience with semantic data modeling in Power BI
  • Strong analytical, critical thinking, and problem-solving skills
  • Excellent communication and data storytelling skills with the proven ability to present insights to non-technical audiences
  • Detail oriented with strong data troubleshooting and validation skills
  • Highly organized, with the ability to manage multiple tasks and deadlines
Job Responsibility
Job Responsibility
  • Design, develop, and maintain dashboards, reports, and data visualizations in Power BI (or similar tools)
  • Apply data visualization and storytelling best practices to create intuitive, user-friendly dashboards
  • Translate complex healthcare data into clear, actionable insights that support decisions for clinical, operational, finance, and executive teams
  • Develop and maintain semantic data models, KPIs, and performance metrics aligned with FQHC goals
  • Collaborate with stakeholders to gather requirements and recommend effective analytical and visual solutions
  • Analyze healthcare data from EHR systems (e.g., eClinicalWorks, Office Practicum, etc) and other sources to identify trends, gaps, and opportunities for improvement
  • Support UDS (Uniform Data System) reporting and other regulatory compliance requirements
  • Create sustainable reporting frameworks for recurring healthcare and operational metrics
  • Build and maintain light ETL and data integration tasks using SQL, APIs, and scripting tools
  • Write and optimize SQL queries to support analysis, dashboards, and data pipelines
What we offer
What we offer
  • Medical, Dental, Vision and Life coverage
  • Paid Time Off and holidays
  • Employee Assistance Program
  • Flexible spending account
  • Public Service Loan Forgiveness (PSLF), NHSC Loan Repayment Program
  • 403(b) Retirement Plans with employer matching
  • Fulltime
Read More
Arrow Right

Business Intelligence Analyst - Customer Experience and Insights

The Business Intelligence Analyst plays a central role in supporting business in...
Location
Location
Australia , Geelong; Melbourne
Salary
Salary:
Not provided
apm.net.au Logo
APM Employment Services
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience developing Business Intelligence reports and dashboards in Power BI and Excel using Power Query (M), DAX, VBA, and Excel formulas
  • Proficiency in SQL for data extraction, transformation, and consolidation across multiple complex datasets
  • Proven ability to develop robust data models and translate business requirements into actionable reporting solutions
  • Ability to translate insights into actionable recommendations that support strategic decisions and continuous improvement
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable, user-friendly reporting and analytics solutions aligned with business and customer requirements, incorporating best practice design and user experience principles
  • Analyse reporting requirements to ensure metrics capture impact across all customer touchpoints and operational areas
  • Identify gaps in existing reports and implement improvements to provide actionable insights
  • Collaborate with Team Leaders and Operational Management to align reporting with workforce optimisation and customer experience goals
What we offer
What we offer
  • Flexible / hybrid working arrangements
  • Purchased additional annual leave
  • Private health discounts
  • Opportunity to grow your career
  • Great work-life balance
  • Extensive learning opportunities
  • Networking programs
  • Employee benefits
  • Fulltime
Read More
Arrow Right

Business Intelligence Analyst - Customer Experience and Insights

The Business Intelligence Analyst plays a central role in supporting business in...
Location
Location
Australia , Melbourne
Salary
Salary:
Not provided
apm.net.au Logo
APM Employment Services
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience developing Business Intelligence reports and dashboards in Power BI and Excel using Power Query (M), DAX, VBA, and Excel formulas
  • Proficiency in SQL for data extraction, transformation, and consolidation across multiple complex datasets
  • Proven ability to develop robust data models and translate business requirements into actionable reporting solutions
  • Ability to translate insights into actionable recommendations that support strategic decisions and continuous improvement
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable, user-friendly reporting and analytics solutions aligned with business and customer requirements, incorporating best practice design and user experience principles
  • Analyse reporting requirements to ensure metrics capture impact across all customer touchpoints and operational areas
  • Identify gaps in existing reports and implement improvements to provide actionable insights
  • Collaborate with Team Leaders and Operational Management to align reporting with workforce optimisation and customer experience goals
What we offer
What we offer
  • Flexible / hybrid working arrangements
  • Purchased additional annual leave
  • Private health discounts
  • Opportunity to grow your career
  • Great work-life balance
  • Extensive learning opportunities
  • Networking programs
  • Employee benefits
  • Fulltime
Read More
Arrow Right

Lead Technical Business Analyst

UpGuard is hiring a Lead Technical Business Analyst to support their Analytics t...
Location
Location
Australia , Sydney; Melbourne; Brisbane; Hobart
Salary
Salary:
Not provided
https://www.upguard.com Logo
UpGuard
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6 or more years of experience working in either Data Science, Analytical Research or Business Process Analysis
  • Bachelor's Degree in a Mathematical, IT, Science or Engineering field
  • self-sufficient
  • experience scaling high growth SaaS companies
Job Responsibility
Job Responsibility
  • Enable team and stakeholders to investigate hypotheses and provide actionable insights
  • ensure internal systems are robust and efficient
  • identify areas for process improvement
  • lead research and analysis into key business objectives
  • transform raw data into actionable format
  • understand business processes
  • handle sensitive data securely
  • lead groups of Analysts, Data Engineers, and stakeholders through projects
What we offer
What we offer
  • Stock Options
  • Monthly Lifestyle subsidy
  • WFH set-up allowance
  • $1500 USD annual Learning & Development allowance
  • Generous Annual Leave/PTO allowances
  • 18 weeks paid Parental Leave
  • Personal Leave allowance
  • Fully remote working environment
  • Top spec hardware
  • Generative AI subsidy
  • Fulltime
Read More
Arrow Right