> Markdown version of [/jobs/ext/576322-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/576322-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). --- # Analytics Engineer - **Company:** Imperial PFS - **Location:** United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Data Analysis, Software Documentation, Software Quality, Data Architecture, Information Engineering, Data Governance, Data Infrastructure, Extract Transform Load (ETL), Data Mart, Data Transformation, Data Systems, Data Visualization, Document-Oriented Databases, Python (Programming Language), Performance Tuning, Raw Data, Power BI, Cloud Services, Software Engineering, SQL Databases, Tableau (Software), Technical Data Management Systems, Sql Optimization, Snowflake, Data Lakes, Data Lineage, Deployment Automation, Performance Monitor, Data Management, Looker Analytics, Software Version Control, Data Pipelines - **Published:** June 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=bd58ffff39c916df ## About the Role Do you have experience in Communication skills?, * 2-4 years of experience in analytics engineering, data engineering, or similar role * Advanced SQL proficiency in ANSI-SQL for querying, data transformation, and building data infrastructure * Snowflake expertise with hands-on experience in its architecture and best practices for data management and processing * Strong data modeling skills with deep understanding of data modeling principles and experience designing efficient structures for analytics * dbt proficiency for managing data transformations and building data models within Snowflake * Passion for detail and quality - skilled at spotting data and process gaps and committed to driving continuous improvement * Strong communication skills and comfort collaborating with non-technical stakeholders * Intellectual curiosity and drive to understand business problems through data, * SnowPro certification or equivalent advanced Snowflake expertise * Experience with modern cloud data architecture (data lakes, data lakehouses, cloud data platforms) * Experience with ELT/ETL tools (Fivetran experience a plus) * Knowledge of data visualization tools (Tableau, Looker, Power BI) * Previous experience in insurance, finance, or regulated industries * Python programming experience for data parsing, transformation, and scripting within data pipelines ## Description The Analytics Engineer builds and maintains the foundational data infrastructure that transforms raw business data into reliable, analysis-ready insights for decision-making. This position is critical to establishing scalable data models, pipelines, and governance practices that will support our growing analytical needs. The prime reason for this role's existence is to bridge the gap between raw data ingestion and analytics needs, ensuring that our analysts and stakeholders have access to high-quality, well-documented, and performant data models. This position directly contributes to the company's overall mission by enabling data-driven decision making across all departments, improving operational efficiency, and supporting strategic initiatives through reliable analytics infrastructure. Key contributions to the company include: * Building standardized data models that reduce time-to-insight for business users * Implementing data quality and governance frameworks that ensure information is accurate and compliant. * Creating reliable, well-documented data pipelines that enable consistent reporting and analytics across all business functions What You'll Do Data Modeling and Pipeline Development * Design, build, and manage data models and ELT/ETL pipelines to transform raw data into structured formats within Snowflake using dbt * Create conform and analytics layers that standardize data for business consumption * Develop dimensional models and data marts tailored to business requirements Data Quality and Governance * Implement best practices for data quality, integrity, and performance monitoring * Contribute to data governance frameworks, including maintaining data lineage and definitions * Establish data quality checks and validation processes within dbt workflows Performance Optimization * Optimize data storage and retrieval processes within Snowflake to ensure scalable, reliable, and cost-effective data solutions * Fine-tune SQL queries and data transformations for optimal performance * Monitor and improve pipeline efficiency and resource utilization Technical Documentation * Create and maintain clear, comprehensive documentation for data models, processes, and key metrics * Document data lineage and maintain metadata for analytical datasets * Establish documentation standards and best practices for the team Software Engineering Practices * Leverage version control and CI/CD pipelines for streamlined, reliable development processes * Ensure code quality through testing, peer reviews, and automated deployment Collaboration and Stakeholder Management * Work closely with analysts and business subject matter experts to understand requirements * Translate business needs into effective technical data solutions * Participate in regular stakeholder meetings to refine and expand data capabilities ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)