Business Intelligence Developer

Business Intelligence Developer Premier Staffing Partners - 3.6 Knoxville, TN Job Details Full-time $90,000 - $110,000 a year 2 days ago Benefits Health insurance Dental insurance 401(k) Paid time off Vision insurance 401(k) matching Life insurance Qualifications Performance dashboard reports Data model design Dashboard development Performance tuning Power BI Data visualization software proficiency Data Integration (Data management) Requirements design Data retrieval time improvement Business intelligence report generation Business analysis Dashboard creation support Microsoft SQL Server Schema design Stored procedures Technical solutions implementation Data Architecture Design (Architecture design skills) Business intelligence tools Math Attention to detail Organizational skills Business requirements Data analytics tools System tuning Associate's degree Design (software development lifecycle) Dimensional modeling T-SQL Analytics Full Job Description Business Intelligence (BI)

Developer Location:

Remote- Candidates must reside within a 1-hour radius of

Knoxville, TN Type:

Direct Hire with full company benefits package Position Summary We are seeking a Business Intelligence (BI) Developer to design, develop, and support enterprise reporting and data solutions. This role is responsible for building ETL processes, enhancing data marts, and delivering high-quality reports and dashboards that support strategic decision-making. The ideal candidate brings strong SQL expertise, a passion for data accuracy, and the ability to translate business requirements into scalable BI solutions. Key Required Skills Strong proficiency in SQL Server and T-SQL development Experience with database schema design Hands-on experience with Microsoft SSIS or other ETL tools Experience developing reports in Microsoft SQL Server Reporting Services (SSRS) Working knowledge of Power BI or other dashboarding platforms Advanced Excel skills Query optimization and performance tuning experience Foundational knowledge of dimensional modeling and star schema design Ability to translate business reporting requirements into technical solutions Strong analytical, logical, and mathematical problem-solving skills Effective communication and organizational skills Preferred Qualifications Experience with Azure SQL Database or Azure SQL Managed Instance Familiarity with Microsoft Azure cloud environments Experience in financial services or regulated environments Exposure to Agile development methodologies Key Responsibilities Design, develop, and maintain ETL processes to support reporting and analytics needs Create and enhance data marts to support evolving business metrics Develop and maintain reports using SSRS and dashboards in Power BI Write optimized stored procedures and queries using T-SQL Translate business requirements into technical tasks and provide effort estimates Perform testing and validation to ensure data accuracy and report integrity Analyze and optimize report and query performance Collaborate with software developers on system design and BI-related architecture Support internal and external reporting needs, including audit and compliance reporting Provide ongoing maintenance and enhancements to existing BI artifacts Contribute to Agile development processes and communicate project progress effectively Support team knowledge sharing and continuous process improvement • This role offers the opportunity to work on impactful data initiatives while partnering closely with development leadership and business stakeholders. Ideal candidates are detail-oriented, technically strong, and motivated to build scalable BI solutions that drive measurable business value.

Pay:

$90,000.00 - $110,000.00 per year

Benefits:

401(k) 401(k) matching Dental insurance Health insurance Life insurance Paid time off Vision insurance Application Question(s): Do you reside within a 1-2 hour driving distance of Knoxville TN? Are you able to pass a background and credit check?

Education:

Associate (Required)

Experience:

Microsoft SQL Server:

4 years (Required)

Power BI:

3 years (Required)

ETL:

3 years (Required)

SSIS:

2 years (Required)

Azure SQL Database/Managed Instance:

1 year (Preferred)

Advanced Excel:

4 years (Required)

Work Location:

Hybrid remote in Knoxville, TN 37923