Sr. Data Engineer

Key Responsibilities

• Design, implement, and optimize robust, scalable data pipelines using GCP services such as BigQuery, Cloud Dataflow, Cloud Dataproc, and Cloud Composer.
• Ensure data pipelines are efficient, reliable, and meet business needs.
• Build, maintain, and optimize data lakes, data warehouses, and other data storage solutions, primarily leveraging BigQuery and Cloud Storage for data warehousing needs.
• Integrate data from various sources, including APIs, flat files, databases, and other external systems, into cloud-based data solutions.
• Manage ETL processes to ensure smooth data flow across systems.
• Apply best practices in dimensional data modeling, schema design, and ETL processes to ensure efficient data retrieval, storage, and analytics.
• Work closely with internal teams, data scientists, analysts, and stakeholders to understand data needs, deliver actionable insights, and provide timely updates.
• Communicate effectively regarding project timelines and deliverables.
• Work with Snowflake for managing data warehouses, optimizing performance, and ensuring efficient querying and data loading processes.

Required Qualifications

• Bachelor's degree in a related field or equivalent work experience
• At least 4-6 years of related work experience

Preferred Qualifications

• Knowledge of best practices and IT operations in an always-up, always-available service
• Experience with or knowledge of Agile Software Development methodologies
• Excellent problem solving and troubleshooting skills
• Process oriented with great documentation skills
• Excellent oral and written communication skills with a keen sense of customer service
• 2+ years of Python or Java development experience
• Strong SQL skills with hands-on experience developing and supporting data pipelines and data warehouse solutions
• 2+ years of experience with schema design and dimensional data modeling
• Ability in managing and communicating data warehouse plans to internal clients
• Design and implement data pipelines using GCP services such as Cloud Dataflow, Cloud Dataproc, Cloud Composer
• Build and maintain data lakes, data warehouses, and other data storage solutions using GCP technologies like BigQuery and Cloud Storage
• Integrate data from various sources such as APIs, flat files, and databases
• Healthcare industry experience

Job Expectations

• Willing to work additional or irregular hours as needed
• Must work in accordance with applicable security policies and procedures to safeguard company and client information
• Must be able to sit and view a computer screen for extended periods of time

Benefits

• Excellent medical with Rx, dental, and vision benefits
• Mental Health support through EAP
• Generous paid time off, plus 13 paid holidays
• 100% vested 401(K) retirement plans
• Educational assistance up to $2500 per year

Data Privacy Notice for Job Applicants and Teammates

WellSky is committed to protecting the privacy of its employees and applicants. We collect and use personal information only as necessary to fulfill our obligations under applicable laws and regulations. We do not sell or share personal information with third parties without your consent, except as required by law. If you have any questions about our data privacy practices, please contact us at [data.privacy@wellsky.com].