DistantJob Logo

DistantJob

Senior Data Engineer

Reposted 3 Months Ago
Remote
Hiring Remotely in CAN
Senior level
Remote
Hiring Remotely in CAN
Senior level
Design and optimize SQL Server solutions, manage data, automate processes with PowerShell, and integrate with external systems to enhance functionality.
The summary above was generated by AI

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!

Similar Jobs

3 Days Ago
Remote or Hybrid
CA
Senior level
Senior level
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Design, build, and operate shared backend platforms and frameworks for data acquisition, processing, and access. Lead projects from architecture through production, supporting event-driven, batch, and streaming systems. Partner with software and data teams, improve observability and reliability, make scalable architectural decisions, mentor engineers, and develop reusable capabilities for analytics and machine learning.
Top Skills: AWSBlock-ForgeCloudeventsDatabricksDatahubDbtIcebergJavaKafkaKotlinPrefectSnowflakeSparkSpark Structured Streaming
9 Days Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Design, build, and operate shared backend platforms and frameworks for data acquisition, processing, and access. Lead projects from architecture through production, develop event-driven and batch or streaming systems, and improve reliability, observability, scalability, and data quality. Collaborate with software engineers, data engineers, and data scientists, make architectural trade-offs, mentor engineers, and contribute to technical standards. The role may also involve external data integrations and analytics and machine-learning data systems.
Top Skills: AWSCloudeventsDatabricksDatahubDbtIcebergJavaKafkaKotlinPrefectSnowflakeSparkSpark Structured Streaming
5 Days Ago
In-Office or Remote
Senior level
Senior level
Aerospace • Automation
Design, build, and operate scalable batch and streaming data infrastructure for autonomous vehicle telemetry, sensor, and operational data. Develop AWS-based pipelines, edge-to-cloud ingestion systems, data models, storage architectures, and monitoring tools. Ensure production data reliability, quality, performance, and cost efficiency while collaborating with autonomy, software, infrastructure, product, and fleet operations teams.
Top Skills: Amazon KinesisAmazon RedshiftAmazon S3AWSAws AthenaAws GlueAws LambdaGcp BigqueryKubernetesPythonRosRos BagsSQLTerraform

What you need to know about the Vancouver Tech Scene

Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account