The Analytics Engineer role at The New IEM, Llc focuses on turning raw data into production analytics models and managing the transformation layer between data ingestion and the BI surface, utilizing dbt and Snowflake to power Tableau dashboards and self-service analytics.
Responsibilities
- dbt Transformation Models: Design, build, test, and document dbt models that convert raw Snowflake data into clean, analytics-ready datasets across Finance, Production, Supply Chain, and Engineering
- Dimensional Modeling: Build conformed dimensions, fact tables, and reporting models that balance performance, maintainability, and business user accessibility for Tableau dashboards and ad hoc analysis
- Data Quality: Author and maintain dbt tests, monitor freshness, investigate data quality issues end-to-end, and own resolution through to root cause
- Business Partnership: Partner with cross-functional stakeholders and the Business Intelligence team (Finance, Production, Supply Chain, Engineering) to translate operational needs into scalable data models and reliable metrics
- Semantic Consistency: Establish and document standardized metric definitions and reusable data models to ensure consistency, accuracy, and alignment across all reporting
- Documentation: Maintain clear model descriptions, column-level documentation, and lineage notes that the team and downstream BI developers actually use
- Engineering Standards: Participate in code reviews, follow Git workflows and CI/CD practices, and contribute to evolving the team's modeling conventions and deployment standards
- Source Integration: Partner with the data engineering function on Fivetran and custom ingestion to ensure raw data lands in shapes that downstream models can rely on
- BI Enablement: Collaborate with BI developers and analysts to structure datasets for optimal Tableau performance and effective self-service analytics
- AI-Assisted Development: Use AI coding assistants and agent-based tools to accelerate model development, test generation, refactoring, and documentation
- Manage AI agents as part of daily workflow to increase throughput and quality
- Continuous Learning: Stay current with the modern data stack and analytics engineering practices, bringing ideas back to the team and helping raise the bar over time
Requirements
- Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or a related field (or equivalent experience), with 4–6 years of experience in analytics engineering, data engineering, or BI development, including ownership of production data models
- Strong SQL skills with experience in data transformation, complex querying, and performance optimization on large datasets
- Hands-on experience with dbt, including incremental models, tests, macros, snapshots, and documentation
- Experience working with Snowflake or a comparable cloud data warehouse, along with familiarity with ELT tools (e.g., Fivetran)
- Solid understanding of dimensional modeling (grain, surrogate keys, slowly changing dimensions, star schemas)
- Working knowledge of Python for data processing, scripting, or lightweight integrations
- Familiarity with Tableau or similar BI tools, with an understanding of how data structure impacts performance
- Experience with Git and modern development practices, including code reviews and CI/CD workflows
- Strong communication skills, with the ability to translate technical concepts for business stakeholders and gather requirements effectively
- A collaborative team player who is open to training, mentoring, and working closely with non-technical stakeholders
- Self-motivated and able to work independently while collaborating across distributed teams
- Experience leveraging AI coding assistants (e.g., Copilot, Claude) to support analytics engineering tasks such as SQL development, dbt modeling, testing, and documentation
Technologies
dbt, Snowflake, SQL, Python, Tableau, Git, Fivetran, Copilot, Claude, YAML, CI/CD
Benefits
- Comprehensive and competitive benefits package
Location
US Remote. Fully remote within the United States. May require up to 10% travel to IEM facilities for team collaboration, project kickoffs, and stakeholder meetings.
Why Join IEM
At IEM, you will join a team that powers ambitious projects across diverse industries. We are engineers, makers, and problem-solvers who tackle complex challenges and deliver solutions that keep industries moving forward. If you are driven, collaborative, and ready to make an impact, this role offers opportunities to contribute meaningfully. Learn more about IEM at https://www.iemfg.com.
We offer a comprehensive and competitive benefits package designed to support employees' well-being, growth, and long-term success. See a snapshot of our benefits at https://www.iemfg.com/careers.
Recruiting Scams
Beware of recruiting scams. IEM never charges candidates fees, and all recruiter emails originate from @iemfg.com addresses. If you suspect fraudulent activity, do not share personal information and report it at iemfg.com/contact.
Non-Discrimination Statement
IEM does not discriminate against any applicant based on any characteristic protected by law.
Privacy
Information collected and processed as part of your IEM Careers profile, and any job applications you submit, is subject to IEM's Workforce Member Privacy Policy.
