Data Warehouse Analyst

SMART TECH SKILLS LLC

United States

On-site

USD 90,000 - 130,000

Full time

11 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Competitive salary

Job summary

SMART TECH SKILLS LLC in Tallahassee, FL seeks a Data Warehouse Analyst / Report Developer to design and maintain enterprise BI solutions using Power BI and Snowflake. You will build semantic models, dashboards, and advanced calculations to deliver scalable analytics.

The role emphasizes SQL optimization, dimensional modeling, and collaboration with data engineering to ensure governance and high performance. Senior level requires 5+ years BI/Analytics and strong communication with stakeholders.

Qualifications

Bachelor's Degree in Computer Science, Information Systems, or a related field, or equivalent experience.
5+ years of experience in Business Intelligence and Data Analytics.
3–5+ years hands-on Power BI development.
Strong expertise in: Power BI, DAX, Power Query, Semantic Models, Dataflows, Paginated Reports, Advanced SQL development.
Experience integrating Power BI with Snowflake and data governance alignment.

Responsibilities

Design and develop enterprise Power BI semantic models, dataflows, dashboards, and reports.
Build advanced DAX calculations, measures, KPIs, and analytical logic.
Create dashboards and paginated reports with high performance.
Design dimensional models using star schema and fact/dimension modeling.
Collaborate with data engineers to optimize data structures for reporting.
Ensure reporting solutions align with governance and architecture standards.
Integrate Power BI with Snowflake and optimize end-to-end performance.
Document data lineage, metadata, and semantic models.

Skills

Power BI

DAX

SQL

Snowflake

Dimensional Modeling

Star Schema Design

Data Analytics

Dashboard Development

ETL/SQL Optimization

Education

Bachelor's Degree in Computer Science, Information Systems, or related field

Tools

Snowflake Admin

Power BI Report Builder

Git

Azure DevOps

Data Modeling Tools

Job description

Benefits:

Competitive salary

Location

Onsite: Tallahassee, FL

Experience Level

Senior Level (5+ Years BI & Analytics Experience)

Position Overview

The Data Warehouse Analyst / Report Developer will be responsible for designing, developing, and maintaining enterprise reporting and analytics solutions using Power BI and Snowflake. This role will focus on semantic model development, dashboard creation, advanced DAX calculations, SQL optimization, dimensional modeling, and Snowflake integration to deliver scalable, high-performance business intelligence solutions.

The ideal candidate will possess strong expertise in Power BI, Snowflake, SQL development, and data modeling, with the ability to translate business requirements into intuitive reports and actionable analytics.

Key Responsibilities

Power BI Development & Analytics

Design and develop enterprise Power BI semantic models, dataflows, dashboards, and reports.
Build advanced DAX calculations, measures, KPIs, and analytical logic.
Create visually compelling, user-friendly, and high-performing dashboards.
Develop and maintain paginated reports and enterprise reporting solutions.
Optimize Power BI workspaces, datasets, and report performance.

Data Modeling & Data Warehouse Support

Design dimensional models using star schema and fact/dimension methodologies.
Collaborate with data engineering teams to optimize data structures for reporting.
Support semantic layer development and enterprise reporting standards.
Ensure reporting solutions align with data governance and architecture standards.

Snowflake Development & Optimization

Develop and optimize Snowflake-based reporting solutions.
Perform Snowflake performance tuning, clustering strategy optimization, and compute management.
Support warehouse sizing, workload management, and cost optimization initiatives.
Utilize Snowflake RBAC and security best practices.

SQL Development & Data Analysis

Write complex SQL queries utilizing:
- Common Table Expressions (CTEs)
- Window Functions
- Analytical Queries
- Query Optimization Techniques
Develop datasets and reporting views to support business requirements.
Analyze and troubleshoot data quality and reporting issues.

Integration & Performance Optimization

Integrate Power BI with Snowflake using optimal connectivity methods.
Optimize query folding and end-to-end report performance.
Troubleshoot performance issues across:
- DAX
- SQL Queries
- Semantic Models
- Snowflake Compute Layers
Ensure data reliability, consistency, and scalability.

Documentation & Governance

Document:
- Data Lineage
- Metadata
- Semantic Models
- Report Specifications
- Business Rules
Support governance, transparency, and maintainability of analytics assets.
Maintain technical and user-facing documentation.

Stakeholder Collaboration

Gather and analyze reporting requirements from business stakeholders.
Translate business needs into analytical solutions and executive dashboards.
Present reporting solutions and recommendations to technical and non-technical audiences.
Collaborate effectively with SMEs, developers, architects, and data engineers.

Required Qualifications

Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent experience.
5+ years of experience in Business Intelligence and Data Analytics.
3–5+ years of hands-on Power BI development experience.
Strong expertise in:
- Power BI
- DAX
- Power Query
- Semantic Models
- Dataflows
- Paginated Reports
- Advanced SQL development experience.
Experience with:
- CTEs
- Window Functions
- Analytical Queries
- Query Optimization
Strong understanding of:
- Star Schema Design
- Fact & Dimension Modeling
- Dimensional Data Warehousing
Experience integrating Power BI with Snowflake.
Experience with Snowflake administration and performance tuning.
Experience documenting metadata and data lineage.