Back to jobs

Business Intelligence Developer

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design and implement ETL routines that load source data into the Data Warehouse

  • Develop models, scorecards and dashboards with drill-down and drill-through

  • Tune ETL performance and manage BI job scheduling and monitoring

  • Translate business needs into technical BI designs using rapid prototyping

  • Research and resolve data integrity and performance problems

From the employer’s posting
Design and implement new features and enhancements to the existing ETL routines responsible for loading data from the sources systems into the Data Warehouse.
Develop Models, Scorecards, and Dashboards with drill-down and drill-through capabilities.
Perform performance tuning on the ETL.
Translate business needs into technical designs for BI solutions.
Research and resolve data integrity and performance needs.

Before you apply

Employer’s visa record
6 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Apply at Standard Motor Products

Posting record

Report an error

Open 5 monthsWe first saw this posting 178 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
May 27, 2026178 days ago
Recorded sightings
143
Last seen by us
Nov 22, 2026
Employer says posted
Apr 7, 2025

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 178

Up longer than most. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

Standard Motor Products is hiring

1 open job

  • No new data jobs since July
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Db2
  • Power BI
  • SQL Server
  • SSIS
  • SSRS
Where the posting names them
Essential Functions:• Translate business needs into technical designs for BI solutions. • Apply rapid prototyping and iterative development methodologies as appropriate to ensure solution keeps pace with business needs. • Design and implement new features and enhancements to the existing ETL routines responsible for loading data from the sources systems into the Data Warehouse. • Develop and manage BI job scheduling and monitoring. • Perform performance tuning on the ETL. • Participate in near and long-term capacity planning for BI. • Develop Models, Scorecards, and Dashboards with drill-down and drill-through capabilities. • Research and resolve data integrity and performance needs. • Strong communications skills both oral and written. • Work with other IT delivery teams such as business analyst, security analyst and infrastructure to meet project goals. WORK EXPERIENCE REQUIREMENTS Experience: • Minimum 3-4 years of experience in relational Data Modeling. • Minimum 3-4 years of experience with the Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI Desktop, Power BI Pro, Power BI Report Server).• Minimum 3-4 years of experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.• Experience with flat files and other databases (Fixed Width, CSV, SQL Server & DB2 preferred).• Demonstrated ability to deliver high impact business intelligence solutions in complex environments. Knowledge, Skills and Abilities• Hands on implementation experience in data profiling, designing, implementing and performance tuning ETL processes using SSIS from multiple data sources and 200+ million record source data tables. • Extensive knowledge of the Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI Desktop, Power BI Pro, Power BI Report Server). • Experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.• Knowledge of BI security best practices. • Experience creating documentation, and diagrams that communicate the overall architecture of the solution to business, technical audiences, and support teams. • Excellent knowledge of prototyping & proof of concept mechanisms.• Experience with BI Architecture data modeling in SQL Server. • Experience with integrating BI with JD Edwards, and advanced SQL Server database tuning and performance monitoring is a plus. EDUCATION REQUIREMENTS • Bachelor’s degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred.• Specific work experience considered. Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Your next step

Complete your application on jobs.dayforcehcm.com. The employer’s form will show what is required.

Applying through Dayforce

  • The application asks you to sign in to the employer’s Dayforce candidate portal, or create an account there.

Already applied? Track this application

Job description

View original posting ↗

Essential Functions:•    Translate business needs into technical designs for BI solutions. •    Apply rapid prototyping and iterative development methodologies as appropriate to ensure solution keeps pace with business needs. •    Design and implement new features and enhancements to the existing ETL routines responsible for loading data from the sources systems into the Data Warehouse. •    Develop and manage BI job scheduling and monitoring.  •    Perform performance tuning on the ETL. •    Participate in near and long-term capacity planning for BI.  •    Develop Models, Scorecards, and Dashboards with drill-down and drill-through capabilities. •    Research and resolve data integrity and performance needs. •    Strong communications skills both oral and written. •    Work with other IT delivery teams such as business analyst, security analyst and infrastructure to meet project goals.  WORK EXPERIENCE REQUIREMENTS Experience: •    Minimum 3-4 years of experience in relational Data Modeling. •    Minimum 3-4 years of experience with the Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI Desktop, Power BI Pro, Power BI Report Server).•    Minimum 3-4 years of experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.•    Experience with flat files and other databases (Fixed Width, CSV, SQL Server & DB2 preferred).•    Demonstrated ability to deliver high impact business intelligence solutions in complex environments. Knowledge, Skills and Abilities•    Hands on implementation experience in data profiling, designing, implementing and performance tuning ETL processes using SSIS from multiple data sources and 200+ million record source data tables. •    Extensive knowledge of the Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI Desktop, Power BI Pro, Power BI Report Server). •    Experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.•    Knowledge of BI security best practices. •    Experience creating documentation, and diagrams that communicate the overall architecture of the solution to business, technical audiences, and support teams.  •    Excellent knowledge of prototyping & proof of concept mechanisms.•    Experience with BI Architecture data modeling in SQL Server. •    Experience with integrating BI with JD Edwards, and advanced SQL Server database tuning and performance monitoring is a plus. EDUCATION REQUIREMENTS •    Bachelor’s degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred.•    Specific work experience considered. Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.        #LI-ER1 #LI-HYBRID

About Standard Motor Products

People
About 5,700 in 2025, up 2% from the year before.Annual report (SEC Form 10-K)
Company
Listed as SMP.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Lewisville, TX, USA

Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. #LI-ER1 #LI-HYBRID
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.