Data Engineer

MISSION

Missions are accomplished with people, driving towards a greater purpose. Foley has been a trusted partner to motor carriers of all sizes. Our technologically advanced approach to DOT compliance automates many of the background screening and compliance requirements motor carriers must comply with- making it easier for them to onboard and retain the right driver for their business. At Foley we just don’t help our customers stay compliant – we help them thrive.

A positive attitude is everything. At Foley, we’ve created a culture that rewards kindness, enthusiasm, and a can-do attitude. Whether we’re working together internally or helping a customer solve a problem, we approach every challenge with a sense of humor, optimism, and the determination to succeed.

Data Engineer

Foley is looking for an exceptional Data Engineer with extensive experience in ETL/ELT Tools and Processes, General Database Development, Data Warehousing, Data Delivery Automation and Testing, and foundational engineering patterns and practices to be a key member of Foley’s engineering team.

As a Data Engineer at Foley, you will be a key member of the team that drives direction of our data analytics capabilities, evaluating current and prospective tools and technologies, and generally helping to grow Foley’s data product line! You are really excited about joining a team with massive potential for growth.

This is a REMOTE option- Those residing in CT, MA, SC, GA, FL, TX are welcome to apply!

WHO YOU WILL WORK WITH

At Foley, we value our employees and treat them with respect while providing them with opportunities to make a difference. You will work with Foley teammates across the organization.

Because our departments work so closely together, we are always looking to improve our current process. We welcome new ways to work collaboratively with roles and departments. We cannot wait to hear your ideas!

WHAT YOU WILL DO

At first, you will

• Learn how Foley’s products and services work and how Foley can have a positive impact on our customers’ business.
• Meet and get to know your teammates and stakeholders of our engineering organization.
• Understand our processes, procedures, and tools for development and deployment.
• Attend scrum events for all our development teams to understand how our technology and team works.
• Get up to speed on value of data products at Foley, understanding both internal and external customer needs.

Once you get settled, you will

• Maintain and evolve existing data pipelines using SQL Server Integration Services (SSIS) packages built using Visual Studio.
• Implement transformation logic in AWS Redshift data warehouse.
• Work with views and stored procedures to stage data from source systems for new and existing data pipelines.
• Design, build, test and deploy solutions to connect to data sources such as SQL Server databases, web services/APIs (from government or public databases, service vendors, and software partners), flat files on network and cloud storage, and other data source as needed.
• Build data extraction solutions using browser automation, robotic process automation, or other technology, as needed.
• Critically assess current technologies and processes and provide recommendations for improvement.
• Help establish and grow data governance policies and practice.
• Help foster a culture of safety, collaboration, and inquisitiveness.

WHAT WE’D LIKE YOU TO HAVE

• Excellence in teamwork – sharing ownership and inviting criticism.
• Excellent grasp of fundamental engineering concepts.
• Experience in and extensive knowledge of Scrum or Agile development.
• Strong analytical and diagnostic skills, as well as excellent written and verbal communication skills.
• Desire to continually improve and a strong appetite for change.
• Ability to quickly adjust to changing priorities.
• Strong documentation, organizational, and planning skills.
• Extensive experience building and running data workflows using SQL Server Integration Services (SSIS).
• Extensive experience developing in a Microsoft SQL Server environment.
• Experience working within a version control system (branching, merging, pull requests, et al)
• Knowledge of cloud native technologies and patterns.
• Experience with infrastructure-as-code tools and products.
• Working knowledge of data workflow deployment automation and testing technologies.
• Diverse knowledge of database products and concepts, inc