Lead - Data Engineer

About GeoBlue

At GeoBlue, we combine the latest in technology with worldwide healthcare expertise and a commitment to unsurpassed service to deliver first-rate global medical assistance and health benefits for world travelers. We are proud to say we set the standard for service and innovation in the health services industry.

We are currently seeking a Lead Data Engineer to join our corporate Data Analytics team.

What You Will Do:

As Lead Data Engineer, you will oversee building data warehouse solutions and provide technical leadership within the Data Analytics team. You will work closely with cross-functional teams to architect, design, develop, and maintain scalable data warehouse solutions using Snowflake and related technologies.

• Lead the design and architecture of our organization's data warehousing solutions together with the Director of the area, leveraging expertise in data architecture principles and best practices. Collaborate with stakeholders to define data models, schemas, and architecture patterns that optimize data storage, accessibility, and performance.
• Manage the data engineering in developing robust ETL and ELT processes for ingesting, processing, and transforming data from diverse sources into our data warehouse. Ensure the reliability, scalability, and efficiency of ETL pipelines, employing technologies and tools such as Snowflake, Rivery, DBT, and SQL.
• Responsible for optimizing the performance of our data warehouse environment, identifying, and resolving bottlenecks, and fine-tuning query performance.
• Establish data governance policies, oversee data quality initiatives, and implement data validation and cleansing processes to ensure the accuracy, completeness, and consistency of data stored in the data warehouse.
• Assess the scalability requirements of our data warehouse infrastructure and develop capacity planning strategies to accommodate future growth and expansion. Evaluate hardware and software options, design scalable architectures, and implement solutions that support increasing data volumes and user loads.
• Work closely with security teams to implement access controls, encryption mechanisms, and auditing procedures to protect sensitive data stored in the data warehouse. Ensure compliance with regulatory requirements such as GDPR, HIPAA, or SOC 2, implementing policies and procedures to safeguard data privacy and integrity.
• As the senior DW developer, you will provide leadership, guidance, and mentorship to data engineers, developers, and other team members. You will foster a culture of collaboration, innovation, and continuous learning, empowering team members to develop their skills and expertise.
• Partner with stakeholders to understand their data requirements, prioritize initiatives, and deliver solutions that meet business needs and objectives.
• Keeping abreast of emerging technologies and trends in data warehousing. Evaluate new tools, platforms, and methodologies, assessing their suitability for our data warehouse environment and recommending adoption strategies that align with our long-term goals and objectives.
• Drive a culture of continuous improvement and innovation. Seek opportunities to optimize processes, streamline workflows, and introduce innovative solutions that enhance the performance, reliability, and agility of our data warehouse environment, ultimately enabling our organization to derive maximum value from its data assets.

• Bachelor's degree in Computer Science, Information Technology, or a related field plus at least 4 years of experience in data warehouse development and administration for on premise and cloud data warehouse solutions.
• Extensive experience with Microsoft SQL Server, including proficiency in T-SQL scripting, stored procedures, and performance tuning.
• Hands-on experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Proven experience in dimensional modeling (star/snowflake schemas), normalized modeling, and data vault methodologies.
• Ability to design and implement modular and reusable dbt models with a clear separation of staging, intermediate, and mart layers.
• Expertise in metadata-driven development, data lineage, and dependency tracking in modern ELT frameworks.
• Experienced in Snowflake Data Warehouse, including designing data models, writing SQL queries, and optimizing performance. Experience managing Snowflake roles, warehouses, and access policies in a secure, governed environment. Familiarity with Snowflake's account usage schema and cost optimization techniques.
• Experience with modern data transformation tools such as DBT (Data Build Tool) for cloud transformation.
• Strong understanding of dbt Cloud features including job orchestration, testing, documentation, and CI/CD integration.
• Experience implementing dbt best practices, including the use of packages, macros, and version control via Git.
• Experience training and transitioning on-premises resources to new cloud technologies.
• Experience designing orchestrated data pipelines using Rivery or similar tools (e.g., Airflow, Prefect, Matillion, FiveTran).
• Ability to manage Rivery logic rivers, mappings, and incremental loading strategies with CDC mechanisms.
• Knowledge of API-based ingestion pipelines, handling complex data formats (e.g., JSON, XML), and unstructured data.
• Familiarity with cloud computing platforms such as AWS, Azure, or GCP.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams.

• Flexibility to work in an office and/or at-home, remote office environment.
• Competitive base pay plus annual bonus targets
• Competitive medical plans, with Telemedicine available
• 401(k) with generous company match
• Robust PTO accrual program with carry-over option
• Paid parental leave
• Employee assistance and wellness support 24/7
• Free international healthcare coverage and work abroad arrangements available
• Tuition reimbursement