SQL Server Data Engineer

Company Description

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 Description

We are seeking a technically skilled and business-savvy SQL Server Data Engineer to support our data infrastructure, reporting needs, and budgeting processes. The ideal candidate will have strong experience with SQL Server and SSRS, excellent communication skills, familiarity with budgeting systems, and a consulting mindset to work effectively across teams.

Key Responsibilities:

• Develop, maintain, and optimize SQL Server databases and queries.
• Design, develop, and deploy reports using SQL Server Reporting Services (SSRS).
• Collaborate with finance and operations teams to support budgeting and forecasting processes.
• Act as a consultant to internal stakeholders, translating business needs into technical solutions.
• Communicate effectively with both technical and non-technical audiences.
• Ensure data accuracy, integrity, and security across systems.
• Troubleshoot and resolve data/reporting issues in a timely manner.
• Document processes and provide user support for reporting tools.

Qualifications

• Proven experience with SQL Server (T-SQL, stored procedures, performance tuning).
• Strong knowledge of SSRS report development and deployment.
• Experience working with budgeting or financial systems.
• Familiarity with large and complex databases, including performance optimization and data modeling.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently and collaboratively in a consulting capacity.

Preferred Skills:

• Experience with OLAP cubes or multidimensional data models.
• Experience with ETL tools or data integration platforms.
• Experience with fund-based accounting.
• Familiarity with Excel-based reporting and pivot-tables.
• Understanding of financial concepts and budgeting workflows.

Additional Information

Work Schedule:

• Hybrid schedule: 3 days/week in office; 2 days remote

Compensation: Salary depends on experience and expertise. Compensation includes a comprehensive fringe-benefits package. RESPEC is a 100% employee-owned company and employees are eligible for participation in the Employee Stock Ownership Plan (ESOP) after a qualifying period.

Featured benefits include:

· Flexible Work Schedules

· Paid Parental Leave

· 401(k) & ESOP (with company match up to 4%)

· Professional Development and Training

· Tuition Reimbursement

· Employee Assistance Program

· Medical/Dental/Vision Insurance Plans

All your information will be kept confidential according to EEO guidelines.