Data Engineer - foley carrier services : Job Details

MISSIONMissions 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 EngineerFoley 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 WITHAt 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 DOAt 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, including Microsoft SQL, redshift, database versioning and deployment models, et al.
• Experience with Python, C#, or other programming languages.
• Experience working with web services/APIs to extract data from vendor solutions
• Experience in non-SSIS ETL/ELT tooling is a huge plus (Airbyte, Fivetran, et al)

If you are an analytical and critical thinker with excellent organizational skills, attention to detail, and the ability to self-organize and meet deadlines, we encourage you to apply.WHAT YOU WILL LOVE ABOUT FOLEY

• The people! Our employees and customers consistently express the best thing about Foley is our close-knit, exceptionally talented teams. Check out our customers feedback - on Trustpilot
• Outstanding benefits. 3 medical plans to choose from, 2 level dental, and 2 level vision plans. Generous vacation, sick, and personal time off. 401K plan with a match. We've got your back so you can live your best life.
• It's about ideas over egos. You will have the freedom to explore new ideas and approaches in an entrepreneurial environment, supported by a collaborative team.
• Professional growth. We open our roles to our employees first and encourage them to apply for growth opportunities. Our People Operations team is available to discuss career growth and help put a plan in place, helping employees achieve the growth they crave.
• Our environment! We celebrate success and believe in transparency and teamwork to get us there. We invest in collaboration tools so you can meet with your team face to face. Many of our roles are remote and we want to ensure our employees are engaged and can interact with their peers in a virtual space.

What We Do, How We Do ItToo often, companies use a piecemeal approach when it comes to screening drivers. They might use one vendor to help recruit. Another to screen. And still, another to address the complex world that is compliance. This approach is inefficient, expensive, and redundant. Not to mention, it makes it too easy for things to fall through the cracks.At Foley, we've built a company that effortlessly manages these three areas under one roof: recruit, screen, comply. Thanks to powerful technology combined with our compliance expertise, we're able to deliver a comprehensive solution to our customers and, as a result, a better overall customer experience.Where We're HeadedWe're always developing new solutions to slay tomorrow's recruitment, screening, and compliance monsters. At the core of these solutions is our vast collection of data-and the many ways to leverage it, whether that's developing software to calculate a company's compliance risk or implementing predictive analytics to identify the best drivers.What It's Like to Work with UsDiving deep into a niche industry and becoming an expert . . .Continually growing and advancing . . .Making lifelong friends during the process . . .That sums up what it's like to work for us. We're a 250+ person company on the verge of explosive growth thanks to our AI-powered technology-and where it's headed with predictive analytics. If you'd like to board our rocket ship, check us out:www.foleyservices.comKeywords: Data ArchitectDatabase EngineerBig Data EngineerData Systems EngineerETL DeveloperData Warehouse EngineerBusiness Intelligence DeveloperData SpecialistData Platform Engineer