Senior Data Engineer
DistantJob · Posted May 11, 2026
- Remote
- Remote
- Senior
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. 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.
Requirements
- Nice to have: small team end-to-end ownership
- Nice to have: complex application environments
- Nice to have: problem solving without detailed requirements
- Nice to have: insurance
- Nice to have: financial services