Systems Design / BI Architecture Engineer

WEX   •  

South Portland, ME

Industry: Accounting, Finance & Insurance

  •  

5 - 7 years

Posted 78 days ago

This job is no longer available.

Description

WEX Inc. is a leading and growing global provider of payment processing, information management and fleet card payment solutions.
We hire people who share our passion for continuous innovation and client service that is unparalleled in the industry.
If you are looking for a growing career – come be part of WEX today!


General Purpose:

Systems Design/BI Architecture Engineer 4: Designs a complete and complex framework, system or product . Defines processes for technical platforms, system specifications, input/output and working parameters for hardware and/or software compatibility. Conceives system interfaces and business application prototypes. Identifies, analyzes and resolves system design weaknesses. Influences the shaping of future products by contributing to the framework (architecture) used across multiple products or systems. Provides multi-layered technical expertise for next generation initiatives.

Essential Duties and Responsibilities:

Work with the Enterprise Architecture team to define data needs and build data loading through Corporate Tech ETL tools for high volume and resilient processes.
Work with the technical Business analysts, engineers and Data scientists to model and develop the data warehouse data flows and analytical models to be loaded into Data warehouses and Data lake to shape the WEX Data strategy to ensure data integrity and scalability and high availability.

Review and understand the data models (star-schema, data vault, de-normalized) and build data process flows in the support of the development and maintenance of the physical enterprise data warehouse. Research data source for new and better data feeds.

Work closely with internal partners to maintain high level of technology enablement and customer engagement through analytics.Design and Implement data integration and ETL/ELT processes Aid efforts to perform data mapping, data extraction, and loading.

Identify and refine processes to improve data quality and data processing times.
Strong SQL background and ability to work with complex SQL and help System DBA’s identifying performance bottlenecks and come up with solutions for tuning.
Experience in cloud-based data, ETL and streaming technologies.

Qualifications

Minimum Required Qualifications for Consideration
BS/BA with 5-7 years’ experience. A bachelor’s degree in Engineering or Computer Science is a plus.
Combination of related experience and education will be considered
Strong database background, both SQL and No-SQL
Experience on Cloud Databases: AWS Aurora, DynamoDB, Redshift
Experience with data management tools such as Talend, SAP, Informatica
Experience with BI/ Analytics tools, Tableau experience required
Strong aptitude to learn business processes/products and the role of data within the business domain
Excellent interpersonal communication skills
Successfully pass a background investigation

Preferred Qualifications
Knowledge of Predictive Algorithms and Big Data platforms is an advantage.
Knowledge of real-time replication tools is a plus

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

Equal Opportunity Employer/Vets/Disability

180001DU