Search Our Jobs

IT Business Intelligence Developer in Lewisville at Standard Motor Products

Date Posted: 9/1/2022

Job Snapshot

Job Description

Essential Functions:

  • Work closely with Business Analysts to translate business needs into technical designs for BI solutions. 
  • Develop, maintain, and manage ETL Routines, Job Schedules, Models, KPIs, Paginated Reports, and Dashboards
  • Develop and manage BI job scheduling and monitoring. 
  • Perform performance tuning and data integrity checks on ETL routines, Stored Procedures, Paginated Reports, and Dashboards.
  • Participate in near and long-term capacity planning for BI. 
  • Strong communications skills both oral and written.

Job Requirements

Experience:

  • Minimum 3-4 years of experience in relational Data Modeling.
  • Minimum 3-4 years of experience with the On-Premise Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI).
  • Minimum 3-4 years developing and working with advanced SQL queries.
  • Minimum 1-2 years of experience writing Data Analysis Expressions (DAX) in Power BI.
  • Experience with flat files and other databases (Fixed Width, CSV, SQL Server & DB2).
  • 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 1 billion+ record source data tables.
  • Extensive knowledge of the On-Premise Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI).
  • Experience writing Data Analysis Expressions (DAX) in Power BI.
  • Extensive knowledge developing and working with advanced SQL queries.
  • 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