Job description

Falling Colors offers solutions for administering public, private, and charitable funds to organizations that share a mission of promoting the Social Determinants of Health. We track allocated spending and measure outcomes through a configurable software platform and supporting services, allowing customers to glean insight into the effectiveness of funded programs via reporting and analytics dashboards, driving outcome-oriented decisions to maximize the impact of future investments.

We are seeking a Data Engineer to join our data team supporting our data environment focusing on ETL and data warehouse development and design. Applications will be accepted from individuals with at least 4 years of experience that reside in New Mexico. Periodic travel to headquarters will be required, but this position is otherwise remote.

Falling Colors
Falling Colors is a small (~30 person) B-certified company that is women and LGBTQ+ founded, owned, and operated. We are a diverse and open-minded team, with a mix of genders, ethnicities, and interests. We have parents and non-parents, self-taught and formally educated folk, introverts and extroverts, semi-professional ballroom dancers, golfers, gardeners, rock climbers, yogis, and VR hobbyists. As a company, we value using our skills and time to improve the world around us — from behavioral health care to local educational opportunities. As a team, we strive to be kind, support each other, and work together, stepping forward to handle all the exciting things that get thrown our way.

At Falling Colors, we don’t just build technology: we build impact. We take great pride in what we do for our communities with our products, and further seek to improve the world in everything we do. Our passion project is The White Building, a space rich with history. You can read more about this project at thewhitebuilding (dot) com on Instagram @thewhitebuilding. We use a portion of our profits to fund our Falling Colors Foundation, which paid out over $200,000 in small business grants to help our local businesses make it through uncertain times during the pandemic. We pay our employees to volunteer and do our best to protect them from burnout with a generous PTO policy, flex time, and paid holidays. We protect our employees’ futures by partnering with a B-certified financial group that manages our 401k accounts (and we contribute—not match—a percentage to those accounts). We understand the critical role we play as a business in the six determinants of social health, and we want to be the company that sets the bar and inspires others to be better.

We are in Santa Fe, New Mexico, with satellite offices across the United States. This is a hybrid position for a candidate residing in New Mexico or Colorado. The candidate will therefore need to have a functional at-home workspace with reliable internet service and the ability to come work in the office.

Data Engineer Qualifications & Responsibilities

Responsibilities

• Be an individual contributor who is excited to build new ETL pipelines, maintain and enhance existing pipelines, and become an expert on our data and infrastructure.
• Collaborate on an interdisciplinary team to design and develop business intelligence solutions for behavioral health providers and administrators.
• Work with data analysts and product support to translate business needs into specifications for data warehouse and pipeline design.
• Design, implement, and maintain ETL and data cube solutions with an eye towards performance, security, and quality.
• Preprocess and integrate heterogenous data sources.
• Evaluate ETL performance and explore opportunities to automate processes, reduce bottlenecks, enhance quality, and improve overall usability.
• Support the design, development, and implementation of data warehousing, reporting and analytics solutions that deliver information efficiently, allowing our clients to make informed, data-driven business decisions.
• Produce ad-hoc reports and analyses when needed.
• Have or develop excellent understanding of privacy rules related to sensitive health data our systems process to ensure appropriate handling of such sensitive data.
• Create and maintain documentation in support of the team.

Qualifications

The Must Haves:

• Bachelor’s degree in computer science or equivalent, or demonstrated experience and competency equivalent
• At least 3 years of database development experience with a demonstrated proficiency in writing advanced tSQL to extract data from complex data structures.
• At least 3 years’ experience designing and developing data warehouses with a demonstrated proficiency in dimensional modeling.
• Designing and implementing ETL solutions using Azure Data Factory (ADF) and/or Integration Services (SSIS).
• Experience with database design for transactional systems and data warehouses.
• Experience working on an interdisciplinary team of engineers, analysts, data quality professionals, and subject matter experts.
• A friendly team player attitude, comfortable wearing different hats on different projects and willing to take leadership or support roles as needed.
• Comfort working in existing structure and process, with a focus on technical implementation and data.
• A passion for working in service of a meaningful mission to improve the lives of vulnerable populations through technology and data

The Good to Haves:

• Experience analyzing and optimizing slow running queries.
• Experience writing DAX statements.
• Experience with Streaming Data Pipelines.
• Experience analyzing and optimizing slow running queries.

The Bonus Stuff:

• Demonstrated knowledge of the unique security and analytical considerations in working with protected healthcare data and information systems.
• Demonstrated experience designing and implementing disaster recovery solutions to hit RPO and RTO
• Working knowledge of PowerShell and specifically dbatools.io
• Experience with Azure cloud infrastructure
• Experience administering SQL Server in a cloud environment
• Python programming experience
• Ability to debug and understand C# code
• Familiarity with State of New Mexico public and behavioral health agencies

Diversity Statement

Falling Colors is committed to recruiting and retaining a diverse workforce. We recognize that the tech industry overall has failed to develop a workforce reflective of our population as a whole, and pledge to do our part to do better. We encourage people of color, differently abled people, veterans, women, and LGBTQ folks to apply for open positions. We believe that a diverse workforce made up of people with different backgrounds and life experiences makes us stronger and better able to serve the communities where we work to make a difference. We will consider all applicants without regard to race, color, national origin, religion, sexual or gender orientation or expression, marital or parental status, disability, age, or other protected basis.

Benefits

We offer:
A month of paid time off plus a month of holidays
Paid parental leave
Paid volunteering time
Generous 401k contribution
Generous health, vision, and dental plans (for employee and family, at no cost to our employees)
Employer-paid short- and long-term disability plans
Employer-paid life insurance
Professional growth and continuing education opportunities
Estate planning stipend
LifeLock subscription

Falling Colors is an Equal Opportunity Employer

What Next?
If you think this sounds like it could be you, we encourage you to apply. We do not expect anyone to have all the things we are looking for, and we are always happy to have a conversation.

To apply, please send your resume and a cover letter to apply @fallingcolors (dot) com. We look forward to getting your application!

Job Type: Full-time

Pay: $85,000.00 - $95,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Employee assistance program
• Health insurance
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

Schedule:

• Monday to Friday

Application Question(s):

• Are you a resident of New Mexico, or are you willing to relocate?

Experience:

• data warehouse design and development: 3 years (Required)
• database development: 3 years (Required)

Work Location: Remote

offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.