Jobs at Red Pico Consulting Services Inc.

Analyze identity, access governance, and authentication data to identify trends, anomalies, control gaps, and reporting issues. Build dashboards, reconcile data from IAM platforms, support IAM operations, and provide recommendations that strengthen access governance, audit readiness, and reporting accuracy. Collaborate with Identity Management, Cybersecurity, Technology, Risk, Internal Audit, and business stakeholders.

Lead data and business intelligence initiatives by translating business needs into scalable data solutions, standardized KPIs, reporting logic, and analytical use cases. Partner with stakeholders, engineers, architects, and BI teams across data integration, transformation, modeling, governance, and reporting. Validate data, investigate discrepancies, improve data quality, and provide technical leadership for cross-functional data initiatives.

Own backend architecture and develop APIs, scripts, and system integrations for AWS-based self-service and access visibility solutions. Translate business requirements into secure, scalable applications; define technical standards; support testing, troubleshooting, deployment, and ongoing improvements. Collaborate with technical and business stakeholders, manage technical risks and dependencies, document architectures and integrations, and provide technical guidance and mentorship.

Operate and support enterprise BI platforms, primarily Tableau Server and Amazon QuickSight, along with related AWS services and infrastructure. Responsibilities include platform administration, monitoring, incident investigation, access and permissions management, upgrades, troubleshooting data integrations and APIs, root-cause analysis, automation, runbook development, and continuous operational improvement.

Build frontend-focused full-stack web applications using React and TypeScript for analytics, AI insights, dashboards, and decision support. Responsibilities include creating reusable UI components, improving accessibility and performance, implementing authentication, integrating APIs and AI services, developing lightweight backend services, and supporting deployment, testing, reliability, documentation, and user feedback. The role collaborates with product, UX, data, and platform teams in a hybrid Mississauga environment.

Develop and maintain SQL, SAS, and Python integrations for campaign data processes. Prepare mapping documentation and data lineage, convert legacy stored procedures to SQL, write SAS data step, macro, and PROC SQL code, and perform light business analysis independently.

Lead the migration of analytics workloads from SAS to Python while remaining hands-on with coding. Provide technical leadership, establish coding standards, conduct code reviews, migrate workloads, write and debug Python and SQL, create unit tests, and schedule jobs on Linux/Unix using CRON. Work with Git/GitHub, SAS Enterprise Guide, and JupyterHub, and own delivery from design through completion.

Migrate SAS analytics workloads to Python, write and test SQL and Python code, create unit tests, debug applications, schedule Linux/Unix jobs with CRON, and manage code through Git/GitHub. Use SAS Enterprise Guide and JupyterHub while supporting a BMO US Analytics contract.

Designs and implements scalable GCP data platforms, pipelines, integrations, and event-driven cloud architectures. The role uses BigQuery, Dataflow, Cloud Run, Cloud Functions, Pub/Sub, Terraform, and Azure DevOps while ensuring security, governance, reliability, and performance. Responsibilities include stakeholder collaboration, architecture documentation, cloud migration, troubleshooting, and continuous improvement.

Designs and leads secure AWS architectures for migrating critical banking systems from on-premises data centers. Responsibilities include legacy dependency mapping, migration strategy, landing zones, hybrid connectivity, infrastructure as code, security controls, regulatory compliance, disaster recovery, cost governance, audit evidence, and cloud modernization. The role partners with risk, compliance, security, architecture, application, and engineering teams while providing technical guidance and supporting regulatory examinations.

Lead the architecture and implementation of a Microsoft Fabric data platform, including migration from Azure Synapse, secure networking, near-real-time ingestion, data protection, and Medallion architecture. Design ingestion from Oracle and SQL Server systems, guide capacity and cost strategy, validate GCC High capabilities, mentor data engineers, review technical work, resolve complex challenges, and communicate architecture decisions to client stakeholders.