Data Engineer

The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines, infrastructure, and data visualization to support our data-driven decision-making processes. The scope of this job includes collaborating with data scientists, analysts, solutions partners, and other stakeholders to increase data quality, accessibility, and security., * Design, implement, and optimize robust, scalable data pipelines using GCP services such as BigQuery, Cloud Dataflow, Cloud Dataproc, and Cloud Composer(or airflow). 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. Ensure solutions are scalable and high-performance.
• 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.
• Adhere to WellSky core values, ensure PHI data security, and adapt to changing BI technologies.
• Perform other job duties as assigned.

• Bachelor's degree in a related field or equivalent work experience
• At least 2-4 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, Applicants for U.S.-based positions with WellSky must be legally authorized to work in the United States. Verification of employment eligibility will be required at the time of hire. Certain client-facing positions may be required to comply with applicable requirements, such as immunizations and occupational health mandates.

Here are some of the exciting benefits full-time teammates are eligible to receive at WellSky:

• 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

WellSky is where independent thinking and collaboration come together to create an authentic culture. We thrive on innovation, inclusiveness, and cohesive perspectives. At WellSky you can make a difference.