IT - Senior Business Intell Develop

Lewisville, TX, USA Req #329

Tuesday, November 26, 2024

Established in 1919 and traded on the NYSE, Standard Motor Products, Inc. (SMP) is a leading independent manufacturer and distributor of premium automotive replacement parts utilized in the maintenance, repair, and service of vehicles in the automotive aftermarket. Additionally, SMP provides customized solutions for vehicle control and thermal management products in diversified end markets represented by its Engineered Solutions segment.

Globally, SMP employs over 6,000 employees across nearly 40 manufacturing, distribution, and engineering facilities and offices located in North America, Europe and Asia. SMP sells its products primarily to automotive aftermarket retailers, program distribution groups, warehouse distributors, original equipment manufacturers, and original equipment service part operations in the United States, Canada, Europe, Asia, Mexico, and other Latin American countries.

Essential Functions:

Translate complex 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 sophisticated 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 advanced performance tuning on ETL processes.
Participate in near and long-term capacity planning for BI.
Develop highly advanced 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 5-10 years of experience in relational Data Modeling.
Minimum 5-10 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 5-10 years of experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.
Extensive 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

Extensive 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).
Extensive 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.
Expert knowledge of prototyping & proof of concept mechanisms.
Extensive 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 required, Masters in Computer Science, 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.

Other details

Job Family Information Technology
Pay Type Salary

Apply Now

Lewisville, TX, USA