Data Engineer

Who We Are

Porter seamlessly merges analytics with compassionate care to provide unparalleled healthcare coordination and optimization. Our platform empowers members with understanding, compassion, and peace of mind while leveraging robust AI analytics. Through our Care Guide team, we navigate members through the healthcare system, ensuring tailored support, comprehensive in-home assessments, and expert clinical services. By addressing care complexities, Porter enhances quality measures, reduces costs, and improves member experiences.

Who You Are

In this role, you'll be responsible for creating innovative web and mobile applications, ensuring our front-end is responsive, efficient, and deployable across various public cloud regions. You'll apply your skills in developing both static and dynamic pages, integrating APIs with internal and external data sources, and managing sessions effectively.

What You'll Do

1. Develop, maintain, and deliver technical documentation for ETL development, scheduled processes, frameworks, and transformations.
2. Implement data cleaning transformations using ETL tooling, scripting, and data science techniques.
3. Translate user stories into actionable tasks and participate in code reviews and design sessions within Agile processes.
4. Monitor and troubleshoot existing ETL processes, enhancing or creating new ones as needed.
5. Ensure the availability of data for reporting by monitoring and troubleshooting BI applications, datasets, frameworks, cubes, and reports.
6. Utilize Agile methodologies to deliver features, increase velocity, and facilitate team communication and cohesion.
7. Define and apply coding standards and best practices, promoting scalability, availability, and performance in technical designs.

What You Need

Required:

1. 5+ years of advanced SQL knowledge and experience with relational databases, including query authoring and familiarity with various database technologies.
2. Proficiency in database technology, including index strategies, performance tuning, optimization, and stored procedures.
3. Ability to perform root cause analysis on internal and external data and processes to address business questions and identify improvement opportunities.
4. Strong analytical skills for working with structured and unstructured datasets.
5. Extensive Python proficiency for advanced data manipulation, analysis, and visualization.
6. Hands-on experience implementing databases such as NoSQL (e.g., DynamoDB, MongoDB) and relational databases (e.g., PostgreSQL, MySQL, Microsoft SQL).
7. Expertise in building data models and executing complex queries using SQL.
8. Experience in agile software methodologies.
9. Bachelor's degree or equivalent experience/certification.

Preferred:

1. Experience with development in public cloud platforms like AWS or Azure.
2. Highly valuable experience with Databricks, Spark, and big data technologies.
3. Preference for candidates with experience in machine learning, data science, and statistical modeling.
4. Healthcare experience is highly regarded.

What We Offer

1. Competitive Salary
2. Generous Stock Options
3. Medical, Dental, and Vision (benefits within 30 days of hire)
4. Fully Remote
5. Paid vacation and holidays
6. A fun team and special culture