Note: The job is a remote job and is open to candidates in USA. WellSky Corporation is seeking a Sr. Data Engineer who will be responsible for designing, building, and maintaining scalable data pipelines and infrastructure. The role involves collaborating with various stakeholders to enhance data quality, accessibility, and security, while also leveraging AI tools to support data-driven decision-making.
Responsibilities
- Create, develop, maintain, and leverage data pipelines, data models, reporting, and dashboards to solve business problems or assigned tasks in coordination with multiple teams
- Develop and maintain data solutions to enable new or existing solutions and BI development for the data warehouse and data visualization solutions
- Enhance and document workflows for complex data-related challenges by identifying patterns, trends, and anomalies in the data, and find ways to optimize data processing and storage to promote data quality through automation
- Develop understanding of different WellSky solutions and become a subject matter expertise in the healthcare domain
- Identify opportunities in code reviews and contribute to the development of best practices and coding standards
- Adhere to WellSky core values, ensure PHI data security, and adapt to changing BI technologies
- Leverage AI tools and platforms as an integral part of daily responsibilities to enhance decision-making, streamline workflows, and drive data-informed outcomes
- Perform other job duties as assigned
Skills
- Bachelor's degree or relevant work experience
- 4-6 years of relevant work experience
- Strong SQL skills with hands-on experience developing and supporting data pipelines and data warehouse solutions
- Experience with SQL Server data integration and ETL development (including SSIS or equivalent)
- Experience with cloud-based data platforms and services, preferably within GCP environments
- Experience with Snowflake data warehouse development and management
- Experience with DBT for ELT/ETL processes, data modeling, testing, and documentation
- GCP expertise, especially with Cloud SQL, BigQuery, and DataStream
- Experience with data replication tools such as HVR (or similar CDC/replication technologies)
- Experience supporting BI/reporting environments such as Tableau through well-modeled, performant datasets
- Healthcare industry experience
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
Company Overview