This is a remote position for WI residents.
Team INM is a Denver-based digital agency with an established track record and genuine startup energy. We build sophisticated, compliance-aware software solutions for clients across a wide variety of industries and markets. We value teamwork, accountability, a roll-up-your-sleeves-and-pitch in spirit, and believe in honoring the individual talents and skills of our team members.
Job Overview
We are seeking an experienced Senior .NET Developer with deep Microsoft SQL Server expertise to join our engineering team. You'll serve as a technical anchor for our data layer - designing schemas, tuning queries, and building advanced T-SQL logic that financial-grade solutions demand. But you're more than a database specialist: you'll actively contribute to full-stack .NET development, support team operations, bring AI-driven approaches into your work, and help hold a high bar for the whole team.
Responsibilities
• Architect, develop, and maintain complex MS SQL Server databases - including schemas, stored procedures, functions, triggers, and views.
• Perform advanced SQL performance tuning: query plan analysis, index optimization, statistics management, and blocking/deadlock resolution.
• Write sophisticated T-SQL including window functions, CTEs, dynamic SQL, cursors, and advanced set-based logic.
• Design and optimize ETL processes and data transformation pipelines for client integrations.
• Contribute meaningfully to full-stack .NET development (C#, ASP.NET Core, Web API, Entity Framework) beyond the data layer.
• Implement AI-assisted data techniques: embeddings, vector search, LLM-augmented query and reporting pipelines (Azure OpenAI, SQL integration).
• Ensure all data layer work meets compliance requirements relevant to financial services clients - including data integrity controls, audit logging, and encryption at rest/in transit.
• Apply SecDevOps principles to database development: parameterized queries, least-privilege access, SQL injection mitigation, and vulnerability hygiene.
• Participate in architecture decisions, code reviews, and mentoring of junior developers.
• Provide operational support across development and production environments - including outside your specialty - when the team needs it.
• To understand requirements and deliver value.
Required Qualifications
• 5+ years of professional experience with Microsoft SQL Server (2016 and later).
• Expert-level T-SQL proficiency: complex stored procedures, advanced windowing functions, CTEs, dynamic SQL, performance-critical queries.
• Deep experience with SQL Server performance tuning: execution plans, index strategies, wait statistics, and query store.
• Strong .NET development background (C#, ASP.NET Core, Web API, Entity Framework / EF Core, Unit Tests).
• Solid understanding of database design principles, normalization, and enterprise data modeling.
• Experience with SQL Server HA/DR concepts: Always On, replication, backup/restore strategies.
• Familiarity with SecDevOps and data security principles applied to SQL Server environments.
• Strong communication skills and a genuine willingness to be helpful beyond your primary specialty.
Preferred Skills:
• Experience implementing AI-augmented data solutions: vector databases, embeddings pipelines, LLM integration with structured data.
• Exposure to compliance frameworks relevant to fintech: SOC 2, PCI-DSS data controls, NIST CSF.
• Experience with Azure SQL Database and Azure Synapse Analytics.
• Familiarity with Azure DevOps pipelines for database change management (e.g., Flyway, DbUp, SSDT).
• Experience with SQL Server Integration Services (SSIS) or Azure Data Factory.
• Microsoft SQL Server certification (70-762, DP-300, or equivalent) is a plus.
• Microsoft SQL Server Reporting Services (SSRS) and Power BI is a plus.
• Azure Data Bricks
Compensation:
Compensation varies based on demonstrated experience and specialization depth. Top-of-range compensation is available for candidates with exceptional T-SQL depth, AI integration experience, compliance expertise, and a track record of meaningful .NET contributions beyond the data layer.
Team members are eligible for the listed benefits as well as access to a ski condo in Winter Park.
• *************
If you meet the above qualifications, please submit your resume, and we will be in touch with next steps.
Job Type: Full-time
Pay: $85,000.00 - $125,000.00 per year
Benefits:
• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance
Application Question(s):
• Do you live in Wisconsin?
Work Location: Remote