BI Application Developer

Apex Systems; Mississauga; On-site; CAD 110,000 - 165,000; Full time

Job summary

Everforth Apex in Mississauga is seeking a senior PostgreSQL Database Engineer to design and build the next-generation data platform for analytics and portfolio management. You will define scalable schemas, optimize queries, and establish data lineage to ensure a trusted source of truth for reporting.

The role emphasizes database architecture, data modeling, and supporting data-driven applications, with R Shiny experience preferred but secondary to core database expertise.

Qualifications

• 5–7+ years in Database/Data/Backend Engineering or similar role.
• Strong hands-on PostgreSQL experience.
• Experience designing schemas, table structures, keys, and relationships.
• Expertise in data architecture, data management, and performance optimization.
• SQL developmentStrong communication with stakeholders.

Responsibilities

• Design and develop PostgreSQL databases as the single source of truth for portfolio data.
• Create logical/physical data models, schemas, and indexing strategies.
• Optimize performance for reporting and application workloads.
• Implement historical data retention, snapshots, and data lineage.
• Collaborate with app developers to integrate database and application.
• Support R Shiny web application as a secondary resource.
• Contribute to CI/CD, testing, documentation, and deployment of the data platform.

Skills

PostgreSQL

Data modeling

SQL development

Database design

Performance tuning

Data lineage

R Shiny familiarity

Tools

Docker

Kubernetes

CI/CD

Job description

Sr Database Engineer (PostgreSQL)ContractMississauga

We are seeking a senior-level Application Developer / PostgreSQL Database Engineer to help build the next generation of a self-service analytics and portfolio management platform. While the team has an existing R Shiny web application, the primary focus of this role is designing and developing the underlying PostgreSQL data platform that will serve as the long-term source of truth for project and portfolio reporting.

The ideal candidate will come from a Data Engineering, Database Engineering, or Backend Engineering background and have experience designing scalable relational databases, building data models, and supporting data-driven applications. This individual will play a key role in establishing historical data tracking, improving data lineage, and creating a structured, scalable foundation for analytics. Experience with web application development, particularly R Shiny, is preferred but secondary to strong database and data architecture expertise.

Responsibilities

• Design and develop a PostgreSQL database to serve as the centralized source of truth for portfolio and project management data.
• Create and maintain logical and physical data models, including table structures, relationships, and schema design.
• Design indexing strategies and optimize database performance for reporting and application workloads.
• Develop solutions to support historical data retention, daily snapshots, and long-term trend analysis.
• Establish data lineage and governance practices to improve visibility and trust in reporting data.
• Partner with stakeholders to understand reporting and application requirements and translate them into scalable database solutions.
• Design and support the application's data access layer.
• Serve as a secondary resource for the team's R Shiny web application to reduce single points of failure.
• Collaborate with application developers to ensure efficient integration between the application and database.
• Support enhancements to existing web-based analytics solutions and self-service reporting capabilities.
• Contribute to application deployment, monitoring, and support activities as needed.
• Implement development best practices including version control, testing, and documentation.
• Support CI/CD processes and deployment automation where appropriate.
• Participate in application modernization efforts, including containerization and cloud-native deployment practices.
• Help establish scalable engineering processes as the platform continues to grow.

Required Qualifications

• 5-7+ years of experience in Database Engineering, Data Engineering, Backend Engineering, or a similar technical role.
• Strong hands-on experience with PostgreSQL.
• Experience designing:Database schemasTable structures and relationshipsPrimary and foreign key strategiesIndexing and query optimizationRelational data models
• Strong understanding of data architecture and data management best practices.
• Experience supporting applications from a database perspective, including the design of data access layers.
• Strong SQL development skills.
• Experience working with large, evolving datasets and establishing historical tracking strategies.
• Ability to troubleshoot performance issues and optimize database workloads.
• Strong communication skills and ability to work directly with technical and business stakeholders.

Preferred Qualifications

• Experience with R Shiny.
• Experience developing or supporting web applications using technologies such as:ReactJavaScript/TypeScriptOther modern web frameworks
• Experience with CI/CD pipelines and modern software delivery practices.
• Containerization experience (Docker, Kubernetes, etc.).
• Experience designing analytics or reporting platforms.
• Familiarity with portfolio management, project management, or operational reporting data.
• Exposure to AI-assisted development tools and modern software engineering workflows.
• Experience working with API integrations and application data services.

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Everforth Apex Benefits Overview:

In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.