Search Our Jobs

Business Intelligence Developer in Lewisville, TX at Standard Motor Products

Date Posted: 9/13/2021

Job Snapshot

Job Description

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.

Job 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. 

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs