Senior Data Engineer
DistantJob6 months ago
Remote, WorldwideSenior
Responsibilities
- Design, build, and optimize SQL Server solutions with emphasis on performance tuning, indexing, and data modeling.
- Manage relational, semi-structured, JSON, and multi-dimensional data in SQL Server.
- Query and transform JSON using SQL Server tools including OPENJSON and JSON_VALUE.
- Use PowerShell, SQL Server tools, and scripting to automate processes and replace manual work.
- Integrate databases and applications with APIs, services, and external systems.
- Deliver end-to-end solutions across complex multi-system application environments.
- Explore and implement LLM-driven workflows involving prompting and structured outputs.
Requirements
- Proficiency 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.
- Ability to work across databases, APIs, services, and multiple systems.
- Proven ability to deliver effective solutions in a timely manner.
- Preferred qualifications include Python, API and integration experience, LLM exposure, internal tools or automation framework development, and cloud or hybrid infrastructure experience.
- Experience in smaller teams, complex application environments, insurance or financial services, regulated domains, and solving problems without detailed requirements is preferred.
Benefits
- Fully remote position with flexibility to work from anywhere.
About DistantJob
DistantJob is a privately held staffing firm that recruits, vets, and places remote software and IT professionals for companies worldwide. Based in Saint-Laurent, Quebec, it supports direct hires and long-term remote engagements and can act as an employer of record to manage local contracts, payroll, and compliance.