Qureos Mentor

Standard Motor Products

GENERAL DESCRIPTION OF RESPONSIBILITIES
 
Essential Functions: 
<ul>
<li>Translate business needs into technical designs for BI solutions.</li>
<li>Apply rapid prototyping and iterative development methodologies as appropriate to ensure solution keeps pace with business needs.</li>
<li>Design and implement new features and enhancements to the existing ETL routines responsible for loading data from the sources systems into the Data Warehouse.</li>
<li>Develop and manage BI job scheduling and monitoring.</li>
<li>Perform performance tuning on the ETL.</li>
<li>Participate in near and long-term capacity planning for BI.</li>
<li>Develop Models, Scorecards, and Dashboards with drill-down and drill-through capabilities.</li>
<li>Research and resolve data integrity and performance needs.</li>
<li>Strong communications skills both oral and written.</li>
<li>Work with other IT delivery teams such as business analyst, security analyst and infrastructure to meet project goals.</li>
</ul>
WORK EXPERIENCE REQUIREMENTS
 
Experience: 
<ul>
<li>Minimum 3-4 years of experience in relational Data Modeling.</li>
<li>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).</li>
<li>Minimum 3-4 years of experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.</li>
<li>Experience with flat files and other databases (Fixed Width, CSV, SQL Server & DB2 preferred).</li>
<li>Demonstrated ability to deliver high impact business intelligence solutions in complex environments.</li>
</ul>
Knowledge, Skills and Abilities
 <ul>
<li>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.</li>
<li>Extensive knowledge of the Microsoft SQL Server BI Stack (SQL Server, RDMS, SSIS, SSRS, Power BI Desktop, Power BI Pro, Power BI Report Server).</li>
<li>Experience writing Data Analysis Expressions (DAX) in Power BI & Analysis Services.</li>
<li>Knowledge of BI security best practices.</li>
<li>Experience creating documentation, and diagrams that communicate the overall architecture of the solution to business, technical audiences, and support teams.</li>
<li>Excellent knowledge of prototyping & proof of concept mechanisms.</li>
<li>Experience with BI Architecture data modeling in SQL Server.</li>
<li>Experience with integrating BI with JD Edwards, and advanced SQL Server database tuning and performance monitoring is a plus.</li>
</ul>
EDUCATION REQUIREMENTS
 <ul>
<li>Bachelor’s degree in Computer Science or Analytics, Operations Research, Mathematics, Statistics or related subject preferred.</li>
<li>Specific work experience considered.</li>
</ul>

Senior Business Intelligence Develop

Join Standard Motor Products and explore 1   exciting career opportunities. They're hiring for various roles with options for remote or on-site work. Apply today and become part of their innovative team.

Standard Motor Products

ABOUT_COMPANY

Senior Business Intelligence Develop