About this role
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