Analytics Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Icon Global Technologies LLC, is seeking the following. Apply via Dice today! Role: Analytics Engineer Location: REMOTE Type: Full Time Job / Role Summary – The Analytics Engineer acts as a bridge between data engineers and data analysts, with a primary focus on refactoring existing data models and designing analytics‑ready fact and dimension tables to support the migration of reports and dashboards to Power BI. This role is responsible for transforming existing analytical datasets into curated, reusable, and trusted dimensional models that serve as the foundation for enterprise reporting and self‑service analytics. The Analytics Engineer will evaluate current‑state models, recommend appropriate dimensional structures, and implement high‑quality fact and dimension tables in Snowflake using dbt and SQL. The role partners closely with analytics engineers, data analysts, and BI developers to validate model design, metrics, and assumptions, ensuring analytical accuracy and performance. In addition to model development, this role supports data quality, testing, documentation, and performance optimization, with an emphasis on enabling reliable Power BI semantic models and dashboards. The Analytics Engineer works independently within defined scope, contributes to Agile delivery, and ensures effective knowledge transfer at the conclusion of the contract. Skills / Experience • Advanced SQL for analytics engineering, including complex transformations, aggregations, and performance tuning. • Strong dimensional data modeling skills, including design and implementation of fact and dimension tables • Hands-on experience with Snowflake as a Cloud data warehouse for analytics workloads • Experience developing and maintaining analytics models using dbt, including testing and documentation • Proven ability to refactor existing analytical data models to support reporting and dashboard migrations • Experience supporting enterprise BI platforms, preferably Power BI, including semantic model alignment • Strong analytical and problem‑solving skills, with the ability to evaluate trade-offs and recommend optimal modeling approaches • Ability to collaborate effectively with analytics engineers, data analysts, and BI developers to validate models and metrics • Strong written and verbal communication skills to explain modeling decisions, assumptions, and results. Preferred / Nice‑to‑Have Skills • Experience working with data sourced from EMR systems (ex. Epic) • Experience with Apache Airflow or similar workflow orchestration tools for scheduling and managing analytics pipelines • Experience using Python for data transformation, validation, automation, or analytics workflows • Experience with version control and modern analytics development practices (e.g., Git, pull requests, code reviews) • Experience supporting BI platform migrations (e.g., Qlik, Business Objects, or similar to Power BI) • Familiarity with Agile or iterative delivery practices