Data Warehouse & Business Intelligence Specialist

Matrix-EE; Snowflake (AZ); Remote; USD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a Data Warehouse & Business Intelligence Specialist to join a dynamic team. This role involves designing and maintaining data warehouse solutions, optimizing ETL processes, and developing insightful dashboards and reports. You will collaborate with stakeholders to ensure data quality and drive informed decision-making. The company offers a flexible remote work environment, additional paid leave, and opportunities for professional development. If you are passionate about data and eager to contribute to innovative solutions in aviation training, this position is perfect for you.

Benefits

Remote work

Flexible working hours

Additional 20 days of paid leave

Professional development benefits

Top-quality work environment

Online sports activities

Team buildings

Christmas parties

Qualifications

• 3+ years in data warehousing and BI roles with strong SQL skills.
• Experience with ETL/ELT processes and BI tools.

Responsibilities

• Design and maintain data warehouse solutions using SQL Server and Redshift.
• Develop dashboards and reports, ensuring data quality and accuracy.

Skills

SQL

Data Warehousing

Business Intelligence

ETL/ELT Processes

Data Modeling

Communication Skills

Time Management

Tools

SQL Server

Amazon Redshift

Reporting Services

Amazon QuickSight

Snowflake

Power BI

Tableau

Looker

AWS

Azure

Job description

Data Warehouse & Business Intelligence Specialist

About the job

Matrix Eastern Europe, the offshore division of Matrix IT, one of the leading global R&D services companies with more than 10,000 professionals, is looking for a Data Warehouse & Business Intelligence Specialist to join the team of our client and partner – Qualtero.

At Qualtero, they are transforming the future of aviation training. Now part of Comply365, they’re expanding fast, building AI-powered solutions that help global industries streamline training, boost compliance, and enhance operational performance.

Job overview:

The ideal candidate is highly skilled in both on-premises and cloud-based data warehouse solutions, with strong SQL expertise and a passion for transforming complex data into meaningful visualizations and reports. You thrive on designing efficient, scalable data architectures and enabling stakeholders to make informed, data-driven decisions. If you’re excited by the opportunity to work with cutting-edge analytics and contribute to a mission-critical industry, we’d love to have you on our team.

Responsibilities

• Design, develop, and maintain data warehouse solutions using SQL Server, Amazon Redshift, and other database technologies
• Create and optimize ETL/ELT processes to integrate data from multiple sources
• Develop and maintain dashboards and reports using Reporting Services, QuickSight, and other BI tools
• Collaborate with business stakeholders to understand reporting requirements and translate them into technical solutions
• Ensure data quality, accuracy, and consistency across all data platforms
• Implement and maintain data models optimized for analytical workloads
• Document data warehouse architecture, data flows, and reporting solutions
• Stay current with industry trends and best practices in data warehousing and business intelligence

Requirements

• 3+ years of experience in data warehousing and business intelligence roles
• Strong proficiency with SQL Server and Amazon Redshift
• Experience building dashboards and reports using Reporting Services and Amazon QuickSight
• Solid understanding of data modeling techniques for analytical systems (star schema, snowflake, etc.)
• Proficiency in SQL query writing, optimization, and performance tuning
• Experience with ETL/ELT processes and tools
• Fluent English communication skills (written and verbal)
• Proven ability to work effectively in team environments
• Self-motivated with excellent time management skills for remote/hybrid work

Advantages

• Experience with additional database platforms (Snowflake, BigQuery, Azure Synapse, etc.)
• Knowledge of additional BI visualization tools (Power BI, Tableau, Looker, etc.)
• Understanding of data governance principles and practices
• Experience with cloud data platforms (AWS, Azure, GCP)
• Knowledge of Python, R, or other programming languages for data manipulation
• Experience with agile development methodologies

What we can offer

• Remote work and flexible working hours
• Additional 20 days of paid leave
• Professional and career development benefits
• Top-quality work environment
• Online sports activities
• Team buildings and Christmas parties