What are the responsibilities and job description for the Senior Data Analytics Engineer position at Information Consulting Services?
Rate: $90.00 – $103.00 / hour (commensurate with experience)
Location: Remote
Duration: One Year
We’re hiring a Senior Data Analytics Engineer to serve as the critical bridge between Data Engineering and Analytics, owning the refactor of legacy analytical datasets into curated, trusted, and reusable dimensional models in Snowflake. This role is central to an enterprise migration to Power BI—designing analytics-ready fact/dimension structures that become the foundation for semantic models, executive reporting, and self-service analytics.
You won’t just move data—you’ll define grain, align metrics, and build high-performance star schemas that scale cleanly, document well, and perform efficiently in Snowflake and Power BI.
What You’ll Do
Location: Remote
Duration: One Year
We’re hiring a Senior Data Analytics Engineer to serve as the critical bridge between Data Engineering and Analytics, owning the refactor of legacy analytical datasets into curated, trusted, and reusable dimensional models in Snowflake. This role is central to an enterprise migration to Power BI—designing analytics-ready fact/dimension structures that become the foundation for semantic models, executive reporting, and self-service analytics.
You won’t just move data—you’ll define grain, align metrics, and build high-performance star schemas that scale cleanly, document well, and perform efficiently in Snowflake and Power BI.
What You’ll Do
- 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).
- 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.
- 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).
Salary : $90 - $103