Data Architect III

Company Overview

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 .

About the Team

Were a team of engaged developers who love building reliable scalable systems that solve direct customer problems. Were a friendly and collaborative team and have found value in being open to learning new technologies and 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 structure 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.

The technologies that we love include but are not limited to Python PHP React ML/LLMs PostgreSQL OpenSearch Docker AWS. We care deeply about building quality products.

Position Summary

We are looking for a self-directed results-driven candidate who is ready to experiment with finding solutions for difficult problems appreciates challenges is not afraid of asking questions and enjoys working with others. This position focuses on modeling a complex commercial market and providing a performant and scalable solution for data delivery.

Role & Responsibilities

• Contribute to projects by consulting on reviewing designing and/or implementing data models storage systems and queries and the application code (PHP) which interfaces with them in order to help developers leverage our data effectively
• Advise on proposed model changes to best suit our long-term goals and support existing technical and business needs
• Identify assess and address performance issues and logical bugs related to suboptimal usage of big data via model schema and code changes
• Collaborate with teams across our organization to distill complex product requirements into realistic performant and intuitive data structures
• Advocate for and educate others about best practices related to software development and data architecture in particular
• Proactively identify roadblocks and anti-patterns in our system
• Analyze issues coordinate troubleshooting and problem-solving activities.
• Ensure post-incident analyses are completed and followed up with appropriate improvements

Skills & Qualifications

• 5 years of backend development experience with relational and NoSQL databases
• Deep expertise in PostgreSQL including performance tuning and internal mechanics
• Experience with PHP is preferred; willingness to learn it is required
• Strong understanding of data modeling schema design and query optimization
• Experience designing scalable systems and structuring applications for long-term maintainability
• Familiarity with AWS data services (RDS Aurora Redshift)
• Comfortable translating business requirements into technical solutions
• Skilled in building data-driven APIs and reporting systems
• Excellent communication skills with both technical and non-technical stakeholders
• Knowledge of caching indexing and other performance-enhancing techniques

What We Offer

• Competitive compensation package including extended health benefits paid time off volunteer leave employer-matching retirement savings etc. and company-paid Employee Assistance Program
• Excellent opportunities for personal and career development
• Collaborative and supportive company culture
  

Policy Reporters Core Values

• Excellence
• Value & Respect
• Continuous Learning
• Ownership & Accountability
• Teamwork

Policy Reporter is committed to Employment Equity. Accommodations during the recruitment process are available upon request for candidates with disabilities.