Overview:Our client is looking for a BI Developer to become an expert at understanding their data to ensure the data aligns with the business goals. They will be responsible for identifying and communicating data trends to business stakeholders. The goal is to aid business stakeholders in drawing insights from data by interpreting and translating business needs into data storage, analysis, and visualization solutions. Need to understand how to develop star-schema datamarts, optimize data retrieval, and how to develop dashboards, reports and other visualizations for stakeholders.
This position requires strong technical skills (such as data development, creation of dashboard/reports) and soft skills (such as communication and business knowledge). Our client utilizes the Microsoft BI stack and Tableau as the primary platforms and systems.
Responsibilities:- Design, create, deploy, and maintain data warehouse and business intelligence solutions
- Develop data modeling, ETL solutions, and BI/analytical content using Microsoft SQL Server BI stack (SSRS/SSMS/SSIS), Excel, Tableau.
- Respond to ad-hoc data requests for information by writing complex T-SQL
- Collaborate with technical and non-technical stakeholders to solve complex business problems, by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements
Minimum Qualifications:- Minimum of 5 years' experience in gathering and analyzing business requirements.
- Thorough understanding of data warehousing concepts, Star Schema design, and slowly changing dimensions.
- Minimum of 5 years' experience assembling and validating large datasets for research/analysis.
- Minimum of 9 years' experience with MS SQL Server, including SQL programming and scripting.
- Minimum of 5 years' experience working with data in Excel.
- Minimum of 9 years' experience as a database developer.
- Minimum of 9 years' experience designing, troubleshooting and maintaining SSIS packages and Agent jobs.
- Minimum of 9 years' experience designing, troubleshooting and maintaining SSRS reports and dashboards.
- Minimum of 2 years' hands-on experience working in Tableau or equivalent (Tableau certification preferred).
Additional Information:- Candidates are required to attend their first two days in person in Glastonbury, CT. Then can work either a hybrid or remote schedule.
Skills:Microsoft SQL Server,T-SQL,SSIS,SSRS,Data Warehousing,Tableau,Business Intelligence,Star Schema
