CareerMoonshot

Snowflake / dbt / PowerBI Analyst

Sentinel Holdings Ltd. · Illinois

📍 Downers Grove, IL💰 $80,000 - $120,000via icimsPosted 2026-07-17
Apply on company site ↗
Career Moonshot pulls this listing straight from the employer's hiring system — no recruiter middleman, no reposts. Applying takes you directly to Sentinel Holdings Ltd..
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 s

More Illinois jobs

Illinois jobs · Browse all locations