> Markdown version of [/jobs/ext/4167132-senior-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/4167132-senior-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Analytics Engineer - **Company:** Bold Penguin - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $84,900.0 - $139,000.0 - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Artificial Intelligence, Business Analytics Applications, Data Analysis, Apache HTTP Server, JIRA, Continuous Integration, Data Cleansing, Data Transformation, Data Systems, Data Warehousing, Decision Support Systems, Python (Programming Language), Standard Sql, Tableau (Software), Scripting, Enterprise Software Applications, Large Language Models, Snowflake, Prompt Engineering, Generative AI, Git, Information Technology, AWS Glue, Data Analytics, Data Lakehouse, Claude, Text Analysis, Software Version Control, Amazon Redshift - **Published:** October 28, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=4d408d7fa0a2ba69 ## About the Role * 5+ years of experience in analytics engineering or a similar technical role * Expert-level SQL skills with deep understanding of data warehouse concepts * Hands-on experience with dbt for data transformation and modeling - dbt core experience preferred * Proficiency building data applications, dashboards, and reports in Sigma and/or Hex * Proven experience leading or executing a migration from a legacy data warehouse (Redshift) or BI tool (Tableau) to a modern analytics stack * Expert-level experience with Snowflake as a cloud data warehouse (required); familiarity with AWS Redshift a plus for migration context * Proven experience building and maintaining a semantic layer / metrics catalog to serve multiple downstream applications * Working knowledge of Python for analytics automation, predictive modeling, and reporting * Experience with version control systems (Git) and CI/CD practices * Practical experience leveraging AI/LLMs within a data stack to solve business problems - including prompt engineering, AI-assisted analytics, or GenAI tools in Hex, Sigma or Snowflake * Experience with data lakehouse technologies, including Apache Iceberg and AWS Glue (a plus) * Experience in commercial insurance, financial services, or venture-backed technology companies * Track record of building data solutions in B2B SaaS or enterprise software companies * Experience using JIRA for project management and tracking * Excellent communication skills with high attention to detail * Bachelor's degree in Computer Science, Engineering, Mathematics, or related field * Self-starter who thrives in a fast-paced environment, capable of juggling multiple initiatives and meeting strict deadlines Physical Requirements * Must be able to sit/stand/walk for prolonged periods of time (up to 8 hours per day), at a desk working on a computer. * Must be able to use standard office equipment for extended periods of time, including but not limited to, a mouse, keyboard, phone and video conferencing. ## Description * Design, build, and maintain data models using dbt core, ensuring efficient, scalable, and well-documented analytics solutions * Lead and execute the migration of data assets from Redshift and Tableau to our modern stack - Snowflake, Sigma, and Hex - ensuring data quality and business continuity throughout * Build interactive data applications, dashboards, and reports in Sigma and Hex that enable self-service analytics for business stakeholders * Design, build, and govern our centralized semantic layer to standardize business metrics and enable true self-service analytics across Sigma and Hex * Develop and maintain Python scripts for analytics automation, predictive models, and operational reporting * Implement and maintain data quality testing frameworks to ensure reliable, trustworthy data * Integrate AI and LLM capabilities (including Claude) into analytics workflows to automate data enrichment, text analysis, and predictive modeling for insurance use cases * Create and manage JIRA epics, stories, and tasks to track development work * Collaborate with stakeholders to understand business requirements and translate them into technical solutions * Additional duties and responsibilities as assigned.