Senior Cloud Data Engineer

Overview Moser Consulting has formed partnerships for more than 25 years through open and honest collaboration with clients, partners, and employees. We are known for taking great care of our clients, creating a work environment where employees do their best work, and our commitment to continuous improvement. Our consultants work in a collaborative and fast-paced environment, are self-motivated, and are passionate about evolving technology. We are recognized as one of the Best Places to Work in Indiana for 10 consecutive years. Internally, we build strong teams from the top down with a focus on values in our Model-Coach-Care philosophy. Our leadership is encouraged and trained to model good practices, mentor others, 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. We foster a diverse, equitable, and inclusive culture and respect the individuality of everyone’s culture, history, and service. Responsibilities 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. Provide 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. 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. Ability to design, develop, and maintain scalable, reusable code, using an agile framework and source control management. Strong problem-solving skills including researching errors, performance issues, query optimization, and general troubleshooting. A proven track record of working collaboratively on complex 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. Where You'll Work Moser has two offices in Indianapolis, IN, and one in Baltimore, MD. This position will allow hybrid/onsite work schedule or the ability to work out of one of our two Indianapolis offices. Salary At Moser Consulting, we believe in pay transparency and fairness. The $115k-$149k salary range for this role reflects the value we place on the skills and experience of our employees. We are committed to offering a competitive salary that aligns with industry standards and the 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 culture fosters happiness, health, and low stress, and we are consistently recognized as one of the Best Places to Work in Indiana. We provide an inspiring workspace, a collaborative atmosphere, and a generous compensation package. We also offer: Training Opportunities: We 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 for comprehensive health care. Onsite Fitness Center: Stay fit and healthy with our 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. 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 protected veteran. #J-18808-Ljbffr Moser Consulting