Developer/Business Intelligence Analyst

Job Title :                             Developer/Business Intelligence Analyst

FLSA Status:                       Exempt (Salary)

Pay Range:                          $60,000 - $67,000

Department:                      IT

Reports To:                         Director of IT

Essential Functions: 

• Design, develop, and optimize SQL queries, stored procedures, views, and functions.
• Build and maintain SSRS (SQL Server Reporting Services) reports and dashboards for internal stakeholders.
• Build and maintain data interface solutions using SSIS (SQL Server Integration Services).
• Develop dynamic and visually appealing Power BI dashboards and data models.
• Maintain, enhance, and develop code for the ERP system.
• Translate business requirements into technical specifications and deliver actionable insights.
• Collaborate with cross-functional teams to streamline data flows and improve reporting processes.
• Ensure data integrity and security in all solutions.
• Troubleshoot data issues, analyze root causes, and implement long-term solutions.         

Qualifications:                 

• A minimum of 3 years of experience with SQL Server and strong proficiency in writing complex SQL queries and stored procedures.
• Hands-on experience creating and managing SSRS reports in a production environment.
• Proficiency in Power BI for creating dashboards, DAX calculations, and data modeling.
• Experience in designing, coding, and testing business programs without impacting day-to-day operations.
• Exposure to version control systems.
• Experience with Unix is advantageous.
• Strong analytical skills and attention to detail.
• Experience with ETL processes and data integration.
• Excellent communication and documentation skills.

Benefits:

• 401k with 6% match
• Health insurance
• Dental insurance
• Vision insurance
• Short and Long term disability
• Life insurance
• Paid time off
• Employee discount
• Employee assistance program