BI Developer

Broad Description of Duties:

Design, develop and maintain strategic business information systems, including system requirement assessment along with the full development life cycle. Primary focus is on business intelligence development, information delivery mechanisms, data analysis and data integrity.

This position reports to the Director of BI Analytics

Essential Functions/Job Duties:

• Perform full development life cycle tasks including requirements gathering, detail design, development, testing and documentation for business intelligence systems and solutions.
• Ensure a high level of support for all business intelligence systems, responding to issues and participating in an on-call after hours rotation.
• Provide a continuous focus on improving processes, data flow and the integrity of data.
• Provide detail analysis of data issues and participate in the design and development of automated processes that enhance data quality.
• Function as a problem-solving expert and escalation point for the business in regards to business intelligence solutions.
• Create and execute queries upon request for data following support standards.
• Collaborate with application teams in the integration of data into an efficient data warehouse.
• Perform data validation on new business intelligence solutions or enhancements.
• Work within the guidelines of the approved budget and timelines for specific projects.
• Prepare and present project status reports as requested by project leads and management.
• Prioritize Theatre support issues in relation to other assigned projects to make the best use of the workday.
• Demonstrate verbal and interpersonal skills and be an effective communicator and company representative.
• Remain abreast of current information system trends and technologies and recommend technology to the business that will meet and leverage the needs of the business.
• Adhere to all of the personnel and application development policies and procedures of the division as well as the parent company.

Education Required:

• BA/BS degree in Computer Science/Information Technology or equivalent experience.

Experience Required:

• Requires 3-5 years of data warehouse design and business intelligence development experience
• Requires in depth knowledge of database management systems, preferably SQL Server
• Requires in depth knowledge of Microsoft's BI toolset;
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • SQL Server Analysis Services (SSAS)
  • Visual Studio development suite
• Experience with business intelligence data visualization tools (Power BI, Tableau, Business Objects) is preferred
• 3+ years of prior experience using business system analyst skills
• Strong analytical, trouble shooting and organization skills
• Requires excellent communication and team building skills