9451 SQL BI Developer

Posted 1 week ago

Position Title:          SQL BI Developer
Location:                  Wethersfield, CT
Relocation:              No
Position Type:        W2 contract position (6 – 12 months)
Salary:                       $46 – $50/hour, Depending on Experience
Position Number:   9451


The State of Connecticut has asked Hallmark to find a SQL BI Developer to work with the Judicial Branch on a consulting assignment. This is a consulting role, based in East Hartford, with occasional visits to the CSSD offices in Wethersfield. This assignment is expected to run for at least 6 months, with the possibility of one year.


  • Design, create, and deploy data warehouse and business intelligence solutions
  • Develop data modeling and ETL solutions
  • Develop BI/analytical content using Microsoft SQL Server BI stack (SSRS/SSMS/SSIS/SSAS), Excel, Tableau, or other tools
  • 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


  • 9+ years of experience as a data warehouse developer/database developer
  • Thorough understanding of data warehousing concepts, Star Schema design, and slowly changing dimensions
  • 9+ years of experience with MS SQL Server 2008/2012 including T-SQL/PL-SQL programming and scripting
  • 9+ years of experience building Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft Business Intelligence technology stack (SSRS, SSIS, SSAS)
  • At least 5 years of experience assembling and validating large datasets for research/analysis
  • 5+ years of experience working with data in Excel
  • Strong experience in gathering and analyzing business requirements
  • Must be able to work with staff of varying skill levels, both technical and non-technical
  • Strong communications skills including written, verbal, presentation and interpersonal
  • Proven ability to produce quality work independently, with minimal supervision
  • Proven ability to handle multiple projects simultaneously
  • Experience with Tableau or Microsoft Power BI a plus
  • Experience with spatial analysis tools (ESRI ArcMap, QGIS, etc.) a plus
  • Proven ability to work independently with minimal supervision, as well as on a team



To view other Hallmark jobs, please go to www.HallmarkJobs.com.

Hallmark and our Client are Affirmative Action, Equal Opportunity Employers.  We encourage all qualified people with the current right to work for any employer in the USA to apply.  NOTE: We cannot consider H-1 Visa candidates for this position.  Principals only, please.

Job Features

Job CategoryInformation Technology

Apply Online

A valid email address is required.