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.

REQUIREMENTS

• 5+ years of experience working with databases, data engineering, and/or software development roles.
• 3+ years of experience using python and/or SQL for data engineering.
• 3+ years of data engineering experience in a cloud environment (Azure, AWS, GCP).
• Ability to design, develop, and maintain scalable, reusable code, using an agile framework and source control management.
• Experience with dimensional modeling, SCDs, and medallion architecture.
• Strong problem-solving skills including researching errors, performance issues, query optimization, and general troubleshooting.
• A proven track record of working collaboratively on complex, medium-to-large ELT/ETL projects that span multiple months.
• Ability to create functioning prototypes to address quickly changing business needs.
• Clearly articulate pros and cons of proposed technologies/solutions.

• Architect and implement end-to-end cloud solutions including data lakes, data warehouses, and real-time analytics platforms.
• Design, build, and troubleshoot data acquisition pipelines from diverse sources including databases, flat-files, and REST APIs.
• Apply medallion architecture (bronze/silver/gold) to deliver scalable and secure solutions.
• Leverage development design patterns and best practices across workloads.
• Design star schema dimensional models and implement semantic models optimized for Power BI analytics.
• Configure incremental refresh and partitioning strategies to optimize compute unit (CU) consumption and query performance.
• Apply and promote best practices for data engineering including governance, scalability, and deployment standards.
• Implement and manage RBAC (Role-Based Access Control) with a zero-trust security approach, ensuring appropriate access to data and services across cross-workspace environments.
• Troubleshoot and proactively identify issues including researching performance issues, pipeline failures, notebook timeouts, data model inconsistencies, semantic model refresh errors, and capacity throttling using monitoring tools and query optimization techniques.
• Create and maintain technical documentation, operational documentation, data flow diagrams, and data mapping documents.
• Provides technical leadership and mentorship to team members.
• Excellent communication skills for technical and non-technical audiences.
• Ability to work independently as well as in a team-environment.
• Excel in a fast-paced environment and can manage multiple client engagements simultaneously.