Information Consulting Services · 1 hour ago
Senior Data Analytics Engineer
United States
Contract
Remote
Senior Level
$90/hr - $103/hrInformation Consulting Services is hiring a Senior Data Analytics Engineer to bridge the gap between Data Engineering and Analytics. This role involves refactoring legacy datasets into trusted dimensional models and supporting an enterprise migration to Power BI.
ConsultingInformation ServicesInformation TechnologyRecruitingStaffing Agency
Responsibilities
Dimensional Modeling (Core): Design and implement robust fact and dimension tables (star schema) in Snowflake, including conformed dimensions, aligned to reporting grain and usage patterns
Model Refactoring: Assess current-state analytical models and refactor them into clean, reusable, well-documented dbt models with clear metric definitions and assumptions
Analytics Engineering Pipelines: Build and maintain scalable transformation pipelines in Snowflake + dbt (Core/Cloud) using advanced SQL and consistent modeling standards
BI & Semantic Model Alignment: Partner with BI Developers and Analysts to ensure table structures, relationships, and metric logic support Power BI semantic models and dashboard performance
Performance & Cost Optimization: Tune SQL/model design to improve runtime and reduce warehouse spend; optimize transforms for efficient Snowflake compute usage
Data Quality & Testing: Implement data quality checks, validation logic, and dbt tests to ensure trusted datasets and stable downstream reporting
Documentation & Knowledge Transfer: Produce strong documentation (model diagrams, design notes, assumptions, usage guidance) and ensure a smooth handoff to the internal team at contract completion
Delivery Practices: Work independently within scope, contribute in Agile/iterative workflows, and follow modern engineering practices (Git, PRs, code reviews)
Qualification
Required
Advanced SQL expertise for complex transformations, aggregations, and performance tuning
Hands-on experience with Snowflake for analytics workloads (modeling + performance considerations)
Strong dimensional modeling background (facts/dimensions, grain, conformed dimensions; Kimball/Inmon concepts)
Hands-on experience with dbt (Core or Cloud), including testing and documentation
Experience preparing datasets specifically for Power BI, including semantic model alignment and performance-minded table design
Familiarity with modern development workflows: Git, pull requests, code reviews, and collaboration in an Agile environment
Proven ability to refactor legacy analytical models into reusable, governed, analytics-ready structures
Preferred
Apache Airflow (or similar orchestration) experience for scheduling and managing workflows
Python for validation, automation, or data quality utilities
Experience supporting BI migrations (e.g., Qlik, Business Objects, Tableau → Power BI)
Company
Information Consulting Services
Information Consulting Services (ICS) provides IT staffing services to clients across North America.
Founded in 1988
11-50 employees
Funding
Current Stage
Early StageLeadership Team
Bill Ciemny
President and CEO
Company data provided by crunchbase