Principal Software Engineer (Etl)

For more than 20 years, PointClickCare has been the backbone of senior care. We’ve amassed the richest senior care dataset making our market density untouchable and our connections to the healthcare ecosystem exponentially more powerful than those of any other platform.
With Collective Medical & Audacious Inquiry, we’ve become the most expansive, full-continuum care collaboration network, offering care teams immediate, point-of-care access to deep, real-time insights at every stage of a patient’s journey.
For more information on PointClickCare, please connect with us on Glassdoor and LinkedIn.
** THIS IS A HYBRID ROLE, WITH A 1 DAY IN OFFICE REQUIREMENT **
Have you ever wanted to be engaged as a technical leader in defining and building a completely new large-scale SaaS platform? Are you passionate about finding solutions to complex technical issues that can scale and perform against challenging business and customer objectives? Would you be excited to work on projects that bring actual, tangible benefits to millions of people in real-life health-care situations every day?
PointClickCare is searching for a Principal Software Engineer who will contribute to best practice application development by writing and rigorously defending production-grade code on a regular basis, while also encouraging and optimizing the daily execution of technical excellence across an empowered Scrum team. This is a hands-on leadership role, requiring the analysis, design and implementation of advanced data processing and delivery solutions across multiple data platform technologies, while mentoring other team members and delivering both business and technical objectives through ambiguity and uncertainty.
To succeed as a Principal Software Engineer at PointClickCare, you need to be collaborative, adventurous and passionate. Collaborative means that you’re enthusiastic about jumping in to help achieve the team’s top priorities, no self-promoting politicians allowed. Adventurous means that you’re not afraid to dive into uncharted technical territory and get your own hands dirty while supporting and driving delivery of complex features through a dedicated Scrum team. Passionate means that you’re eager to learn and share knowledge that drives the team forward and excited to be part of a movement that is positively impacting the lives of seniors and their caregivers all over North America.
What Your Day-to-day Will Look Like

• Analyze and debug complex systems
• Ensure software is up to date with latest technologies
• Leading the development team in designing and developing end-end ETL and Data Mart solutions.
• Develop applications by producing clean, efficient, production-ready code
• Write unit and integration tests to ensure code quality
• Demonstrate expertise and passion for evidence-driven engineering in all activities and act as a reference point to drive team ownership and accountability
• Collaborating with the Product team, Data Architects and Data Modelers to understand requirements (both functional and non-functional) and data.
• Work closely with the engineering manager and provide technical guidance in software design and development activities by mentoring other team members and encouraging best practices
• Review the work of others, and invite others to review your work
• Work with business stakeholders to understand and iterate over software and business requirements
• Identify, prioritize and execute complex tasks in ways that are rigorous, scalable and performant, and that support team development and growth
• Collaborate with internal teams and vendors to fix and improve products
• Creating and documenting detailed technical specifications and designs
• Help architect, design and build high-quality software
• Perform validation and verification testing in a test-driven manner

What Qualifications We’re Looking For

• Analytical mind with problem-solving aptitude
• Experience using system and performance monitoring tools (e.g. New Relic, DataDog, AppDynamics)
• Deep experience integrating frameworks into core engineering practices
• Solid understanding of Data Warehouse principles and patterns
• Self-starter with the ability to deliver with minimal supervision
• Good working experience with Relational databases like Microsoft SQL Server, Oracle, MySQL etc…
• Solid ability utilizing SQL (e.g., writing queries), designing and loading (using ETL patterns) dimensional Data Marts. Experience with Data vault is a plus.
• Solid experience as a Senior Software Engineer for Microservices/Cloud.
• Strong hands-on development experience in the data space – ETL, Data Mart Design and Development, Analytics and Reporting
• Extensive experience with multiple technical languages, ecosystems and platforms
• Experience with automated testing frameworks
• Exceptional coding abilities
• Excellent organization, critical-thinking and personal leadership skills
• Hands-on experience implementing ETL solutions using tools like SQL Server Integration Services (SSIS), PowerCenter Informatica, Oracle Data Integrator (ODI). Experience with Azure Data Factory (ADF) and/or Azure Analysis Services is a plus.
• BSc/BA in Computer Science or a related degree

Bonus Points For

• Experience with building large scale SaaS software
• Linux knowledge
• Test-driven design experience
• Public Cloud (Microsoft Azure) experience
• Knowledge with CI/CD pipeline
• Knowledge with NoSQL databases
• Experience with containerization and virtualization
• Knowledge with scripting languages such as Python
• Knowledge with Spark and/or Synapse
• Knowledge with creating dashboards and visual interactive reports using Power BI and DAX functions

It is the policy of PointClickCare to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, national origin, status, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, veteran status, genetic information, or any other basis protected by law. PointClickCare welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process. Please contact [email protected] should you require any accommodations.
When you apply for a position, your information is processed and stored with Lever, in accordance with Lever’s Privacy Policy. We use this information to evaluate your candidacy for the posted position. We also store this information, and may use it in relation to future positions to which you apply, or which we believe may be relevant to you given your background. When we have no ongoing legitimate business need to process your information, we will either delete or anonymize it. If you have any questions about how PointClickCare uses or processes your information, or if you would like to ask to access, correct, or delete your information, please contact PointClickCare’s human resources team: [email protected]
PointClickCare is committed to Information Security. By applying to this position, if hired, you commit to following our information security policies and procedures and making every effort to secure confidential and/or sensitive information.