Analytics Engineer

Job description

About Moser For more than 25 years we have formed partnerships and grown through open and honest collaboration with our clients, partners, and employees. We are best known for taking great care of our clients, our dedication to creating a work environment where employees do their best work, and our deep commitment to continuous improvement. Our consultants work in a collaborative and fast-paced environment, are self-motivated, and are passionate about evolving technology. It is no accident that we are recognized as one of the Best Places to Work in Indiana for 10 consecutive years. Internally, we believe in building strong teams from the top down with a focus on values in our Model-Coach-Care philosophy. Our leadership are encouraged and trained to model good practices, mentor other employees and each other, and show empathy and caring in all interactions. This is the base of our core values: Accountability, Balance, Collaboration, Focus, Integrity, Social Responsibility, Support and Transparency. Moser Consulting believes in equal opportunity for all people and is committed to enabling a diverse, equitable, and inclusive culture. We foster a spirit of unity that respects the remarkable individuality of everyone's culture, history, and service. Description We are looking for a Senior Analytics Engineer to sit at the intersection of data engineering and analytics. You will own the transformation layer of data platforms — designing, building, and maintaining the data models that power dashboards, self-serve reporting, and AI solutions. You will work closely with data engineers and business stakeholders to turn raw data into clean, reliable, and well-documented datasets. Our ideal candidate is passionate about data modeling and has a strong understanding of why it matters, not just how it's done. You're naturally curious and eager to learn new tools, technologies, and approaches. Just as importantly, you can look past what a client or stakeholder asks for to understand what they actually need — so you can recommend and deliver the solution that serves them best. Role Responsibilities Design, build, and maintain scalable data models that serve as the foundation for analytics. Partner with analysts and business teams to translate requirements into clean, reusable data assets. Establish and enforce data modeling best practices, testing standards, and documentation conventions. Implement data quality tests (schema tests, freshness checks, custom assertions) and own the resolution of data issues. Collaborate with data engineers on ingestion pipelines and warehouse architecture decisions. Build and maintain BI semantic layers and expose clean interfaces for reporting, dashboards, and self-serve analytics. Review and mentor analytics engineers and analysts on SQL, modeling patterns, and tooling. Drive the adoption of analytics engineering standards across the organization. Contribute to the evaluation and rollout of new data tooling (e.g., orchestration, observability, BI platforms). Requirements 5+ years of experience in analytics engineering, data engineering, or a closely related role. Experience with a cloud data warehouse, such as Snowflake, Databricks, or similar. Strong SQL skills with the ability to write transformations that are performant, readable, and maintainable. Deep knowledge of dimensional modeling (Kimball), including SCD handling and fact table selection across a range of analytical challenges. Experience working with BI tools (Power BI, Tableau, Sigma, or similar) and understanding semantic/metric layers. Ability to investigate anomalies and demonstrate problem-solving skills to resolve data issues. Comfort using agentic AI workflows to accelerate development and problem-solving. Demonstrated ability to document data models clearly for both technical and non-technical audiences. Excellent communication skills and a track record of partnering with business stakeholders. Preferred Skills Experience using dbt or similar transformation frameworks. Experience with GitHub or an equivalent for version control and CI/CD. Familiarity with orchestration tools such as Airflow, Prefect, or Dagster. Experience developing validation routines and reconciliation processes. Python skills for data tasks (scripting, testing, lightweight transformations). Deeper Power BI experience: A strong conceptual grasp of what logic belongs in Power BI versus the data warehouse. Configuring and optimizing semantic models, including row-level security. A solid command of DAX, including basic and time intelligence functions. Achieving functional outcomes through techniques like field parameters, calculation groups, buttons and bookmarks, and drill-through. Where You'll Work Moser Consulting has 2 local Indianapolis, IN offices. You will be able to flex your time and work a hybrid/onsite work schedule out of Castleton and downtown offices. Salary At Moser Consulting, we believe in pay transparency and fairness. The $115k-$149k salary range for this role is not just a number—it’s a reflection of the value we place on the skills and experience our employees bring to our team. We are committed to offering a competitive salary that aligns with the industry standards and the unique competencies you bring to our community. Benefits For over a quarter of a century, Moser Consulting has been a beacon for top-tier IT talent who excel in self-management. Our people are our greatest asset. We don’t just hire the best—we welcome them into our family, connect them with opportunities, and empower them to create innovative solutions to technology challenges. Our unique culture is our competitive edge. It fosters happiness, health, and low stress, even in an industry known for its demands. This is why we’re consistently recognized as one of the Best Places to Work in Indiana. We provide our employees with an inspiring workspace, a fun and collaborative atmosphere, and a generous compensation package. But that’s not all. We also offer a suite of benefits designed to support and enrich our employees’ lives. These include: Training Opportunities: We believe in lifelong learning and provide numerous avenues for skill enhancement. Fully Invested 401K Plan: We help secure your future with a fully invested 401K plan. PPO and HDHP Medical Plans: Choose the health insurance program that best fits your needs. Employer-Paid Dental and Vision Plans: We cover dental and vision plans, ensuring our employees have access to comprehensive health care. Onsite Fitness Center: Stay fit and healthy with our state-of-the-art fitness center. Wellness Program: We promote a healthy lifestyle with our wellness program. Catered Lunches: Enjoy delicious catered lunches regularly. At Moser Consulting, we don’t just offer jobs—we offer careers, growth, and a chance to join a thriving community. Come, be a part of our family. Moser Consulting is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a professional.