Data Warehouse Engineer - Developer III

We’re looking for a motivated data warehouse engineer to help us scale our growing SaaS company. Our ideal teammate is someone who can both contribute ideas to our larger tech strategy and take charge of technical implementation.

This role will be asked to support our existing reporting offering (OLTP source, OLAP warehouse, Sisense frontend with multiple cubes), modernizing our platform, and update the data model as we add new features or get requests from customers for additional reporting data. Additionally, we want you to help shape the future of FMX's reporting offerings. 

In this role, you’ll have a high degree of ownership over the data pipeline. We are looking for someone with a holistic understanding of ETL pipelines, SQL, star schemas, and dimensional modeling. We’d love to become front-end agnostic, so we could support Sisense Live Models, Power BI, or other reporting tools.

If you are seeking a rewarding challenge where you can truly own your impact, grow the practice, and guide us in our reporting journey this role may be the right fit for you.

Desired Outcomes & Responsibilities

• Advise us on our current offering and guide us in our future data architecture 
• Modernize our existing data warehouse (OLAP database) and reporting solution (Windows-hosted Sisense version 20.22.9.10072)
• Improve the design and throughput of our existing MS SQL ETL process
• Develop and maintain data models that ensure data accuracy, consistency, and integrity.  Add and update facts and dimensions to meet customer needs.
• Stay up-to-date with the latest trends and advancements in data engineering and reporting technologies.
• As needed, assist our Customer Success team with customer-facing business intelligence solutions
  

What is FMX?

FMX (the company) is a remote-first SaaS company building great software by enabling great people to do their best work through great technology and a great culture.

FMX (the product) is a computerized maintenance management system that streamlines maintenance processes for facilities leaders. Our mission is to simplify complex tasks and improve our customers' lives. Through ease of use, configurability, and world-class customer support, we strive to meet the unique needs of each organization we serve.

Note: we are a remote-first company, but the majority of our teammates work East Coast hours. The engineering team holds a daily standup at 9AM EST.

What's in the DNA of FMX (the company?)

At FMX, we're dedicated to providing a fulfilling and challenging work environment that values our employees' well-being and growth, both personally and professionally. As a company, we’re committed to growing sustainably, which provides job security for employees even during economic downturns.

At FMX, our core values are

• Integrity: Doing the right thing, especially when it’s hard
• Excellence: Embrace productive discomfort, commitment to continuous improvement, and coachability
• Teamwork: respectful communication, asking for help, and giving help, owning your attitude and impact

These aren’t just catchy phrases on a poster in the office. These values are at the heart of everything we do and guide our decisions, actions, and interactions with our employees, customers, and partners.

Requirements

Experience & Qualifications:

• Holistic understanding of ETL pipelines and OLTP → OLAP processing 

• Proficient in SQL
• Knowledge of star schemas and dimensional modeling (hands on experience preferred)
• Preferred: experience in Sisense with an understanding of Elasticubes and Live Querying 
• Desire and ability to identify valuable opportunities to improve our offering 
  

If you are seeking a rewarding challenge where you can truly own your impact, grow the practice, and guide us in our reporting journey this role may be the right fit for you.  

Who thrives at FMX?

At FMX, we're looking for employees who are passionate about their work, committed to continuous improvement, and embrace productive discomfort. We're seeking self-motivated individuals who can thrive in a remote work environment and can communicate respectfully and constructively. We value employees who are disciplined in their processes and responsibilities, coachable, and seek out constructive criticism.

We encourage our employees to take ownership of their roles and contribute their ideas towards the direction of our products and company. We believe that our employees are the key to our success, and value their input and ideas. We strive to give our employees the a