Business Systems Analyst
- Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Posting language
- English
- Posted
Original job description
Role Descriptions:
Design and develop scalable ETL/ELT processes using PL/SQL and modern tools.
Optimize data loading and transformation processes for efficiency.
Collaborate with stakeholders to understand data needs and implement data warehouse models.
Develop and maintain reports and dashboards using Tableau.
Provide technical guidance and mentorship to junior team members.
Essential Skills:
Experience with Apache Airflow for workflow orchestration is beneficial for managing ETL processes.
Knowledge of PySpark for big data processing is a plus.
Familiarity with data quality checks and monitoring mechanisms is advantageous. Understanding of dimensional modeling techniques is helpful.
Ability to communicate complex technical concepts to non-technical stakeholders is desirable.
Strong expertise in SQL and PL/SQL is essential for data manipulation and ETL processes. Proficiency in AWS services is critical for cloud-based data solutions.
Experience with data warehousing and modeling is necessary to meet business requirements.
Familiarity with Tableau for reporting and analytics is required. Technical leadership and mentorship capabilities are also important for guiding junior team members.
More about this job
Responsibilities
Design, develop, and optimize scalable ETL/ELT processes and data warehouse models using SQL, PL/SQL, and cloud technologies. Build and maintain Tableau reports and dashboards, collaborate with stakeholders on data needs, and provide technical guidance to junior team members.
Requirements
Requires strong SQL and PL/SQL expertise, proficiency in AWS, experience with data warehousing and modeling, and familiarity with Tableau. Airflow, PySpark, data quality monitoring, dimensional modeling, stakeholder communication, and mentoring skills are beneficial or desirable.
Skills
- SQL
- PL/SQL
- AWS
- ETL/ELT
- Data Warehousing
- Data Modeling
- Tableau
- Apache Airflow
- PySpark
- Data Quality Monitoring
- Dimensional Modeling
- Stakeholder Communication
- Technical Leadership
- Mentorship
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Management & Leadership
Keywords
- SQL
- PL/SQL
- AWS
- ETL/ELT
- Data Loading
- Data Transformation
- Data Warehousing
- Data Warehouse Models
- Tableau
- Apache Airflow
- PySpark
- Big Data Processing
- Data Quality Checks
- Data Monitoring
- Dimensional Modeling
- Workflow Orchestration
- Reporting
- Analytics
- Stakeholder Collaboration
- Technical Leadership
- Mentorship