RQ08428 - Database Administrator - Intermediate
Tasks
- Assess data analytics and reporting capabilities
- Build and validate data models
- Clean transform and join data
- Create automated data validation tools
- Create data dictionaries
- Design data architecture for databases
- Design data capture structure transform and process methods
- Develop and maintain database connections
- Develop data extraction transformation and load pipelines
- Develop documentation for data standards and requirements
- Develop mapping and transformation rules between databases
- Enforce database rules and monitoring
- Gather requirements and identify improvement opportunities
- Lead analytics initiatives and reporting
- Support Power BI report building and visualization
Perks/Benefits
- N/A
Skills/Tech-stack
CI/CD | Data Architecture | Data Dictionary | Data Modeling | Data Quality | Data Standards | Data Warehousing | Dimensional Modeling | ETL | Microsoft Access | Microsoft Excel | Power BI | SQL | VBA
Education
N/A
Related jobs
-
AODA | Agile | CI/CD | Cognos | Data GovernanceContinuous improvement activities | Knowledge transfer support | Public sector domain experienceMid-level ContractQueen's Park Ontario Provincial Government, Canada16h ago
-
BI Developer (Tableau) CAD 80K-140KCloud Platforms | Data Modeling | Data integration | Relational databases | SQLCross-functional collaboration | Knowledge transfer | User trainingMid-level ContractMarkham, Canada16h ago
-
Sr. Data Analyst CAD 58K-96KBusiness Analysis | Conditional Formatting | Data Analysis | Data Modeling | Data ValidationFlexible work arrangements | Hybrid work arrangement | Learning & Development Days | Mental health support benefits | MentoringSenior-level Full TimeToronto, ON, CA, M5C 3G71d ago
-
Alteryx | Dashboard Development | Data Analysis | Data Modeling | Data VisualizationDefined benefit pension plan | Employee share purchase plan | Hybrid work arrangement | Paid time off for growth and development | Vacation offeringSenior-level Full TimeToronto-81 Bay, 27th Floor, Canada1d ago
-
Analyste Data/Data Analyst CAD 65K-109KMicrosoft Access | Microsoft Excel | Relational databases | SQL | Statistical MethodsMid-level Full TimeQuebec, Canada1d ago
-
Alation | Business Process | Business Process Analysis | Business Rules | Change ManagementSenior-level Full TimeSaint-Laurent, QC, CAN - 4705 Dobrin …1d ago
-
Data Analyst, Engagement & Retention CAD 100K-136KA/B | A/B Testing | B testing | Churn analysis | DashboardingBonus program | Flexible work hours | Medical, dental, and vision coverage | Paid parental leave | Paid time offMid-level Full TimeCanada R1d ago
-
Senior Analyst/Associate, Performance & Analytics CAD 90K-134KBenchmarking | Excel | Excel VBA | GIPS | Money-weighted returnDefined benefit pension plan | Flexible remote work 1 day per week | Health and dental benefits | Paid time offSenior-level Full TimeCA Victoria, Canada R1d ago
-
Adobe Analytics | Dashboard Development | Data Governance | Data Visualization | ExcelDevelopment opportunities | Hybrid work arrangement | Workplace accommodationsSenior-level Full Time TemporaryMontréal, 2020 Robert-Bourassa, Canada2d ago
-
System and Data Analyst (FTE/Hybrid) CAD 80K-86KAgile | Data Mapping | Data Migration | Data Modeling | Data QualityFTE role | Hybrid workMid-level Full TimeHalifax, NS, CA R2d ago
-
Business Data Analyst CAD 73K-100KData Governance | Data Modeling | Data Quality | Data Visualization | Machine LearningRemote workMid-level Full TimeOntario,Canada Offsite R2d ago
-
AWS | Access Control | Business Objects | Data Governance | Data ModelingHealth benefits | Home office equipment reimbursement | Parental leave top-up | Professional development | Tuition reimbursementSenior-level Full TimeToronto Office, Canada R2d ago
-
Balance sheet | Balance sheet forecasting | Business Process | Business process improvement | Collateral ManagementAccident insurance | Health insurance | Life insurance | Retirement savings plan | Tuition reimbursementMid-level Full TimeFCP, Canada2d ago
-
Senior Data Analyst CAD 80K-128KAWS Athena | AWS Glue | AWS SageMaker | Agile | Azure? N/AHybrid work | Wellness programsSenior-level Full TimeSun Life Toronto One York, Canada2d ago
-
Senior Data Analyst CAD 80K-128KAWS Athena | AWS Glue | AWS SageMaker | Agile | DashboardingCareer development | Hybrid work flexibility | Networking opportunities | Wellness programs | Work-life supportSenior-level Full TimeSun Life Toronto One York, Canada2d ago
-
Consultant, Marketing Analytics CAD 70K-85KAlteryx | Dashboards | Data Analysis | Data Mining | Data reportingEmployee recognition program | Employee share purchase plan | Purpose Day (paid day off) | Vacation offering | Wellbeing supportSenior-level Full TimeToronto-161 Bay St., 4th, Canada2d ago
-
Data Automation | Data Management | Data Quality | Data analytics | ExcelEntry-level Full Time InternshipCA-QC-LONGUEUIL-J01 ~ 1000 Blvd Marie-Victorin ~ …2d ago
-
Excel | Financial Forecasting | Financial Reporting | Journal entries | Power BIFlexible schedule | On-site workEntry-level Full Time InternshipCA-QC-LONGUEUIL-J01 ~ 1000 Blvd Marie-Victorin ~ …2d ago
-
Azure | Data Mapping | Data Migration | Data Modeling | Data PipelinesSenior-level Full TimeToronto, ON, Canada2d ago
-
Junior Data Analyst CAD 58K-95KCampaign analytics | Commerce analytics | Dashboarding | Data Visualization | Data reportingAnnual vacation from day one | Group insurance | Paid days off Christmas period | Retirement savings plan | Sick leaveEntry-level Full TimeLongueuil, Quebec, Canada4d ago
-
Agile methodology | Anomaly Detection | Azure Data | Azure Data Factory | Azure DatabricksMid-level Full TimeToronto, ON4d ago
-
Senior Data Analyst CAD 105K-115KA/B | A/B Testing | Amazon Redshift | B testing | Causal InferenceCulture of learning and development | Flexible working hours | Health and Wellness Benefits Package | Parental leave program | Retirement planningSenior-level Full TimeToronto4d ago
-
Data Analyst CAD 68K-78KAnalytics | Dashboarding | Data Analysis | Data Modeling | Data TransformationComprehensive health benefits | Retirement savings plans | Tuition reimbursement | Wellness programMid-level Full TimeLondon, Ontario, Canada; Toronto, Ontario, Canada4d ago
-
Team Lead, Cost & Analytics CAD 75K-102KAlteryx | Automation | Budget Management | Data Governance | ForecastingIn-office work environmentSenior-level Full TimeDartmouth, NS, Canada4d ago
-
Data Steward CAD 80K-90KBusiness glossary | Compliance | Data Governance | Data Quality | Data Quality ManagementMid-level Full TimeMarkham, Canada4d ago