At WellSky, the Sr. Staff Data Engineer is responsible for designing, building, and maintaining scalable data pipelines, infrastructure, and data visualization to support data-driven decision-making. You will collaborate with data scientists, analysts, and stakeholders to increase data quality, accessibility, and security.
What You'll Do
- Advise on and leverage data pipelines, models, reporting, and dashboards to solve business problems in coordination with multiple teams.
- Research, develop, and maintain data solutions to enable new or existing BI development for the enterprise data warehouse and visualization solutions.
- Maintain and optimize current data infrastructure for performance, scalability, and reliability across all data workflows.
- Influence code reviews through WellSky solution subject matter expertise across multiple business units.
- Develop and train teammates on data security, architecture, and governance requirements while maintaining data quality standards through automation.
- Strategize business requirements and translate work into data engineering architecture while adhering to PHI data security and adapting to changing BI technologies.
What We're Looking For
- Bachelor's degree in a related field or equivalent work experience.
- At least 12-15 years of related work experience.
- Proven track record of successfully leading large-scale data platform migrations and modernization projects.
- BigQuery Expert: Advanced optimization, cost controls, Lakehouse architecture, and enterprise-scale migrations from legacy systems (MS SQL, Teradata, Oracle).
- Data Architecture: Star schema design, dimensional modeling, and modern data platform patterns for analytics-ready solutions.
- Programming & Infrastructure: Python, SQL, Terraform for automated, scalable data engineering.
- Data Processing & Transformation: Dataflow, Airflow, dbt, Dataform for high-volume pipeline orchestration.
- Enterprise Integration: HVR/Fivetran or DataStream for real-time data replication across SQL Server, Snowflake, and BigQuery.
- Business Intelligence: Tableau, Looker, or Sisense with advanced user administration and performance optimization.
Nice to Have
- Healthcare industry experience.
Technical Stack
- Databases: BigQuery, MS SQL, Teradata, Oracle, Snowflake
- Languages & IaC: Python, SQL, Terraform
- Processing & Orchestration: Dataflow, Airflow, dbt, Dataform
- Integration: HVR/Fivetran, DataStream
- BI & Visualization: Tableau, Looker, Sisense
Benefits & Compensation
- Excellent medical, dental, and vision benefits.
- Mental health benefits through TelaDoc.
- Prescription drug coverage.
- Generous paid time off, plus 13 paid holidays annually.
- Paid parental leave.
- 100% vested 401(K) retirement plans.
- Educational assistance up to $2500 per year.
Work Mode
This is a remote position.
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.
