Title:  Data Engineer

Our History:
From our start in 2009, Conexess has established itself in 3 markets, employing nearly 200+ individuals nation-wide. Operating in over 15 states, our client base ranges from Fortune 500/1000 companies, to mid-small range companies. For the majority of the mid-small range companies, we are exclusively used due to our outstanding staffing track record

Who We Are:
Conexess is a full-service staffing firm offering contract, contract-to hire, and direct placements. We have a wide range of recruiting capabilities extending from help desk technicians to CIOs. We are also capable of offering project based work.

Job Description

Join our Software Engineering development team thru the full-lifecycle of data engineering and help build and grow the team in areas of data management, analytics, reporting, and business intelligence.

This person will participate in all phases of the development cycle: concept, initiation, technical design, prototype/POC, development, testing, release, and implementation; with a key focus on data definition, sanitation, process development around data (sourcing, provisioning, request mgmt., testing, etc.).  Will work with cross functional teams across our division.

MINIMUM QUALIFICATIONS

• Minimum of 6 years of technical experience in data and ETL design and development
• Minimum of 6 years hands-on experience with enterprise class database development, focused on transactional environments w/focus around SQL 2012/2014/2016; including redundancy modeling (Disaster Avoidance/Recovery), cross data center high availability, always on, horizontal and vertical scalability, and various forms of data movement (log shipping, replication modeling, Always On, etc.)
• Minimum of 5 years’ experience with analytics, dashboard tooling, and ETL toolsets in large enterprise-based payments/banking industry. 
• Experience working in Banking/EFT/Financial Institution domain and based technologies; along with data layer experience w/ ISO8583 in a cutting-edge enterprise.

PREFERRED QUALIFICATIONS

• Bachelor’s degree; business, software and infra engineering, or computer science.
• 5 years’+ experience with analytics, dashboard tooling, and ETL toolsets in large enterprise-based payments/banking industry.
• Focused on innovation and cutting-edge technologies within a five nines environment (99.999% uptime).
• 5+ years hands-on understanding enterprise systems, infrastructure, software design and development, database design and development, and system integration experience
• Experience working collaboratively with Stakeholders, Business Analysts, Project Managers, Designers and DBAs with the common goal of delivering value to the business.

PRIMARY FUNCTIONS/SKILLS

• Review, coordinate, analyses and defines requirements for new development/enhancements to and maintains existing systems including new product development, customizations and enhancements
• Understand data requirements, and design/develop/enhance new and existing business data management systems
• Design, develop and test data creation/migration/retrieval/management jobs
• Strong SQL/SSIS experience – including query, performance, table design, normalization.
• Strong ETL experience – including data sourcing & shipping from/to multiple sources using different data structures (flat files, comma delimited, VSAM, structured and unstructured data etc.)
• Strong data security, testing and validation experience

ESSENTIAL FUNCTIONS

• Work under data/solution architects to deliver enterprise class data structures and solutions and/or integration into custom product development.
• Help define data matrices, data dictionaries, data structures across various topologies (SQL Server 2016, Hadoop/Cloudera stacks, etc.)
• Complete product technical design and prototyping, data design/development, support and problem remediation.
• Understand data design patterns and enterprise design regarding data in the Payments Industry (banking, credit unions, bill pay, EFT, etc.) within both commercial off the shelf (COTS) and custom solutions.
• Experience around performance analysis at the Data/DAL layer and how to maximize performance in a highly transactional environment in the payments industry (cards, core banking, ATM, etc.)
• Provide both individual, team, and budget-level tasks and product effort estimates/costs and overall LOE regarding data efforts.
• Document technical designs, using flow charts, class diagrams, sequence diagrams, activity diagrams, data flow diagrams, database schemas, descriptive software component documentation, wireframes
• Creates required technical documentation, use cases, white papers, system and deployment architecture, and technical process/procedure documents for the group.
• Assess the risk, problem/problem resolution and impact of changes to complex solutions and the effect of hardware infrastructure change on a solution or technology.
• Reviews, coordinates, analyses and defines requirements for new development/enhancements to and maintains existing systems including new product development, customizations and enhancements