SQL Database Developer II, Business Intelligence

Role Overview

• Responsible for the development, testing, implementation and support of Microsoft SQL-based relational databases
• Collect and analyze data gathered through the Authority’s custom web applications that are both internal and client-facing
• Develop and support data sets and visualizations utilizing various business intelligence and reporting platforms
• Ensure the database is well maintained, scalable and available to all users
• Administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments
• Participate in the full development life cycle to meet the objectives of the MSBA

Requirements

• Four-year degree in technical discipline and 5+ years of relevant professional experience in SQL database development and BI reporting
• Strong SQL Server 2016(and above) and BI reporting tools such as Tableau and Power BI in a large-scale production environment
• Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Strong knowledge of relational and dimensional data modeling
• Highly experienced in writing and optimizing database scripts, SQL stored procedures, functions and other SQL database objects that assist in the implementation and maintenance of business logic and data flows through MSBA data and application infrastructure.
• Experience analyzing and driving reporting requirements to design and implement complex static and dynamic BI reporting and ad-hoc query reports.
• Experience in code migration, database change management and data management through the various stages of the development lifecycle
• Thorough understanding with hands-on skills of MS SQL Server 2016 (and above) and SSRS Server installation and configurations. Understanding of MS SQL Server 2016 security, performance monitoring and optimization techniques
• Work with our team members and in-house QA to resolve bugs and issues.
• Follow proper application, operations, standards, policies and procedures. Ensure that the integrity and consistency of company databases is maintained
• Experience with versioning control environments including Azure DevOps and/or GIT
• Strong communication skills and the ability to work both independently and as part of a team
• Excellent analytical, technical, problem solving and project management skills with ability to coordinate complex projects with competing priorities and deadlines
• Professional interpersonal style; ability to work and build trust with a diverse range of people
• Ability to work in an Agile environment.
• Ability to work creatively, learn quickly and solve complex problems in high-pressure situations
• Exhibit a professional ‘can-do’ attitude and flexible work style approach
• Ability and willingness to proactively research and/or resolve issues

Tech Stack

• Azure
• MS SQL Server
• SQL
• SSIS
• Tableau