> Markdown version of [/jobs/ext/249613-business-intelligence-developer](https://www.wearedevelopers.com/jobs/ext/249613-business-intelligence-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Developer - **Company:** Standard Motor Products, Inc - **Location:** Lewisville, TX, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Data Analysis, Databases, Data Integrity, Extract Transform Load (ETL), Data Profiling, Data Warehousing, IBM DB2, Relational Databases, Database Servers, Iterative and Incremental Development, JD Edwards EnterpriseOne, Job Scheduling, Microsoft SQL Server, Performance Tuning, Rapid Prototyping Process, Power BI, SQL Server Reporting Services, SQL Server Integration Services, Systems Integration, Information Technology, Performance Monitor, Drilldown - **Published:** May 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=6e9bd3fc6bfd5f3f ## About the Role Do you have experience in Technical solutions implementation?, Do you have a Bachelor's degree?, * 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. ## Description * 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)