Big challenges need bold thinkers.
If you’re someone who sees problems as opportunities, you’ll thrive here. RESPEC is 100% employee-owned, which means we take ownership of every challenge. Here, your ideas drive real solutions. Since 1969, we’ve tackled complex challenges in energy transition, infrastructure resilience, digital transformation, and sustainability.
At RESPEC, you’ll work alongside clients to take on critical problems. Depending on your expertise, you might design infrastructure in remote locations, develop renewable energy solutions for global projects, or apply data-driven technology to improve mining and water systems.
We bring deep technical knowledge, real-world experience, and a commitment to work that matters. If you're looking for a place where your contributions have real impact, you’ll fit right in.
We do not accept unsolicited resumes from third-party recruiters.
Job DescriptionRESPEC is seeking an experienced Database Developer to support a public-sector technology initiative for the Minnesota Department of Information Technology Services (MNIT) in partnership with the Minnesota Department of Corrections. This is a full-time contract consulting opportunity supporting a mission-critical enterprise data environment.
In this role, you will help modernize, maintain, and optimize enterprise database solutions that support transactional applications, reporting platforms, data conversion, and operational decision-making. You will work across the data lifecycle—from ingestion and transformation through migration, validation, reporting, and production support—to ensure that enterprise data is accurate, reliable, secure, and performant.
This is an opportunity for a hands-on database professional who enjoys solving complex data challenges, improving performance at scale, and collaborating with cross-functional Agile teams in a high-impact government environment.
Core Responsibilities:
- Design, develop, and maintain SQL Server databases, including stored procedures, views, indexes, SQL scripts, and supporting database components.
- Build and optimize ETL pipelines and data workflows using SSIS, SQL Server, Python, and/or PySpark.
- Lead or support large-scale data conversion and migration efforts, including data cleansing, transformation, validation, reconciliation, and quality assurance.
- Develop data ingestion and transformation processes across raw, staging, curated, and analytics data layers.
- Create and maintain logical and physical data models, including entity relationship diagrams (ERDs), for application and reporting needs.
- Build and support reporting solutions using SSRS and Power BI.
- Diagnose and resolve database performance issues; tune SQL queries, stored procedures, indexing strategies, and database workloads.
- Provide production support, including participation in on-call support as business needs require.
- Partner with technical and business stakeholders through Agile ceremonies, code reviews, development activities, releases, and knowledge-transfer activities.
Required Technical Experience
10+ Years of Experience
Candidates should bring 10 or more years of experience in database development, data engineering, or a closely related technical discipline.
Technical Background:
Candidates should have demonstrated experience with:
- Microsoft SQL Server, T-SQL development, and database performance tuning.
- Designing, developing, and maintaining stored procedures, SQL scripts, views, indexes, and database components.
- ETL development using SSIS, Python, PySpark, or a combination of these technologies.
- Enterprise data migration, conversion, cleansing, transformation, and validation.
- Data modeling, database design, and data integration practices.
- ·upporting production applications and resolving database performance or operational issues.
- SSRS and Power BI reporting solutions.
Preferred Qualifications:
Experience supporting high-availability or business-critical applications in a government, financial, or legal environment is strongly preferred.
Working knowledge of DevOps and source-control tools—such as Azure DevOps, GitHub, or Jenkins—is also preferred. Candidates who have worked successfully in Agile delivery environments and can communicate effectively across technical and business teams will be especially well suited for this role.
Additional InformationWork Model
Remote: This position is expected to be performed remotely.
Interview Format: Virtual interview via Microsoft Teams.
All your information will be kept confidential according to EEO guidelines.
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 10+ years of experience in database development or data engineering
- Microsoft SQL Server and T-SQL development
- Designing and maintaining stored procedures, views, indexes, and SQL scripts
- ETL development using SSIS, Python, or PySpark
- Enterprise data migration, conversion, cleansing, transformation, and validation
- Data modeling and creation of logical/physical data models and ERDs
- Building and supporting reporting solutions using SSRS and Power BI
- Diagnose and resolve database performance issues and tuning
- Provide production support and participate in on-call rotations
- Experience supporting high-availability or business-critical applications in government, financial, or legal environments
- Working knowledge of DevOps and source-control tools such as Azure DevOps, GitHub, or Jenkins
- Experience working in Agile delivery environments and effective technical/business communication
RESPEC Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about RESPEC and has not been reviewed or approved by RESPEC.
-
Retirement Support — - Retirement Support: Retirement benefits are positioned as a meaningful part of total rewards through the combination of an ESOP and a 401(k). Long-term wealth-building potential is emphasized as a differentiator versus base-salary-only comparisons.
-
Healthcare Strength — - Healthcare Strength: Core medical, dental, and vision coverage is presented as a standard, comprehensive foundation. Additional protection coverage (life and disability) is also included, strengthening the overall benefits stack.
-
Fair & Transparent Compensation — - Fair & Transparent Compensation: Pay is characterized as generally fair-to-good when viewed across roles and in combination with total rewards. Clear salary ranges appearing in some job postings further support expectations-setting for certain positions.
RESPEC Insights
What We Do
In a world where one superhero can handle almost any problem, our entire team of award-winning technology experts is on a mission to make your business better. With extra vision to see solutions that others can’t and vast knowledge to bridge the gaps that others don’t, we’re transformers with the know-how to solve the world’s hardest problems. At RESPEC, we thrive on technology and making our clients successful. This is why we do what we do. From the depths of a cavern to the heights of a volcano, from an antiquated computer system to a business in dire need of re-engineering, our technical and business experts find solutions for extreme situations... like the time we cleansed and migrated 100 million rows of legacy data or the time we protected Mt. Rushmore. Know-How is Everything. We use our resourcefulness and vast experience to solve problems. It’s called know-how. And when you have it, problems aren’t problems at all. Know-how defines the core of who we are. It is how our clients see us. Know-how speaks to ingenuity, aptitude, and skill—it is not merely knowledge; it is knowledge on how to get things done. Imagine having access to a think tank with hundreds of diversely talented engineers, scientists, programmers, and developers under one roof—that’s RESPEC. Each team member is highly trained and skilled in understanding and applying the laws of a specific universe to solve any kind of problem. That’s why we have to talk about our team in terms of superheroes.
