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.

Key Responsibilities:

• 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.

Required Qualifications:

• 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
• 2+ years of SQL experience (NoSQL experience is a plus)
• 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

#LI-TC1

#LI-Onsite

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.

WellSky provides equal employment opportunities to all people without regard to race, color, national origin, ancestry, citizenship, age, religion, gender, sex, sexual orientation, gender identity, gender expression, marital status, pregnancy, physical or mental disability, protected medical condition, genetic information, military service, veteran status, or any other status or characteristic protected by law. WellSky is proud to be a drug-free workplace.

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, dental, and vision benefits
• Mental health benefits through TelaDoc
• Prescription drug coverage
• Generous paid time off, plus 13 paid holidays
• Paid parental leave
• 100% vested 401(K) retirement plans
• Educational assistance up to $2500 per year