
Data and Analytics Engineer
Nimble Gravity1 month ago
Remote, United States or Remote, AmericasSenior
Responsibilities
- Architect performant data models and establish single sources of truth across business domains.
- Build and maintain data infrastructure, pipelines, semantic models, and AI-agent-ready data using SQL, Python, dbt, and Snowflake.
- Perform data QA and create automated testing procedures for Snowflake data models.
- Define governance practices covering permissions, data lineage, data definitions, and data security.
- Build semantic models for Cortex Analyst and validate the metrics, dimensions, and relationships required by AI agents.
- Identify and resolve data structure, naming, and coverage gaps that could cause incorrect agent results.
- Create reusable playbooks, templates, semantic model libraries, semantic view configurations, and YAML/Markdown skill files.
- Document solutions, run technical workshops, and help nontechnical analysts use semantic models in plain English.
- Engage with customers to derive requirements, prototype solutions, gather feedback, track adoption, and ensure production handoff to run teams.
Requirements
- 8+ years of experience in analytics engineering, data engineering, or a related technical role, including some customer-facing or cross-functional experience.
- Advanced SQL proficiency, including complex queries, joins, CTEs, window functions, and incremental pipeline patterns.
- Experience building and maintaining dbt projects with testing, documentation, and CI/CD pipelines.
- Modern, readable, type-hinted Python experience for data pipelines and automation.
- Daily use of an LLM coding assistant such as CoCo, Cursor, GitHub Copilot, Claude, or an equivalent tool.
- Experience designing semantic views or structured skill files that encode domain knowledge and handle edge cases.
- Experience shipping production data models or pipelines relied upon by nontechnical business users.
- Comfort with Git, including pull requests, branches, and code review.
- Demonstrable ability to translate business requirements into technical specifications.
- Experience with Snowflake Cortex Analyst, Cortex Agents, Cortex Search, semantic views, and Dynamic Tables.
- Experience with Airflow or another orchestration framework is a plus.
- Familiarity with enterprise systems such as ERP, CRM, or HRIS is a plus.
About Nimble Gravity
Nimble Gravity is a Denver-based, privately held IT services firm that provides data, AI/ML, and digital engineering consulting to enterprises, with a focus on ecommerce. It implements analytics platforms, machine learning models, and storefront optimizations on Shopify and BigCommerce, and builds custom data integrations and visualizations. The company engages on a services and project basis, covering strategy, implementation, and managed support.