Bastian Solutions · 7 hours ago
BI/SQL Developer
Louisville, KY
Full-time
Onsite
Mid Level
$70K/yr - $100K/yr
4+ years expBastian Solutions is an independent material handling and robotics system integrator providing automated solutions for distribution, manufacturing, and order fulfillment centers. They are seeking a BI/SQL Reports Developer I/II to design, develop, document, and maintain database and Business Intelligence reporting environments while assisting in troubleshooting and resolving issues.
Information TechnologyLogisticsManufacturingRoboticsWarehouse Automation
No H1B
Hiring Manager
Olivia McLaughlin
Responsibilities
Develops reports across various reporting platforms: SSRS, Logi Analytics, PowerBI, etc
Develop database schema objects including views, store procedures, functions and indexes for reports and data management
Analyzes and profiles data for creation of operational and analytical tabular reports and visualizations/dashboards
Evaluates BI reports for reuse and integration into standard offering
Review query performance and work with developers to create optimized queries
Assist Project Managers and Quality Assurance in development and testing efforts
Work with project management and support team on ensuring maximum performance and uptime of all customer systems including troubleshooting of complex problems
Work with internal IT teams to ensure performance optimization of internal database environments
Assists more-senior team members with the support and implementation of releases, performance improvements, and other troubleshooting tasks
Create and manage table indexes to improve database performance
Troubleshoot and resolve bugs, logic issues, and performance issues (system, data, report or DB code)
Completes tasks with minimal direction and oversight
Be responsible for and/or be a contributor to documentation artifacts including functional requirements documents, design documents, and data management plans
Define and push forward new database functionality and improvements that can benefit our team and customers
Create standards for our databases and decide whether developer database requests comply with our standards
24/7 internal and external support for critical issues via an on-call rotation
Qualification
Required
Bachelors degree in IT or related field
4+ years experience in a developer role
4+ years experience in report developer role on any relational database platform
Experience with the design and building of data models
Experience with relational database design and tuning
Experience with Visual Studio, TFS, Azure DevOps, and GIT, including schema comparisons and source control
Experience with database tuning and troubleshooting including reading and analyzing execution plans
Ability to design, develop and create database objects on Microsoft SQL Server platform. i.e. Tables, Indexes, Keys, Stored Procedures, Views, Functions, Triggers, etc
Strong troubleshooting skills
Must be eligible to work in the USA long term without sponsorship
Benefits
Health, Dental, and Vision Insurance
401(k) Retirement Plan with a company match
Vacation/Holiday Pay
Tuition Reimbursement
Volunteer Work
Professional Associations, Conferences and Subscriptions
Company Meetings & Events
Company
Bastian Solutions
Improve your warehouse design and operations with our innovative material handling solutions.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Aaron Jones
President and CEO
Eric Cameron
VP of Software
Recent News
2025-08-15
2025-08-13
2025-08-05
Company data provided by crunchbase