IT BI Developer

Proficient in Microsoft SQL Server as well as reading and writing complex SQL

• Conduct unit testing and troubleshooting, ensuring data and calculations are accurate.


• Create queries and reports for AdHoc requests from the Operations Management and Enterprise Services teams.


• Work within an Agile team and coordinate priorities with the Scrum Master and stake holders.


• Work with data and application development team to modify existing reports for any changes in internal system database schemas.


• Learn data and business processes and utilize this knowledge to verify data, query and report output.


• Background in data warehouse design (e.g. dimensional modeling)


• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework


• Familiarity with some BI technologies such as Tableau, Microsoft Power BI, Qlik, EPIC BI


• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)


• Ability to take initiative and innovate


• Analytical mind with a problem-solving aptitude


• Utilizes discretion and good judgement while working with confidential data


• Collaborate within and across teams to deliver a high-quality user experience


• Translate business needs into technical specifications


• Develop and update technical documentation


• Support existing BI systems and participate in rotating on call


• Optimize and tune solutions


• Create visualizations, reports, and data models


• Experience with Azure is a plus