Snowflake / dbt / PowerBI Analyst

Responsibilities

We are seeking a highly motivated Snowflake/dbt/Power BI Analyst to join our growing Data & Analytics team. This is a hands-on role for a technically strong professional who enjoys solving complex data challenges, building scalable data solutions, and turning enterprise data into actionable business insights. The ideal candidate will have strong experience across Snowflake, dbt, Power BI, Python, data modeling, and enterprise data integration. You will be responsible for developing reliable data pipelines, creating enterprise semantic models, automating reporting processes, and delivering executive-level dashboards and KPI reporting. You will also have the opportunity to leverage modern AI-powered development tools, including Snowflake Cortex, Claude, and OpenAI Codex, to accelerate development, optimize code, troubleshoot data challenges, and improve productivity. This is a full-time, onsite position based at our corporate headquarters in Downers Grove, Illinois.

Qualifications

Qualifications

• Snowflake

• 4+ years of hands-on experience in data engineering, analytics engineering, business intelligence, or a related field.

• Expert-level experience with Snowflake and advanced SQL optimization.

• Extensive experience ingesting structured, semi-structured, and unstructured data from multiple enterprise sources.

• Strong understanding of Snowflake security, governance, performance optimization, and data-sharing capabilities.

• Experience with Streams, Tasks, Snowpipe, and Zero-Copy Cloning.

• dbt & Data Modeling

• Expert-level experience with dbt for enterprise data transformation and modeling.

• Strong knowledge of Star Schema and Kimball dimensional modeling.

• Experience with incremental models, snapshots/SCDs, Jinja macros, packages, and seeds.

• Experience implementing data tests, source freshness monitoring, documentation, and data quality frameworks.

• Strong Git experience, including branching, pull requests, code reviews, and CI/CD workflows.

• Power BI & Analytics

• Advanced experience developing Power BI dashboards, semantic models, and KPI reporting.

• Strong proficiency with complex DAX and advanced filter-context calculations.

• Experience developing executive dashboards and paginated reports.

• Knowledge of Power BI workspace administration, Premium capacities, deployment pipelines, refresh management, and Row-Level Security (RLS).

• Experience troubleshooting and optimizing Power BI performance using Performance Analyzer, DAX Studio, and/or Tabular Editor.

• Python & Automation

• Advanced Python skills for ETL, data manipulation, automation, and integration.

• Experience integrating with REST and GraphQL APIs and loading data into cloud storage such as Azure Blob Storage or AWS S3.

• Ability to build fault-tolerant solutions handling API pagination, rate limits, errors, and retries.

• Experience with Streamlit for internal applications and data tools.

• Experience automating report generation and distribution using HTML/PDF, SMTP, SendGrid, AWS SES, or similar technologies.

• Preferred Qualifications

• Experience configuring and managing Fivetran connectors for automated data replication into Snowflake.

• Experience with large-scale batch and streaming data ingestion.

• Experience working with ERP, CRM, billing, financial, operational, and other core business applications.

• Experience using generative AI tools to develop, optimize, and troubleshoot data and analytics solutions.

• Professional Requirements

• Highly self-driven with the ability to work independently while maintaining strong collaboration with the team.

• Excellent analytical, problem-solving, communication, and organizational skills.

• Ability to take ownership of projects from requirements through implementation and delivery.

• The candidate must have a car, as this position requires travel between location and the transportation of equipment

• A valid driver's license and proof of vehicle insurance will be required

• Legally authorized to work in the US without sponsorship

• Must demonstrate a "can-do" attitude

We focus on candidates that display our "ACE" factor - Attitude, Compassion, and Enthusiasm to deliver quality solutions with exceptional customer service.

Compensation:

$80,000 - $120,000

What you get:

We offer an energetic work environment with many corporate culture amenities, competitive salary, and rich benefit plan including: Medical, Dental, Vision, 401K, 529, Life Insurance, Income Protection Short and Long-Term Disability, Medical and Child/Elder Care, Flexible Spending Account Plans, Family Planning Benefits, Financial Education, Identity Theft Protection and Assistance, Legal Services, Employee Assistance Program, Two weeks' vacation, additional paid time-off for Personal and Sick, certification and hands-on training, and employee discount for product services and entertainment.

Overview

MOTIVATED…..make IT happen!

Sentinel Technologies, Inc. has been rated a top workplace every year since 2012!

About Us:

Sentinel delivers solutions that can efficiently address a range of IT needs - from security, to communications, to systems & networks, to software applications, to cloud and managed services; all of which include our staffing solutions for our clients. Since 1982, Sentinel has grown from providing technology maintenance services to our current standing as one of the leading IT services and solutions provider in the US. We have aligned with many of today's global technology leaders including Cisco, Dell, VMware and Microsoft. Sentinel services customers both nationally and internationally with primary support operating centers in Downers Grove (HQ), Chicago, and Springfield, IL; Phoenix, AZ.; Lansing, and Grand Rapids, MI; Milwaukee, WI; and Denver, CO.

If you are MOTIVATED… you can make IT happen at Sentinel. Our commitment to our employees is to create a work environment that encourages creativity, an entrepreneurial spirit, fosters growth through certification and hands-on training, and values a team-oriented culture with rewards based on impact!

If you share our passion about what technology can do and want to be part of a top workplace environment - we'd like to have you join our team. Learn more at www.sentinel.com/careers.

As part of Sentinel''s employment process, candidates will be required to complete a background check. Only those who meet the minimum requirements will be contacted. No phone calls please.

Sentinel is proud to be an equal opportunity employer including disability and veterans. In accordance with Title VII and state regulations, all qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, marital status, pregnancy, genetics, disability, military, veteran status or any other basis protected by law.

If you are an individual with a disability and need assistance in applying for a position, please contact SentinelHR1@sentinel.com.

The "Know Your Rights" Poster is available here

https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

Sentinel EEO Policy Statement is available here.

https://www.sentinel.com/about/diversity

JFNDNP