Snowflake dbt PowerBI Analyst
Downers Grove, IL - USA
Job Summary
We are seeking a highly motivatedSnowflake/dbt/Power BI Analystto 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 acrossSnowflake 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 includingSnowflake Cortex Claude and OpenAI Codex to accelerate development optimize code troubleshoot data challenges and improve productivity. This is afull-time onsite positionbased at our corporate headquarters inDowners Grove Illinois.
Qualifications
- Snowflake
- 4 years of hands-on experience in data engineering analytics engineering business intelligence or a related field.
- Expert-level experience withSnowflake 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 withdbtfor enterprise data transformation and modeling.
- Strong knowledge ofStar 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 developingPower BI dashboards semantic models and KPI reporting.
- Strong proficiency with complexDAXand advanced filter-context calculations.
- Experience developing executive dashboards and paginated reports.
- Knowledge of Power BI workspace administration Premium capacities deployment pipelines refresh management andRow-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 withREST and GraphQL APIsand 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 withStreamlitfor 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 managingFivetranconnectors 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 drivers 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:
$80000 - $120000
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.
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 todays 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 wed like to have you join our team. Learn more at
As part of Sentinels 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 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 .
The Know Your Rights Poster is available here
EEO Policy Statement is available here.
IC
About Company
Sentinel Technologies proudly presents Fortis: a comprehensive portfolio of security services and solutions designed to proactively protect every aspect of your digital and physical environment. Our goal is to ensure your organization has the most effective tools to defend its systems ... View more