Senior Software Engineer

MediSolution; Scottsdale (AZ); Hybrid; USD 125,000 - 150,000; Full time

Benefits offered by this job

Health benefits

RRSP matching

Stock options

Career development opportunities

Job summary

MediSolution seeks a Senior Software Engineer in Scottsdale, AZ to tackle complex data challenges in Gridline’s SQL Server-based warehouse. You will own stored procedures, optimize performance, and occasionally touch C#/.NET and React applications consuming data.

We value independent problem solving, ownership, and collaboration in Agile sprints. Expect to work with Azure DevOps, Git, and AI-assisted tooling to deliver robust data solutions.

Qualifications

• 7+ years of primarily T-SQL focused experience in production SQL Server environments.
• 3+ years of C# experience with ability to make targeted changes in applications/services/APIs.
• 1+ years .NET 6+ or later.
• 1+ years in an Agile environment.
• 1+ years Azure DevOps using Git.
• Experience with AI-assisted development tools (Cursor/Claude) preferred.
• SQL Server administration including roles, users, schema management, backups, recovery.
• Experience with telematics/CAN or other complex data is a plus.

Responsibilities

• Maintain and optimize complex stored procedures for warehouse tables.
• Improve database performance on large datasets (>300 million rows) via indexing, tuning, partitioning.
• Maintain SQL Server Agent jobs, schedules, failure analysis, and performance impact.
• Understand data usage across Gridline products and identify upstream impacts.
• Analyze telematics data to provide actionable insights.
• Maintain and improve web, console, and API data access layers with robust coding standards.

Skills

T-SQL

SQL Server

C#

ASP.NET

Azure DevOps

Git

DACPACs

Cursor

Claude

React

Education

Bachelor’s degree in CS, MIS or CIS or related field

Tools

Git

Azure DevOps

DACPACs

Job description

## Senior Software EngineerApply: Arizona, United States: Full time: Posted Today: R0046708The Senior Software Engineer will solve complex data and performance challenges in Gridline’s SQL Server environment. This role is primarily focused on SQL Server, data warehousing, stored procedures, database performance, SQL jobs, and the data access layer. The successful candidate will also be able to follow data up the stack and occasionally make targeted changes in the C#/.NET and React applications that consume that data. This role requires someone who can take ownership of ambiguous data problems, investigate independently, ask focused questions when blocked, and drive work to completion without heavy day-to-day direction. **What you will do** * Maintain and improve the complex stored procedures that build the warehouse tables.* Optimize database performance for large datasets exceeding 300 million rows using indexing, query tuning, execution plan analysis, partitioning strategies, and other SQL Server performance techniques.* Maintain, troubleshoot, and optimize SQL Server Agent jobs, including job scheduling, failure analysis, retry behavior, dependency review, and performance impact.* Understand how the data is used throughout Gridline products and be able to identify upstream impacts.* Ability to understand, analyze, and summarize complex telematics data using SQL.* Maintain source control of SQL code using Git.* Participate in Agile ceremonies in 2 week sprints.* Use Azure Dev Ops for workflow.* User Claude or Cursor to assist in writing code, solving problems, and reviewing work.* SQL Server administration – roles, users, schema management, backups, recovery.* Minimal SSIS/SSRS work.* Analyze telematics and safety data to provide actionable insights to customers.* Maintain and help improve web, console, and API based solutions using appropriate languages while helping to drive the improvement of internal coding standards and best practices.* Write software to integrate complex data from external APIs/sources.* Ensure the robustness, performance, and failure characteristics of the system. **Knowledge, Skills and Abilities:** * Exceptional Microsoft SQL Server skills, including table design, advanced stored procedure development, data warehousing, SQL Server Agent jobs, database tuning, and performance management for large datasets exceeding 300 million rows across multiple database servers and databases.* Must be able to solve complex SQL and data analysis problems by working from raw data to identify meaning, patterns, metrics, summary information, and data-quality issues, while also being able to debug stored procedures, analyze execution plans, and communicate findings clearly.* Must be knowledgeable about Database Projects and Data-tier Application Packages (DACPACs) for SQL source control and deployment.* Must be a self-starter who can independently investigate unfamiliar systems, prioritize the next useful step, document findings, and communicate blockers clearly without requiring step-by-step direction.* Exceptional problem solving & debugging skills.* Good object-oriented programming skills* Familiarity with the consumption and presentation of API data* Strong analytical and documentation skills* N-tier design and programming* Exposure to big data/large language models a plus* React experience a plus **What are we looking for** * Bachelor’s degree in CS, MIS or CIS or related field or equivalent job-related experience.* 7+ years of primarily T-SQL focused experience in production SQL Server environments.* 3+ years of C# experience, with the ability to make targeted changes in applications, services, APIs, or console processes that interact with SQL Server data.* 1+ years .NET 6+ or later.* 1+ years in an Agile environment* 1+ years Azure Dev Ops using Git.* Experience using AI-assisted development tools such as Cursor, Claude, GitHub Copilot, or similar tools to assist with coding, troubleshooting, documentation, or code review is preferred.* SQL Server administration experience, including roles, users, schema management, backups, and recovery.* Experience working with telematics, CAN bus, or other complex data* Experience supporting SQL Server production environments with large datasets exceeding 300 million rows, multiple database servers/databases, and SQL Server Agent jobs.* Experience designing, maintaining, debugging, analyzing, and improving complex SQL and data solutions for production systems.* Experience with Database Projects and Data-tier Application Packages (DACPACs) for SQL source control and deployment.* Experience building or supporting data integration applications that move, transform, or reconcile data from external APIs or source systems.* Limited SSRS and SSIS experience preferred. **Reasonable Accommodation** Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. **Supervisory Responsibility** None **Work Environment** This job operates in a clerical, office setting. Noise level is typically moderate. This role routinely uses standard office equipment such as computers, phones, filing cabinets, copiers, scanners and fax machines. **Physical Demands** The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. The employee is occasionally required to sit; climb or balance; and stoop, kneel, crouch or crawl. The employee must frequently lift and move up to 10 pounds and occasionally lift and move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus. **Position Type/Expected Hours of Work** This is a full-time position which will typically involve 40 hours a week Monday through Friday but are subject to change at the company’s discretion. **Travel** Two trips annually to the corporate office in Scottsdale, AZ of approximately 5 days each may be required along with quarterly 1-day events. Otherwise, little to no travel is expected for this position. **Other Duties** Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. **Compensation details** The potential salary range for this role is $125,000 to $150,000 per year, with eligibility for bonus or merit program. Final compensation will be based on experience, skills, market conditions, and internal equity. We offer a competitive Total Rewards program including health benefits, RRSP matching, stock option, and career development opportunities.