Senior BI Developer / Data Engineer (SQL Server, SSIS) - Remote (US Contract)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+6 more
Job description
- 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.
Requirements
Do you have experience in Version control?, 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., * 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.
Benefits & conditions
$45 - $60 an hour - Full-time, Contract, * 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.
About the company
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on indeed.comGood distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Data Engineer Salary UK
Highest Paying Tech Companies for Developers
What Are The Top Skills Required For Azure Developers?
Find a Developer Job: 12 Best Job Sites For Developers