Pay
$95K–$145K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,327 postings in the last year. Stated ranges, not salaries paid.
Lewisville, TX, USA
Open 5 months, first seen by us 178 days agoDesign and implement ETL routines that load source data into the Data Warehouse
Develop models, scorecards and dashboards with drill-down and drill-through
Tune ETL performance and manage BI job scheduling and monitoring
Translate business needs into technical BI designs using rapid prototyping
Research and resolve data integrity and performance problems
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 Models, Scorecards, and Dashboards with drill-down and drill-through capabilities.
Perform performance tuning on the ETL.
Translate business needs into technical designs for BI solutions.
Research and resolve data integrity and performance needs.
Open 5 monthsWe first saw this posting 178 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
$95K–$145K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,327 postings in the last year. Stated ranges, not salaries paid.
Day 178
Up longer than most. Similar jobs usually come down between day 5 and day 43.
From 16,009 similar postings that came down. Coming down is not always a hire.
1 open job
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
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. WORK EXPERIENCE 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. Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Complete your application on jobs.dayforcehcm.com. The employer’s form will show what is required.
Already applied? Track this application
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Lewisville, TX, USA
Standard Motor Products is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. #LI-ER1 #LI-HYBRID
No clear work-authorization passage found. Eligibility is unconfirmed.