Strategic Financial Solutions

Data Engineer (Remote)

Job Locations US-NY-New York
Category
Engineering
Job ID
2021-1530

Overview

Strategic is looking for a Data Engineer to build out our first data warehouse. You will have a critical role in shaping our data architecture, ETL processes and systems. You’ll work across the business with our Product, Marketing, Sales, Analytics and Customer Service teams every day to improve our data warehouse and the quality of our BI platform.

 

Additionally, you’ll play a critical role in building out our data architecture in Azure. Do you enjoy diving into technical problems with your team and helping them succeed? Great. Come work at Strategic!

 

As a Data Engineer, you’ll contribute to a variety of projects that range from designing robust and fully automated ETL processes to building tools for improving company-wide productivity with data. You have a passion for designing, implementing, and operating stable, scalable, and efficient solutions to flow data from production systems into our data warehouse. Additionally, you’ll work closely with our Analytics teams to QA and vet our data to ensure that the PowerBI dashboards that run our business are up-to-date and accurate.

 

Creating and maintaining a collaborative culture built on helping other teammates while learning new technologies and skills is a critical aspect of this role. We’re a relatively small DevOps team in a stable yet fast-growing financial company.

 

This role can be based in either of our NY offices or where the chosen applicant resides

Responsibilities

Products we craft:

We are building tools for our sales team to help relieve people of their burden of debt. Leveraging technology to make a person’s life better is something you will do every day. Learning something new every day is something (we hope!) you will do as your build out your data pipelines and ETL processes. Some of our applications are custom developed in-house, and others integrate with SaaS products and Salesforce.

Tools we use 

For managing our work, we use Jira Kanban boards along with Confluence for documentation. We also use Slack and Zoom for video conferencing. Within devops we are beginning to use Terraform for our production infrastructure and Splunk for unified logging (aggregation/correlation). All of our software deployments are moving to GitHub Actions.

About the Role 

As a Data Engineer at SFS, you'll collaborate closely with our Development team and work within our strong DevOps team.

Some of the areas where you will be assisting will include, in no specific order:

  • Interfacing with other engineers to extract, transform, and load (ETL) data from a wide variety of in-house and third-party data sources.
  • Ensuring we have data consistency on both production and analytical databases. You’ll own the integrity of our data from end to end, and the company will make high impact decisions based on this data.
  • Architecting and building a data warehouse to provide timely data to a variety of third-party applications (Salesforce, MuleSoft, etc).
  • Designing and building tools that make our data pipelines more reliable, manageable and resilient.
  • Triaging, identifying, and scaling issues within our data warehouse.
  • Collaborating with internal data customers to gather requirements.
  • Evolving our data engineering function in areas of data architecture, machine learning and predictive analytics.

At Strategic, we are a team of learners, who look for the best ideas from across anywhere. We also try new things, test them with our teams, and look at how to improve our software, process, and potential.

Qualifications

What we're looking for:

  • Bachelors in Computer Science or similar experience
  • 3+ years experience with at least one relational database—Microsoft SQL, MySQL, PostgreSQL, etc.
  • Data Warehousing and Data Lake experience using modern tools.
  • Experience with large-scale data pipelines and ETL tooling.
  • Strict confidentiality of sensitive customer data.
  • Advanced experience working with Git (rebasing/merging, cherry picking, conflict resolution, etc.) 
  • A team player with a solution oriented attitude with both the technical and soft skills to get things done.

Bonus points:

  • Experience with Microsoft Azure or Amazon Web Services
  • Business Intelligence, Analytics or Finance experience.
  • Experience with Big Data Technologies.

A Little About Strategic:
Strategic Financial Solutions is an award-winning financial services firm dedicated to helping people live a financially healthy life through the products and services we offer. We were recently named as one of the Best Companies to Work for in New York State for the 5th time. Additional honors include being named, two times, as one of the 50 fastest growing companies in New York City and to the prestigious Inc. 500 list as one of the 500 fastest growing companies in the United States. Strategic is 100% employee owned, has offices in Manhattan and Buffalo, to house our rapidly growing family of over 900 associates. In June 2021 we proudly celebrated our 14th anniversary.

 

Strategic is committed to hiring, training, cultivating, promoting, and celebrating an environment where we have a welcoming and fulfilling place for all people to call home. Diversity of race, thought, sexual orientation, age, veteran status, religion, and disability will empower us to thrive as individuals, as teams, and as a company. 

 

Please mark @talent.icims.com as a safe sender to ensure recruiter emails don't go to spam​

 

#LI-Remote

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed