Business Intelligence Developer
AIS Healthcare
Summary
AIS Healthcare is seeking a skilled Business Intelligence (BI) Developer to design, build, and maintain data-driven reporting and analytics solutions that support decision-making across the organization. This role will work closely with business users and management across multiple departments to understand reporting needs, translate requirements into technical solutions, and deliver clear, actionable insights through modern BI tools.
Job description
Key Responsibilities
- Design, develop, and optimize complex SQL Server queries, views, and stored procedures to support reporting and analytics
- Analyze business data to identify trends, inconsistencies, and opportunities for improved insight
- Develop and maintain interactive dashboards and reports using Qlik
- Collaborate directly with business users and management to gather, clarify, and refine reporting requirements
- Translate business questions into well-structured data models and visualizations
- Ensure data accuracy, consistency, and performance across BI solutions
- Support ongoing enhancements, troubleshooting, and performance tuning of existing reports and dashboards
- Document data definitions, reporting logic, and BI processes to support long-term maintainability
Required Skills & Qualifications
- Strong experience writing and optimizing SQL / SQL Server queries
- Solid foundation in data modeling and interpreting business data structures
- Hands-on experience with Qlik for data visualization and dashboard development
- Ability to work directly with stakeholders to understand business needs and communicate technical concepts clearly
- Strong problem-solving skills and attention to detail
Preferred / Nice-to-Have Skills
- Experience with Qlik Cloud
- Familiarity with Windows Server environments
- SQL Server administration including optimization and maintenance
- Exposure to or experience consuming RESTful APIs for data integration
- Understanding of Qlik data modeling and ETL concepts & tooling
- Experience using Claude Code / Agentic AI
Ideal Candidate Profile
- Comfortable operating between technical teams and non-technical business users
- Self-directed and capable of managing multiple reporting initiatives
- Interested in building scalable, reliable BI solutions rather than one-off reports
- Strong communicator with a collaborative mindset
Requirements
- Bachelor's of Science in Computer Science or equivalent
- 5+ Years SQL development experience
- Strong experience writing and optimizing SQL / SQL Server queries
- Solid foundation in data modeling and interpreting business data structures
- Hands-on experience with Qlik for data visualization and dashboard development
- Ability to work directly with stakeholders to understand business needs and communicate technical concepts clearly
- Strong problem-solving skills and attention to detail
Benefits
- Health Insurance
- Vision Insurance
- Dental Insurance
- Long Term Disability Insurance
- Life Insurance
- Vacation Package
- 401(k) Matching
- Work From Home
Company overview
AIS Healthcare is a leading provider of targeted drug delivery and infusion care services, founded in 1998 and headquartered in Dallas, Texas. The company operates through two primary divisions: Targeted Drug Delivery (TDD) and Advanced Infusion Care (AIC). The TDD division specializes in high-risk intrathecal compounding, preparing and shipping over 140,000 patient-specific dispenses annually across all 50 states, serving patients with surgically implanted infusion pumps. The AIC division provides comprehensive infusion therapy services, including intravenous and subcutaneous immunoglobulin therapies, delivered either in dedicated infusion centers or patients' homes. AIS Healthcare maintains two state-of-the-art 503A compounding pharmacies that meet or exceed industry standards for medication quality and safety. The company is dually accredited by URAC and the Accreditation Commission for Health Care (ACHC), demonstrating its commitment to quality standards. With a team of over 300 skilled nurses and clinical pharmacists, AIS Healthcare serves more than 1,500 patients nationwide, focusing on complex conditions and rare diseases while prioritizing patient safety and clinical excellence.