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.

About the Position

We are looking for a SQL developer with ETL experience. Some of the responsibilities of this role include:

  • Develop high-quality data warehouse and tabular model solutions in client environments.
  • Develop T-SQL database objects and Azure Data Factory pipelines to facilitate the flow of data from the source systems.
  • Examine data and workflows to increase optimization and improve efficiency.
  • Write TSQL scripts and objects such as stored procedures, user-defined functions, and views per business requirements.
  • Design, Develop, Deploy, and Monitor complex data pipelines which may contain various required transformations of data using various languages and techniques, including but not limited to:
    • Microsoft Azure and/or SQL Server
    • Microsoft SSAS
  • Create and maintain technical documentation, functional documentation, data flow diagrams, and data mapping documents.
  • Work with stakeholders on data-related technical issues.
  • Ensure the stability, reliability, and performance of the systems.
  • Collaborate and work well in a team-environment.

Requirements

  • Proficient in writing advanced / complex SQL statements.
  • Experience developing Dynamic SQL, functions, and stored procedures using T-SQL.
  • Experience working with BI tools such as Microsoft’s Azure Data Factory, SSAS, T-SQL, and/or other BI tools.
  • Strong understanding of ETL/ELT fundamentals and solutions.
  • Experience in cloud-based architectures involving Data Warehouses and/or Data Lakes, Ingestion Frameworks, Transformation, and Data Set generation.
  • Ability to create functioning ETL 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. You will have the choice to work from one of our office locations, flex your time, or remain fully remote (in the U.S.).

Benefits

At Moser, the secret to success is our people and our commitment to them. We hire the best people, welcome them like family, connect them with opportunities, and let them do what they do best: produce innovative solutions to technology problems. Our culture gives us a competitive advantage by keeping our employees happy, healthy, and by lowering stress levels in a very demanding industry. We focus on giving employees: an incredible workspace; a fun, collaborative, and creative atmosphere; an extremely generous compensation package; and dozens of outstanding and unique perks usually not found at one company.