Data Engineer

WEX Inc   •  

South Portland, ME

Industry: Accounting, Finance & Insurance


Less than 5 years

Posted 36 days ago


We are looking for an experienced Data Engineer to join our growing data warehouse team. You will be responsible for profiling, analyzing, processing and loading the vast amounts of payment data we have. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys the challenge of precision-based quality and high-throughput performance engineering. You will be part of a small team that works on data initiatives to deliver information products to our Business Intelligence community. You will be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing our existing architecture and re-shaping it to leverage the next-generation, cloud-native tools.
Essential Duties and Responsibilities:
• Collaborate on design and maintain optimal data pipeline architecture.

• Analyze and process large, complex data sets to meet functional and non-functional business requirements.

• Assist team to build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and related ‘big data’ technologies.

• Deliver quality of work via unit testing.

• Ensure performance of code meets non-functional requirements.

• Work with stakeholders including the Management, Product, Data and Design teams to assist with data-related technical issues.

• Responsible for engaging with production support staff and remediating chronic and/or critical production support issues.

• Responsible for monitoring more junior developer and contracted staff.


Minimum Required Qualifications for Consideration:

  • Bachelor’s degree in Computer Science or Information Systems.
  • Minimum 4 years+ experience designing and coding data pipeline programs, particularly in a data warehousing or analytics environment.
  • Experience with Informatica, Talend, or an equivalent ETL tool.
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • Strong analytic skills related to working with structured and unstructured datasets.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • A successful history of manipulating, processing and extracting value from large disconnected datasets.
  • Excellent verbal and written communication skills.

Preferred Qualifications:

  • Experience in a high-volume, high-throughput data processing environment.
  • Experience with AWS cloud services: EC2, RDS, S3, Redshift, Glue, Athena.
  • Experience with Python is a plus
  • Knowledge of financial and/or payment systems.
  • Experience with source code version control.

At WEX, we reward innovation, hard work and excellence.
Benefits include:

· 401(k) Plan

· Adoption Assistance

· Bonus Plan

· Dental Insurance

· Dependent Life Insurance

· Employee Assistance Program

· Employee Referral Award Program

· Expedition - WEX’s Sabbatical Program

· Extended Parental Leave

· Flexible Spending Accounts (Medical and Dependent)

· Health Insurance

· Life Insurance/AD&D

· On Site Fitness Facility in South Portland location

· Pet Insurance

· Paid Time Off(PTO)

· Short- and Long-Term Disability Programs

· Tuition Reimbursement

· Vision