RQ00734 - Business Intelligence Specialist - Senior
Tasks
- Build Amazon Redshift data warehouse
- Collaborate with stakeholders to gather reporting requirements
- Create deployment pipelines documentation and operational procedures
- Create star schemas fact tables dimension tables semantic models
- Design develop maintain Power BI dashboards
- Develop AI assisted Power BI dashboards
- Develop AWS Glue ETL pipelines with Python
- Develop operational KPIs healthcare utilization and provider activity reporting
- Implement ETL ELT for data ingestion transformation validation and load
- Implement secure data access with IAM OAuth2 OIDC role based security
- Ingest healthcare data using FHIR HL7 v2 AWS HealthLake Smile CDR
- Integrate data from REST APIs databases and cloud platforms
- Optimize Redshift performance partitioning indexing and query execution
- Support production troubleshooting and report optimization
- Validate cleanse reconcile and govern data quality
Perks/Benefits
- N/A
Skills/Tech-stack
AWS CloudWatch | AWS Glue | AWS HealthLake | AWS S3 | Access Control | Amazon Athena | Amazon Redshift | Anomaly Detection | BI Copilot | Data Governance | Data Quality | Data Reconciliation | Dimensional Modeling | ELT | ETL | FHIR | FHIR R4 | FHIR R4B | Forecasting | HL7 v2 | Healthcare Interoperability | IAM | Natural Language | OAuth2 | OIDC | Pexip API | Power BI | Power BI Copilot | Python | REST API | Role-Based Access | Role-Based Access Control | SMART on FHIR | SQL | Semantic models | Smile CDR | Star Schema | Zoom API
Education
N/A
Related jobs
-
Mid-level ContractMontréal, Canada4h ago
-
Analyst, Data Science & AI developper CAD 74K-104KAI Foundry | Agile | App Service | Azure | Azure AIDental insurance | Disability insurance | Employee assistance program | Flexible/hybrid work policies | Health insuranceMid-level Full TimeDorval, Québec, CA, H4S 1Y912h ago
-
Analyst, Data Science & AI CAD 71K-106KAzure | Backtesting | Calibration | Cross-validation | Data GovernanceEmployee assistance program | Flexible and hybrid work policies | Insurance plans | Retirement savings plan | Tele Health ProgramMid-level Full TimeDorval, Québec, CA, H4S 1Y912h ago
-
A/B | A/B Testing | Advertising analytics | Airflow | B testingEquity grants | Flexible remote work | Professional developmentSenior-level Full TimeCanada13h ago
-
Apache Airflow | Apache Flink | Backend Development | Compliance | Data GovernanceAnnual equity refresh opportunities | Collaborative innovation focused environment | Flexible remote work | Health and well-being benefits | New hire equity grantsMid-level Full TimeCanada13h ago
-
Senior Data Engineer (Snowflake) CAD 140K-179KApache Airflow | BigQuery | Compliance | DBT | DagsterExtended health and dental plan | Flexible PTO | Flexible work arrangements | Mentorship | Training budgetSenior-level Full TimeToronto17h ago
-
Senior AI/LLM Engineer USD 179K-201KAPI Development | CI/CD | Embeddings | Fine Tuning | Guardrails401k match | Dental insurance | Health insurance | Remote work | Vision insuranceSenior-level Full TimeRemote (US/Canada) R19h ago
-
Senior Analytics Specialist CAD 84K-126KAzure | Data Modeling | Data Visualization | Decision support | ExcelCorporate discounts | Flexible work environment | Healthcare of Ontario Pension Plan HOOPP | Opportunities for development and promotions | Transit accessSenior-level Full TimeToronto, Canada22h ago
-
AWS | CI/CD | Code review | Data Transformation | DatabricksAnnual training bonus | Flexible schedule | Flexible time off | Free telemedicine | Hybrid workSenior-level Full TimeMontréal, Quebec, Canada; Québec, Quebec, Canada23h ago
-
Data and Artificial Intelligence Fall Student CAD 52K-52KBusiness Intelligence | Data Engineering | Data Visualization | Generative AI | Machine LearningAccess to data and technology tools | Collaborative inclusive environment | Hybrid work arrangements | Remote work flexibility | Travel for office workNone Full TimeSt Catharines, Ontario, Canada; Etobicoke, Ontario, … R23h ago
-
Embedded Systems Test Engineer CAD 95K-130KARM Cortex | Ansible | Buildah | C# | C++Flexible work hours | Health benefits | Personal education funds | Profit sharing | RRSP matchingSenior-level Full TimeWaterloo, Ontario, Canada23h ago
-
AI Engineer Sr CAD 110K-172KAI Observability | API | AWS | Agent systems | Amazon Web ServicesComprehensive wellness initiatives | Recognition programs | Time away from work programs | Volunteer daysMid-level Full TimeCanada1d ago
-
AI Engineer Sr CAD 110K-172KAI Agents | AI Observability | AI orchestration | APIs | AWSCharity support | Recognition programs | Time off | Volunteer days | Wellness programsMid-level Full TimeCanada1d ago
-
AWS | Alteryx | Amazon Redshift | Azure Synapse | Azure Synapse AnalyticsContinuous learning opportunities | Fully remote work | Professional growthSenior-level Full TimeCanada R1d ago
-
Apache Hadoop | Apache Kafka | Apache Spark | Batch Processing | Cloud DataFully remote | International team collaboration | Training and professional developmentSenior-level Full TimeCanada R1d ago
-
Agile | Data Migration | Data Quality | Data Validation | Data pipelineCompany events | Dental insurance | Flexible working hours | Health insurance | Life insuranceMid-level Full TimeCanada1d ago
-
API Development | Agent Builder | Automated testing | BigQuery | CI/CDCareer growth | Diversity, Equity, and Inclusion Initiatives | Flexible vacation policies | Flexible working arrangements | Health and wellness benefitsSenior-level Full TimeCanada R1d ago
-
Senior ASIC Package Design Automation and AI Engineer CAD 145K-194K2.5D IC | 3D-IC | Artificial Intelligence | C++ | CadenceSenior-level Full TimeMARKHAM, ON, Canada1d ago
-
Data Engineer III CAD 125K-154KCI/CD | Code Management | Coding practices | Cycle management | Data GovernanceBanking benefits and discounts | Career development and training | Health and well-being benefits | Paid time off | Savings and retirement programsSenior-level Full TimeTD Centre - South - 79 …1d ago
-
System Planning & Optimization Specialist CAD 95K-130KData Visualization | Economic Modeling | Forecasting | Hydraulic modeling | Operations ResearchCompressed work week option | Flexible benefits | Flexible work hours | Hybrid work option | Paid Maternity LeaveSenior-level Full TimeCalgary, Canada1d ago
-
Associate Manager Business Analytics USD 75K-125KDashboard Development | Data Modeling | Databricks | Excel | Power BICareer advancement | Education reimbursement | Employee discounts | Employee recognition | Health and dental benefitsMid-level Full TimeLondon, ON, CA1d ago
-
Machine Learning Engineer CAD 128K-192KAWS | Cloud Computing | Data Wrangling | Deep learning | DockerFlexible work schedule | Health and wellness benefits | Professional development supportMid-level Full TimeCanada, BC, Vancouver1d ago
-
Adobe Analytics | Alteryx | Cloud Intelligence | Data Visualization | DatoramaEmployee and family assistance programs | Hybrid work environment | Social recognition program | Wellbeing support | Work flexibilityMid-level Full TimeToronto-81 Bay, 32nd Floor, Canada1d ago
-
AI Engineer CAD 90K-140KA/B | A/B Testing | AWS Athena | AWS Bedrock | AWS LambdaCare days | Charitable giving program | Collaborative team environment | Flexible work arrangement | Hybrid work flexibilitySenior-level Full TimeSun Life Toronto One York, Canada1d ago
-
Senior Data Engineer I CAD 80K-128KAWS Lambda | AWS S3 | AWS Step Functions | Bitbucket | Data GovernanceCode review support | Flexible work options | Hybrid work modelSenior-level Full TimeSun Life Toronto One York, Canada1d ago