Business Systems Analyst

Job summary

Design, develop, and optimize scalable ETL/ELT processes and data warehouse models, and create reports and dashboards using Tableau. Collaborate with stakeholders on data needs and provide technical guidance and mentorship to junior team members.

Job details

Pay Range: CAD 55-60/hr 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.

What you’ll do

Design, develop, and optimize scalable ETL/ELT processes and data warehouse models, and create reports and dashboards using Tableau. Collaborate with stakeholders on data needs and provide technical guidance and mentorship 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. Apache Airflow, PySpark, data quality monitoring, dimensional modeling, and the ability to communicate technical concepts to non-technical stakeholders are beneficial.

Listed skills

• SQL · Preferred
• Amazon Web Services · Preferred
• Tableau · Preferred
• Mentorship · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• PL/SQL
• AWS
• Data Warehousing
• Data Modeling
• ETL/ELT
• Tableau
• Apache Airflow
• PySpark
• Data Quality Monitoring
• Dimensional Modeling
• Technical Leadership
• Mentorship
• Stakeholder Communication

Job areas

• Data & Analytics
• Technology
• Software
• Management & Leadership

More jobs from LanceSoft, Inc.