Business Intelligence Specialist
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Must Haves:
- Oracle, Python, AWS Glue Python Shell, and AWS DMS experience, including complex SQL, source-data analysis, extraction, transformation, incremental loading, validation, reconciliation, and production support.
- Amazon Redshift and dimensional-modelling experience, including staging layers, fact and dimension structures, star schemas, views or materialized views, SQL optimization, and reporting-layer performance tuning.
- Power BI development experience, including semantic modelling, DAX, Power Query, dashboards, operational metrics, data-quality reporting, refresh processes, security, and performance optimization.
- Healthcare-data experience involving the Ontario HRM Standard, FHIR data structures, and HL7 v2 data structures, including mapping source data to consistent analytical definitions and metrics.
More about this job
Responsibilities
Develop and support data pipelines using Oracle, Python, AWS Glue Python Shell, and AWS DMS, including extraction, transformation, incremental loading, validation, reconciliation, and production support. Build and optimize Redshift dimensional models and Power BI reporting solutions, and map healthcare data structures to consistent analytical definitions and metrics.
Requirements
Experience with Oracle, Python, AWS Glue Python Shell, AWS DMS, complex SQL, and end-to-end data integration and production support is required. Candidates must also have experience with Amazon Redshift dimensional modeling, Power BI development, and healthcare data involving the Ontario HRM Standard, FHIR, and HL7 v2.
Skills
- Oracle
- Python
- AWS Glue Python Shell
- AWS DMS
- Complex SQL
- Source-Data Analysis
- Data Extraction and Transformation
- Incremental Loading
- Data Validation and Reconciliation
- Amazon Redshift
- Dimensional Modeling
- Power BI
- DAX
- Power Query
- Healthcare Data
- FHIR
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Healthcare
Keywords
- Oracle
- Python
- AWS Glue Python Shell
- AWS DMS
- Complex SQL
- Source-Data Analysis
- Data Extraction
- Data Transformation
- Incremental Loading
- Data Validation
- Data Reconciliation
- Production Support
- Amazon Redshift
- Dimensional Modeling
- Staging Layers
- Fact Tables
- Dimension Tables
- Star Schemas
- Materialized Views
- SQL Optimization
- Power BI
- Semantic Modeling
- DAX
- Power Query
- Dashboards
- Operational Metrics
- Data Quality Reporting
- Ontario HRM Standard
- FHIR
- HL7 v2