Posted at: 23 April

Senior SQL Software Engineer

Company

Pilot Company

Pilot Company is a Knoxville-based petroleum corporation operating a network of over 750 travel centers and convenience stores across the US, serving both B2B and B2C markets in the travel and transportation industry.

Remote Hiring Policy:

Pilot Company primarily hires from various regions within the United States, particularly in the South, with some roles offering flexibility for remote work tasks. Specific job postings may have different requirements, so candidates are encouraged to review individual listings for details.

Job Type

Full-time

Allowed Applicant Locations

Romania

Salary

€70,000 to €100,000 per year

Apply Here

Job Description

Our client is a leading insurance solutions provider in the DACH region. While working decentralized, they employ the latest technologies in the Azure stack to provide quality products and solutions for their customers and partners.

Responsibilities:

Database Design & Development -> Develop complex SQL queries and scripts for data extraction, manipulation, and reporting. Create and maintain database schemas, tables, indexes, views, functions, triggers, and stored procedures. Design and implement SQL Database architectures, ensuring scalability and high availability.

Write and Optimize Complex SQL Queries -> Develop, review, and fine-tune SQL queries to efficiently process large volumes of data while maintaining performance and reliability.

Monitor and Improve Data Quality -> Implement validation rules and data checks to ensure the accuracy, consistency, and completeness of critical reporting datasets.

Performance Optimization and Monitoring -> Analyze cloud-based SQL queries and database performance metrics to recommend and implement optimization strategies. Use Azure Monitor and other tools to oversee database performance and automate tuning processes.

Ensure Reliable Regulatory Data Flows -> Support the preparation of accurate and traceable data for regulatory reporting, ensuring compliance with financial regulations and internal standards.

Build Scalable Data Pipelines in Azure -> Contribute to the design and maintenance of scalable, cloud-native data pipelines using Azure services to manage and transform data end-to-end.

Collaborate Across Functions and Regions -> Work closely with business analysts, data engineers, and stakeholders from different markets to align on regulatory requirements and reporting logic.

Apply Here