Design and optimize SQL Server solutions, manage data, automate processes with PowerShell, and integrate with external systems to enhance functionality.
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
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Build and optimize data models, pipelines, monitoring, lineage, and data quality systems supporting Block’s product data foundation. Own critical data engineering solutions across their full lifecycle, ensure pipeline reliability through on-call support, and translate business and product needs into automated data solutions. Develop AI-assisted workflows and agents for data quality, issue resolution, and operational efficiency while partnering with engineering, product, data science, and machine learning teams.
Top Skills:
AirflowDatabricksDbtGitOmniPrefectPythonSnowflakeSQLTerraform
Cloud • Information Technology • Security • Software • Cybersecurity
Partner with sales teams to win strategic data security opportunities. Deliver technical presentations, gather customer requirements, lead product evaluations, configure solutions, and design test plans. The role requires extensive pre-sales experience, security and networking expertise, data protection knowledge, AI fluency, and collaboration across matrixed go-to-market and partner teams.
Top Skills:
Coding AssistantsData Protection TechnologiesGenerative AiLlmsNetworking TechnologiesSaaSSaseSecurity TechnologiesWeb TechnologiesZscaler Zero Trust Exchange
Artificial Intelligence • Analytics
Lead the architecture and hands-on delivery of end-to-end Azure data platforms, including ingestion, transformation, lakehouse modeling, analytics, APIs, and activation. Build batch and streaming pipelines with Microsoft Fabric, Azure Data Factory, Databricks, Python, PySpark, and SQL. Implement governance, security, CI/CD, MCP and agentic AI integrations, while troubleshooting production systems. Mentor engineers, advise client stakeholders, contribute to presales, and establish reusable engineering standards.
Top Skills:
Azure Ai FoundryAzure Data FactoryAzure Data Lake Storage Gen2Azure DatabricksAzure DevopsAzure Event HubsAzure SynapseCopilot Data AgentsDatabricks WorkflowsDelta LakeAzureMicrosoft FabricMicrosoft PurviewModel Context ProtocolOnelakePysparkPythonSQLUnity Catalog
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
