Role overview

Qualifications

Proficient in SQL Server, including query performance, indexing, and data modeling.
Experience handling JSON in SQL Server and managing hybrid data models.
Experience with PowerShell or similar scripting languages for automation purposes.
Ability to work across multiple systems, including databases, APIs, and services.

Responsibilities

Design, build, and optimize complex SQL Server solutions, emphasizing performance tuning, indexing, and data modeling.
Manage relational and semi-structured data, including JSON stored in SQL Server and multi-dimensional datasets.
Explore and implement LLM-driven workflows, including prompting and structured outputs.
Continuously enhance efficiency by replacing manual processes with automation.

Key facts

Remote from: Anywhere
Full time
Senior (5-10 years)
Data Engineer
English

Hard skills

Database Tuning Windows PowerShell Data Modeling Semi-Structured Data Systems Integration Multidimensional Database Application Programming Interface (API) Business Process Automation SQL Server Management Studio Relational Databases Prompt Engineering Tool Management Cloud Computing Python (Programming Language) Automated Testing Framework Hybrid Systems Expediting Orders

Other skills

Accountability
Adaptability
Problem Solving

About the company

DistantJob

Staffing & Recruiting

There are three main challenges when hiring remotely. DistantJob was built purposefully to solve those challenges. They are: 1. Finding Global Talent By employing a diverse group of people from all around the world, who speak to developers in their own language — doubly so, because our recruiters are fluent both in the developer’s local language as in their technical language — DistantJob can globalize local talent pools that regular companies would never have access to. 2. Vetting Remote Talent You need three things from a candidate: for them to have the hard and soft skills to thrive in their position; for them to be the cultural fit that will thrive in your team; and for them to have the particular set of skills required to thrive working remotely. DistantJob has over a decade of experience vetting for those, and what’s more — we take the time to meet you and your team to get to know you and determine the perfect cultural fit. 3. Taking Care of Remote Employees One of the major nuisances that companies face when hiring remotely is scaling their local HR operations globally. By acting as the employer of record in the candidate’s country, DistantJob handles all contracts, payment, and HR needs, keeping your people happy and your operation lean. Much like our recruitment team, we have legal and accountant experts worldwide who get your and your people the best conditions available wherever they live.

Company details

Company typeSME

IndustryStaffing & Recruiting

Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Cheesy joke to get you to smile:

Two SQL transactions ask a minister to marry them, but the minister replies, "Only if you're willing to commit."

Summary:

We are seeking a hands-on Data Engineer who is skilled in building complex systems beyond just writing queries. This role focuses on SQL Server in both Linux and Windows environments and requires versatility across various tools, including PowerShell, APIs, Python, and emerging AI/LLM technologies. If you enjoy stretching your expertise beyond SQL and want to contribute to innovative solutions, this position is for you. The role is for one of our North American clients with proprietary software for the insurance industry.

Responsibilities:

Design, build, and optimize complex SQL Server solutions, emphasizing performance tuning, indexing, and data modeling.
Manage relational and semi-structured data, including JSON stored in SQL Server and multi-dimensional datasets.
Query and transform JSON using native SQL Server tools, such as OPENJSON and JSON_VALUE.
Use PowerShell, SQL Server tools, and scripting to automate processes.
Enhance functionalities by integrating with APIs and external systems.
Address problems comprehensively, focusing on end-to-end solutions beyond the database layer.
Operate within a complex, multi-system application environment, avoiding isolated reporting or analytics tasks.
Explore and implement LLM-driven workflows, including prompting and structured outputs.
Continuously enhance efficiency by replacing manual processes with automation.

Required Skills:

Proficient in SQL Server, including query performance, indexing, and data modeling.
Experience handling JSON in SQL Server and managing hybrid data models.
Experience with PowerShell or similar scripting languages for automation purposes.
Ability to work across multiple systems, including databases, APIs, and services.
Proven ability to deliver effective solutions in a timely manner.

Preferred Skills:

Background in smaller teams with end-to-end system ownership.
Experience in complex application environments rather than isolated reporting or analytics settings.
Capability to navigate and solve problems without detailed requirements.
Experience in insurance, financial services, or other regulated, transaction-heavy domains.
Python experience and familiarity with APIs and integrations.
Exposure to LLMs like OpenAI and Claude.
Experience developing internal tools or automation frameworks.
Experience with cloud or hybrid infrastructure.

This is a fully remote position, offering the flexibility to work from anywhere. If you are ready to take ownership and thrive in a fast-paced, adaptive environment, we encourage you to apply!