Data Analyst

TEKFORTUNE INC; United States; Remote; CAD 70,000 - 100,000; Full time

Job summary

TEKFORTUNE INC is seeking a skilled Data Analyst to support data analysis, transformation, and reporting initiatives. The role emphasizes SQL, Snowflake, Databricks, and dbt to deliver reliable data models and actionable insights.

Ideal candidates will collaborate with data engineers, analysts, and stakeholders to ensure data quality, governance, and effective decision support in a fully remote setting.

Qualifications

• Proven experience as a Data Analyst or in a data-focused role.
• Strong SQL skills with complex queries, joins, aggregations, CTEs, and window functions.
• Experience with Snowflake, Databricks, and dbt for data transformation and warehousing.
• Knowledge of data modeling, ETL/ELT processes, and data quality management.

Responsibilities

• Analyze large datasets to identify trends and provide actionable insights.
• Write and optimize SQL queries for extraction, transformation, and validation.
• Query and manage data in Snowflake; use Databricks for data exploration and processing.
• Develop and maintain data transformation models with dbt.
• Profile data quality and perform profiling, cleansing, reconciliation, and quality checks.
• Support dashboard development, reporting, and KPI tracking with stakeholders.
• Document data definitions, transformation logic, and business rules.

Skills

SQL

Snowflake

Databricks

dbt

Data modeling

ETL/ELT

Analytical thinking

Communication

Tools

Power BI

Tableau

Git

Job description

Work Model: 100% Remote

Key Skills: SQL, Snowflake, Databricks, dbt

Aviation industry preferred

Job Summary

We are seeking a skilled Data Analyst with strong experience in SQL, Snowflake, Databricks, and dbt to support data analysis, transformation, and reporting initiatives. The ideal candidate will be responsible for analyzing complex datasets, developing reliable data models, validating data quality, and delivering actionable insights to support business decision-making.

The candidate should have a solid understanding of modern cloud data platforms and data transformation practices, with the ability to collaborate with business stakeholders, data engineers, and analytics teams.

Key Responsibilities

• Analyze large and complex datasets to identify trends, patterns, and actionable business insights.
• Write, optimize, and maintain complex SQL queries for data extraction, transformation, validation, and analysis.
• Work with Snowflake to query, analyze, and manage data within a cloud-based data warehouse.
• Use Databricks to explore datasets, perform data analysis, and support data processing workflows.
• Develop and maintain data transformation models using dbt (data build tool).
• Perform data profiling, cleansing, reconciliation, and quality checks to ensure data accuracy and consistency.
• Build and maintain analytical datasets and reusable data models to support reporting and business intelligence.
• Collaborate with data engineers, business analysts, and stakeholders to gather requirements and translate business needs into analytical solutions.
• Investigate data discrepancies, troubleshoot data issues, and perform root cause analysis.
• Document data definitions, transformation logic, business rules, and analytical findings.
• Support dashboard development, reporting, and KPI tracking as required.
• Follow established data governance, security, and documentation standards.

Required Skills and Qualifications

• Proven experience as a Data Analyst or in a similar data-focused role.
• Strong hands‑on proficiency in SQL, including complex queries, joins, aggregations, CTEs, and window functions.
• Experience working with Snowflake for data querying, warehousing, and analysis.
• Hands‑on experience with Databricks for data exploration and processing.
• Experience developing, testing, and maintaining data transformations using dbt.
• Strong understanding of data modeling, ETL/ELT processes, and data warehousing concepts.
• Experience with data validation, reconciliation, and data quality management.
• Strong analytical, problem‑solving, and communication skills.
• Ability to work independently in a remote environment and collaborate with distributed teams.

Preferred Qualifications

• Experience with cloud‑based data platforms and modern data stack architectures.
• Familiarity with Git, version control, and collaborative development workflows.
• Knowledge of BI and visualization tools such as Power BI or Tableau.
• Understanding of data governance, metadata management, and data lineage.
• Experience working in Agile delivery environments.

Ideal Candidate Profile

The ideal candidate combines strong SQL and analytical skills with hands‑on experience in Snowflake, Databricks, and dbt. They should be comfortable working across data extraction, transformation, modeling, and validation to deliver accurate, high‑quality datasets and meaningful business insights.