Vanasse Hangen Brustlin Watertown , MA 02472
VHB is searching for a full-time developer to be part of our growing team focusing on modernizing our corporate reporting and data analytics tools. The successful candidate will have the skills to participate in all aspects of a data analytics development lifecycle using Microsoft Business Intelligence (BI) technologies to empower our employees with real time access to the information they need. The SQL Server BI Developer will be responsible for designing and developing using the Microsoft SQL Server platform and tool stack. This will include ETL processes, warehouse design, reporting development.
The SQL Server BI Developer Responsibilities are:
Working with the IT and Finance Teams to build interactive dashboards to communicate business critical information to the business.
Creating/modifying tabular models in SSAS 2016 and reports/data visualizations utilizing MS Power BI
Researching data discrepancies between data warehouse and legacy reports/data.
Designing and optimizing ETL processes for best performance.
Maintain and troubleshoot existing BI solutions including ETL, cube / model processing and reporting errors
Design, deploy and maintain enterprise level data warehouses and data marts including various data modeling techniques and tabular model architectures
Review and implement changes to existing T-SQL code and stored procedures for performance improvements
Technical skills and experience:
Microsoft SQL Server 2008R2, 2012, 2014 and SQL 2016
Experience with designing, developing, and supporting database environments
Strong SQL Server skills is a must along with SQL queries and stored procedures
Data warehouse experience utilizing the star schema
Write complex T-SQL code and stored procedures to be utilized by applications, ETL and reports
Experience with SSIS, SSRS, SSAS Tabular Model, Visual Studio, PowerShell, and GIT source control
Experience with Power BI and DAX query development
Experience working in an Agile environment
Good working knowledge of data warehouse and database design
Candidates should have excellent oral and written communication skills.
Excellent organizational and time management skills
Degree in Computer Science, Information Technology or a related field
3-5 years of software development experience using Microsoft technologies
Experience developing using MS SQL
Experience with presenting complex financial data and metrics a plus
Working Knowledge of MS Power BI or similar analytics platform