Policy Reporter is committed to Employment Equity. Accommodations during the recruitment process are available upon request for candidates with disabilities.
Policy Reporter offers a suite of insights products and consulting services to enhance market access strategies and patient support initiatives. By tracking payer policies in near real time, we ensure that the largest pharmaceutical, medical device and diagnostics manufacturers, leading academic institutions and organized provider groups have the most up-to-date data and evidence-based guidance to help patients access the therapies they need. For more information, please visit https://www.policyreporter.com.
About the Team:
We’re a team of engaged developers who love building reliable, scalable systems that solve direct customer problems. We’re an easy-going team and have found value in being open to learning new technologies and we're eager to dive into our applications to tackle a wide variety of technical issues.
As a team we are making significant investments into our tech stack by improving our data structures, increasing automation, scalability, and software quality. We have a challenging problem of building a comprehensive database of payer policy data and keeping it up to date.
At Policy Reporter, people are the heart of our company. We foster an environment that promotes diversity and inclusion, and believe in a culture that supports open communication, continuous learning, innovation, and team collaboration. We create opportunities for employees to thrive both personally and professionally and work together with them to carve out their career path and future with the Company. Our employees work hard and are empowered to take on challenges head-on by being flexible and ready for change. We’re focused on delivering great work with great people. At Policy Reporter, you will be able to do what you love, be yourself, and impact the lives of millions of patients.
Policy Reporter’s Core Values:
Value & Respect
Ownership & Accountability
Provide technical leadership to the team. Including, but not limited to:
Query performance tuning assistance
Database handling best practices and explanation of advanced features
Guidance and recommendations to the management team
Work with Engineering and management to identify and resolve database performance issues as they arise, and make recommendations for improvements
Proactively identify database performance impediments and resolve them by proposing and delivering changes to the codebase
Contribute to projects to achieve project goals and consult with other project teams and departments to share best practices and other knowledge
Work towards departmental goals and objectives like improving accuracy of technical project estimates, improving database resiliency, reliability, scalability and performance
As a project's technical lead, collaborate with teams outside of Engineering to ensure that all stakeholders understand project goals, requirements and realistic timelines
5+ years experience supporting, tuning and administering PostgreSQL databases
Expert level knowledge of PostgreSQL, its query planner, query profiling, benchmarking and performance tuning, connection pooling/pgpool
Experience with distributed systems, database partitioning, replication and sharding
Experience with building and maintaining high availability architecture
Experience with AWS Aurora and RDS for PostgreSQL
Experience in various data systems (relational databases, Elasticsearch/OpenSearch, BI systems) and migrating data across multiple systems
Experience working with large datasets — tens or hundreds of millions of rows
Bachelor’s degree in Computer Science/Engineering discipline or equivalent experience.
Excellent debugging, troubleshooting, and problem solving skills.
Great communication skills (written and verbal)
Ability to learn quickly using both internal and external resources
Good to have:
Experience with different database technologies such as NoSQL and OLAP, TimescaleDB or other TSDBs
Experience with other AWS services such as S3/Glacier, Athena, RedShift
Experience with building data ETL pipelines
Experience with Splunk and SPL
Experience with load testing, stress/fatigue testing
What we offer...
Policy Reporter’s Core Values:
Software Powered by iCIMS