Power BI / Snowflake Developer

Socket.dev; Tallahassee (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

ASSYST in Tallahassee, FL is seeking a Power BI / Snowflake Developer for an onsite role. You will design semantic models, dashboards and reports, and optimize Snowflake data for Power BI consumption.

The ideal candidate has 5+ years in BI, deep SQL, DAX and dimensional modeling experience, and can work closely with data engineers. In-person interviews and local residency are required.

Qualifications

• Bachelor's degree required or equivalent work experience.
• 5+ years of IT experience in business intelligence.
• 3–5 years building enterprise reports and data models with Power BI.

Responsibilities

• Design and develop Power BI dataflows and semantic models using dimensional modeling.
• Create advanced DAX calculations to support enterprise reporting.
• Build high-performance Power BI reports and dashboards that meet business requirements.
• Write and optimize complex SQL queries for Snowflake data retrieval.
• Collaborate with Snowflake data engineers to optimize fact/dimension tables.
• Integrate Power BI with Snowflake and ensure secure access.
• Document data lineage and metadata for maintainability and governance.

Education

Bachelor’s degree in computer science or related field

Tools

Power BI

Snowflake

SQL

DAX

Job description

ASSYST is seeking a Power BI / Snowflake Developer in Tallahassee, Florida (Onsite Role).

The Power BI / Snowflake Developer will develop and optimize Power BI semantic models, dashboards, and analytical reports integrated with Snowflake. Services include creating advanced DAX calculations, writing and tuning complex SQL queries, and ensuring Snowflake datasets are modeled and structured for reliable Power BI consumption. The resource will work with data engineers to support dimensional modeling, maintain metadata and data lineage documentation, and ensure accurate, high-performance reporting.

Please NOTE: The candidate must reside in Tallahassee or the surrounding area and report to the office 5 days a week. In-person interviews are required.

Responsibilities

• Design and develop Power BI dataflows and semantic models using dimensional modeling practices.
• Build advanced DAX measures and analytical logic to support enterprise-grade end-user reporting.
• Create user-friendly, high-performance Power BI reports and dashboards that meet defined business requirements.
• Write and optimize complex SQL queries (CTEs, window functions, analytical queries) to retrieve and prepare Snowflake data for reporting.
• Collaborate with Snowflake data engineering teams to ensure fact/dimension tables are structured and optimized for Power BI consumption.
• Integrate Power BI with Snowflake using appropriate connection modes, ensuring performance, query folding, and data reliability.
• Document data lineage, metadata, and report specifications to support maintainability, governance, and transparency across analytics assets.

Requirements

• Bachelor’s degree in computer science, Information Systems, or other related fields. Or equivalent work experience. Equivalent work experience may substitute for the educational requirement.
• Required minimum of 5 years of IT work experience in business intelligence tools and systems.
• A minimum of 3 to 5 years of hands-on experience developing enterprise-level analytical reports, dashboards, and data models using Microsoft Power BI, including advanced report design, paginated reports, performance tuning, and DAX.
• Advanced SQL query writing includes CTEs, window functions, and analytical queries with optimization.
• Strong understanding of star schema design and fact/dimension modeling.
• Proficient in Snowflake tuning, clustering keys, compute optimization, and cost control.
• Familiarity with Snowflake RBAC, roles, warehouse sizing, and data governance.
• Proficient in building Power BI semantic models with strong DAX and clean dimensional design.
• Experience in integrating Power BI with Snowflake and connection modes.
• Proficiency in Power BI Report Builder, workspace management, and performance optimization.
• Experience with metadata management, data lineage, and documentation.
• Experience embedding Power BI reports into web or internal applications.
• Knowledge of CI/CD for Power BI and version control is a plus.

ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law