Senior Data Engineer
About The Position
Vital Services is seeking a talented and experienced Senior Data Engineer to join our growing Information Technology team. This is an extraordinary opportunity to be a part of, and play an integral role in, the development of our Data & Reports team! As a Senior Data Engineer, you will work closely with our customer’s department leads and project coordinators to evaluate business needs and develop reports and dashboards to support strategic goals. The core focus of this role is to architect, build, and optimize robust data pipelines and storage solutions that ensure secure, high-performance data delivery, reporting accuracy, and seamless data synchronization across multiple core systems. You will also collaborate with other members of the Data and Information Technology teams to plan, design, develop, test, and deploy business intelligence data solutions. The core focus of this role is to architect, build, and optimize robust data pipelines and storage solutions that ensure secure, high-performance data delivery, reporting accuracy, and seamless data synchronization across multiple core systems. A successful candidate will understand and fulfil their responsibility to develop and support databases, data structures, and data flow, with a focus on data integrity and reliability.
Requirements
- 5+ years of dedicated data engineering experience working with large-scale production databases and high-compliance distributed data environments.
- Proven mastery in building complex data pipelines, working with heavy data orchestration tools, and extracting data from complex third-party API networks.
- Deep expertise in SQL/NoSQL query tuning, data warehousing principles, schema evolution, and index optimization.
- Hands-on experience with cloud data storage architectures (e.g., AWS, Azure) and modern practices for data pipelines.
- A clear track record of debugging mismatched data architectures, handling breaking schema changes, and optimizing slow, multi-system data jobs.
- A minimum of 5 years of experience in data engineering, analytics, or reporting roles.
- Knowledgeable and experienced with different data sources, such as, MS SQL, Excel files, Azure SQL, Azure Cosmos DB, AS400, DB2, and Cloud Data Sources.
- Deep understanding of SQL databases and query language.
- Advanced Excel skills.
- Familiarity with data storage, retrieval, and manipulation methods within both relational and non-relational database architectures.
Nice To Haves
- At least 3 years of work experience in Business Intelligence is preferred.
- Bachelor’s degree in Mathematics, Economics, Computer Science, or other quantitative degrees preferred.
- Strong knowledge of SQL, SSRS, MS Excel, Power BI, Oracle, Tableau, and other Business Intelligence tools.
- Knowledge and experience in the Commercial (P&C) Insurance industry is a plus.
Responsibilities
- Design, build, and maintain scalable data infrastructure and automated pipelines to ingest, transform, and move high-volume data securely.
- Define and optimize data models, relational/non-relational database structures, and query performance to support reporting and operational applications.
- Own the monitoring and validation of data flows to ensure complete accuracy, quality, and compliance.
- Map out and resolve data dependencies across disparate external APIs, legacy databases, and cloud infrastructure, translating data "unknowns" into structured execution plans.
- Partner with the data and development teams to ensure pristine task estimating, technical documentation, and delivery data updates.
Benefits
- Hybrid Flexibility
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
