Standard Motor Products · 1 month ago
Senior Business Intelligence Develop
Lewisville, TX, USA
Full-time
Onsite
Mid, Senior Level
3+ years expStandard Motor Products is seeking a Senior Business Intelligence Developer. The role involves translating business needs into technical designs for BI solutions and implementing enhancements to ETL routines while ensuring data integrity and performance.
AutomotiveManufacturingWholesale
Responsibilities
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
Qualification
Required
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
Demonstrated ability to deliver high impact business intelligence solutions in complex environments
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
Preferred
Experience with flat files and other databases (Fixed Width, CSV, SQL Server & DB2 preferred)
Experience with integrating BI with JD Edwards
Advanced SQL Server database tuning and performance monitoring is a plus
Bachelor's degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred
Company
Standard Motor Products
Standard Motor Products is an independent manufacturer and distributor of replacement parts for motor vehicles.
5001-10000 employees
H1B Sponsorship
Standard Motor Products has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (2)
2023 (1)
2022 (3)
2021 (1)
2020 (3)
Funding
Current Stage
Public CompanyTotal Funding
$1.25BKey Investors
JP Morgan Chase
2024-09-17Post Ipo Debt· $750M
2022-06-02Post Ipo Debt· $500M
1978-01-13IPO
Leadership Team
Eric Sills
CEO
Dale Burks
Executive Vice President & Chief Commercial Officer
Recent News
2026-01-15
2025-11-01
Company data provided by crunchbase