Job description
Who We Are:
Greenphire is a leading provider of clinical payment and communication solutions. We provide software as a service (SaaS) to reduce costs, increase participant retention, and produce quantifiable results for our clients in the clinical trial industry. Our vibrant culture focuses on four key values: All In, As a Team, For a Purpose, Solving Problems.
We are a multi-year recipient of the Philadelphia Business Journal’s Best Places to Work award, and love to give shout-outs and awards to our employees. Our For A Purpose committee champions philanthropic activities throughout the year so employees can give back to our community. We have a diversity committee that focuses on breaking down barriers, recognizing that our uniqueness is what makes us so successful!
How You Will Contribute:
- Gather requirements; compile data; prepare and analyze results; distribute reports
- Interface with developers, product managers, and business analysts to understand data needs
- Combine data from a variety of sources for use in reporting, research, and support decision-making
- Develop, design, and launch new data extraction, transformation, and loading processes in production
- Develop, design, and test complex program logic in order to produce analytical reports
- Develop, design, implement and maintain data pipelines
- Ensure data integrity; develop and produce reports utilized in measuring data accuracy
- Troubleshoot data issues, validate result sets, recommend and implement process improvements
- Improve performance and value of existing reports
- Develop and support production of new reporting processes
For Consideration You Will Have:
- BS/BA in technical field, Computer Science, Mathematics or relevant work experience and/or training
- Strong SQL development skills and understanding of multiple SQL variants (e.g. MSSQL, PostgreSQL, kSQL, FlinkSQL/SparkSQL)
- Expert understanding of custom ETL design, implementation, and maintenance
- Good understanding of data warehousing design concepts and data modeling
- Fluency in at least one OOP language (Python preferred)
- Experience with API development
- Experience in report design/development
- Experience in real-time streaming pipelines (e.g. Kafka, Flink, Spark) is a plus
- Experience with visualization tools (e.g. Power BI, Looker, Qlik, Tableau, Sisense) is a plus
- Experience with data integration tools (e.g. SSIS, Streamsets, Informatica) is a plus
- Excellent verbal and written communication skills
- A keen attention to detail
- A collaborative mindset
- Ability to learn as you go