Senior BI Developer / Data Engineer (SQL Server, SSIS) — Remote (US Contract)

Paramint is hiring a Senior BI Developer / Data Engineer with deep Microsoft BI stack experience to support a New York City government agency. This is a hands-on contract role focused on maintaining and extending an established SQL Server data warehouse and SSIS ETL platform in a production environment.

We are looking for someone who is comfortable stepping into a mature codebase, understanding existing architecture quickly, and making reliable improvements within a structured SDLC and change-control process.

Job Details

• Job Type: Contract (W-2)
• Duration: 1 month, with potential extension
• Pay: $45.00–$60.00 per hour
• Location: Remote within the United States
• Schedule: Full-time, Eastern Time business hours
• Client: NYC government agency (disclosed after initial screening)

About Paramint

Paramint is an NYC-based software and AI firm delivering data, analytics, and AI systems for government and regulated enterprise organizations. We place experienced engineers on high-trust engagements where reliability, documentation, and production quality matter.

Responsibilities

• Maintain and enhance an existing SSIS-based ETL framework in SQL Server.
• Support a parent-child SSIS package architecture handling staging, ODS, and dimensional warehouse loads.
• Develop and optimize T-SQL stored procedures, queries, and warehouse processes.
• Work with dimensional models including fact tables, dimension tables, and Slowly Changing Dimensions (SCD Type 1 and Type 2).
• Integrate and reconcile data from enterprise source systems including Dynamics 365 CRM and case-management platforms.
• Support and maintain SSAS Tabular models and downstream Power BI reporting.
• Use Azure DevOps and follow established SDLC and change-management processes.
• Produce clear technical documentation and maintain audit-ready standards.

Required Qualifications

• 5+ years of experience with Microsoft BI and data engineering technologies.
• Strong hands-on experience with: SQL Server / SSIS (SQL Server Integration Services) / T-SQL / Data warehousing and dimensional modeling
• Experience maintaining and extending existing ETL systems and production data warehouses.
• Experience with SSAS Tabular models and Power BI.
• Understanding of star schema design and SCD Type 1 / Type 2 implementations.
• Experience integrating CRM or other enterprise operational systems.

Preferred Qualifications

• Experience with Power BI Report Server (on-premises).
• Dynamics 365 CRM integration experience.
• Azure DevOps with TFVC source control.
• Government, public sector, or regulated-industry experience.
• Experience with SSIS Task Factory or similar SSIS enhancement tools.

Why This Role

This is a strong fit for engineers who enjoy working inside stable, well-structured enterprise systems rather than building greenfield pipelines from scratch. The environment values reliability, maintainability, documentation, and careful production changes.

Your work will directly support operational and reporting systems used by a major public-sector organization.

How to Apply

Apply through Indeed with your resume.

Please make sure your experience with:

• SSIS
• SQL Server
• T-SQL
• Data warehousing
• Dimensional modeling

Qualified candidates will complete a brief technical screening prior to client introduction.

Pay: $45.00 - $60.00 per hour

Application Question(s):

• Are you willing to work on a full-time W-2 contract? This is NOT available for C2C, C2H or 1099, and no sponsorship.

Work Location: Remote