SQL BI Developer (SSRS/SSAS/SSIS)

Software People Inc.; City of Albany (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

Software People Inc. seeks an experienced professional for a reporting and development role in Albany, NY. The successful candidate will support SQL Server platform solutions, implement report generation, and maintain high-quality data models.

Candidates should have extensive experience with SQL Server, report development, and SSAS. Familiarity with criminal justice data processing and proficiency in advanced SQL are essential for this role.

Qualifications

• 80 months of experience in report development using Microsoft SQL Server.
• 48 months of experience writing complex SQL queries and procedures.
• 12 months of experience with SQL Server Analysis Services (SSAS).
• 36 months of experience with data modeling and database design.
• Experience with statistical reporting related to criminal justice.

Responsibilities

• Maintain business solutions on SQL Server platform using SSRS.
• Research emerging technologies for process improvement.
• Implement data extraction with SQL and relational databases.
• Support production applications and user needs.
• Design and deploy BI solutions (SSIS, SSRS, SSAS).

Skills

Report development using Microsoft SQL Server

Writing complex SQL

Development of analytical cubes using SSAS

Data modeling

SSIS Package configurations

Tools

Microsoft SQL Server Reporting Services

Microsoft Visual Studio

Erwin Data Modeling Tool

Job description

Software People Inc. seeks an experienced professional for a reporting and development role in Albany, NY. The successful candidate will support SQL Server platform solutions, implement report generation, and maintain high-quality data models.

Candidates should have extensive experience with SQL Server, report development, and SSAS. Familiarity with criminal justice data processing and proficiency in advanced SQL are essential for this role.