PHI Health is looking to create and expand its data store and architect solutions including data flows and data collection for teams across the business to support its next generation of products and data initiatives.
Requirements
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
- Experience with traditional ETL technologies such as Microsoft SSIS, Informatica, Talend, etc.
- Experience with emerging cloud data platform providers such as Microsoft Fabric, Snowflake, Databricks, etc.
- Experience with distributed processing technologies like Apache Spark engine and its various querying languages such as PySpark, Spark SQL, etc.
- Experience building data pipelines, architectures, and data sets with little to no documentation and across main domains.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Strong analytic skills.
Responsibilities
- Create and maintain data pipelines, data flows, PySpark notebooks, and semantic models.
- Assemble complex data sets from multiple domains to meet functional and non-functional business requirements.
- Identify, design, and implement internal process improvements: running manual processes, automating manual processes, improving data delivery, re-designing infrastructure for greater scalability, etc.
- Build the processes required for extraction, transformation, and loading of data from a wide variety of data sources including SQL, web APIs, and spreadsheets.
- Collaborate with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
- Keep our data separated via access for diverse use cases including HIPAA, personally identifiable information, and financial.
- Create data tools for analysts and domain experts to assist them in building and improving the company’s services as an innovative industry leader.
Other
- High level of customer responsiveness, excellent documentation and communication skills and attention to detail.
- 5+ years of experience in a Data Engineer role, quantitative field.
- Show Real Grit - With safety as your guide, you pursue every task with drive, energy and a commitment to finish.
- Perform with Integrity – You always do what’s right.
- Be a great team player - In order to achieve the best possible outcomes for our patients and customers, you must treat others with dignity and respect, and be committed to working as a cohesive team toward a common purpose.
