Senior BI Developer: Data Modeling & Power BI Expert

Standard Motor Products, Inc.

Lewisville (TX)

On-site

USD 100,000 - 140,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Standard Motor Products is seeking a Senior BI/ETL Engineer to translate business needs into scalable BI designs, prototype iteratively, and enhance ETL routines into the Data Warehouse. You will build dashboards and scorecards, manage BI jobs, and fine-tune performance across data sources and 200+ million records.

Collaboration with analysts and security teams is essential. You will contribute to capacity planning, model development, and BI architecture documentation, ensuring data integrity

Qualifications

  • 3–4 years in relational data modeling.
  • 3–4 years with SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI Desktop/Pro/RS).
  • 3–4 years writing DAX for Power BI & Analysis Services.
  • Experience with flat files and databases (Fixed Width, CSV, SQL Server, DB2).
  • Proven BI solutions in complex environments.

Responsibilities

  • Translate business needs into technical designs for BI solutions.
  • Apply rapid prototyping and iterative development to keep pace with business needs.
  • Design and implement new features for ETL routines loading data into the Data Warehouse.
  • Develop and manage BI job scheduling and monitoring.
  • Perform performance tuning on the ETL processes.
  • Participate in capacity planning for BI, short and long term.
  • Develop models, scorecards, and dashboards with drill-down and drill-through.
  • Research and resolve data integrity and performance needs.
  • Communicate clearly, both orally and in writing, with stakeholders.
  • Collaborate with IT delivery teams to meet project goals.

Skills

Data modeling
SQL Server BI
DAX
ETL tuning
Data profiling
BI security
Documentation
Prototyping
Architecture modeling
JD Edwards

Education

Bachelor’s degree in CS/Analytics

Tools

SSIS
SSRS
Power BI Desktop
Power BI Pro
Power BI Report Server
RDMS
DB2
SQL Server

Job description

Standard Motor Products is seeking a Senior BI/ETL Engineer to translate business needs into scalable BI designs, prototype iteratively, and enhance ETL routines into the Data Warehouse. You will build dashboards and scorecards, manage BI jobs, and fine-tune performance across data sources and 200+ million records.

Collaboration with analysts and security teams is essential. You will contribute to capacity planning, model development, and BI architecture documentation, ensuring data integrity

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Developer: Data Modeling & Dashboards
BI Developer: Data Modeling & Dashboards

Standard Motor Products • Lewisville (TX)

On-site
USD 80,000 - 100,000
Business Intelligence Developer
Business Intelligence Developer

Standard Motor Products • Lewisville (TX)

On-site
USD 80,000 - 100,000
Business Intelligence Developer
Business Intelligence Developer

Standard Motor Products, Inc. • Lewisville (TX)

On-site
USD 100,000 - 140,000
Senior BI Engineer: Power BI & Data Pipeline Expert
Senior BI Engineer: Power BI & Data Pipeline Expert

Mathematica, Inc. • Washington

On-site
USD 105,000 - 135,000
Senior BI Engineer — Data Modeling & Dashboards
Senior BI Engineer — Data Modeling & Dashboards

Enterprises • United States

Hybrid
USD 120,000 - 180,000
Medical insurance
Dental insurance
Vision insurance
+2
Senior Power BI Developer & Data Modeler
Senior Power BI Developer & Data Modeler

Pivotal Solutions • Boston (MA)

On-site
USD 90,000 - 130,000
Senior BI Developer: Power BI, SQL & ETL Expert
Senior BI Developer: Power BI, SQL & ETL Expert

Compunnel Inc. • Pennsylvania

On-site
USD 80,000 - 120,000
Senior Business Intelligence Developer – Power BI, Data Modeling & Analytics Architecture 3654429
Senior Business Intelligence Developer – Power BI, Data Modeling & Analytics Architecture 3654429

Axiom Path • Charlotte (NC)

On-site
USD 110,000 - 170,000
Power BI Architect: Enterprise Dashboards & Data Modeling
Power BI Architect: Enterprise Dashboards & Data Modeling

General Dynamics Information Technology, Inc. • Bossier City (LA)

On-site
USD 77,000 - 92,000
Data Modeling BI Engineer
Data Modeling BI Engineer

Request Technology, LLC • Houston (TX)

On-site
USD 120,000 - 150,000
Bonus eligible