ETL Developer

Information Technology Overland Park, Kansas


Description


Company Overview

Shamrock Trading Corporation is the parent company for a family of brands in transportation services, finance and technology. Headquartered in Overland Park, KS, Shamrock has consistently been named “Best Places to Work” by the Kansas City Business Journal. We also have offices in Chicago, Dallas, Laredo, Midland, Nashville, and Atlanta.

With an average annual revenue growth of 25% since 1986, Shamrock’s success is attributed to three key factors: hiring the best people, cultivating long-term relationships with our customers and continually evolving in the marketplace.


Responsibilities

Shamrock Trading Corporation is looking for an experienced, cloud-focused ETL Developer familiar with planning, building, and maintaining ETL processes, providing a "source of truth" for our business through a Data Warehouse. An ideal candidate will have strong database development knowledge as well as the ability to communicate requirements across a diverse, cross-functional team.

  • Gather requirements from Internal stakeholders on business and reporting requirements
  • Work with the data architects to design, implement and maintain database objects (tables, views, indexes, etc.)
  • Build reliable, efficient processes moving data between platforms
  • Create and update existing documentation of processes
  • Respond to process failure notifications and work with the team to resolve

Qualifications
  • Bachelor’s degree in computer science (or 5+ years with direct database development)
  • Demonstrable ability in tuning both database queries as well as business processes spanning multiple systems
  • Familiar with both Relational and unstructured data stores (Postgres, MS SQL, MongoDB, ElasticSearch)
  • Ability to read data structure documentation, such as an ERD, and infer input requirements
  • Prior experience with ETL development tools (such as Matillion, Talend, Informatica, Alteryx)
  • Preferred but not required qualifications include:
    • Demonstrable experience writing and maintaining Python and/or Java
    • Prior experience with streaming datasets, such as Kafka, Amazon Kinesis, or RabbitMQ
    • Familiarity with AWS services. (Lambda, S3, ECS/ECR, IAM)
    • Experience with version control (git) and peer code reviews

Benefits Package

At Shamrock we hire bright, ambitious people and give them the tools they need to be successful. By investing in training and development, we hope to become a long-term career for employees, where there are always opportunities for advancement. Shamrock also offers a premier set of benefits for employees and their families:  
  • Medical: Fully-paid healthcare, dental and vision premiums for employees and eligible dependents 
  • Financial: Generous company 401(k) contributions and employee stock ownership after one year 
  • Wellness: Onsite gym, jogging trail and discounted membership to nearby fitness center 
  • Work-Life Balance: Competitive PTO and paid leave options 
#LI-NB1