Learfield

Data Software / Sr. Software Engineer

Req No.
2018-2030
Location Name
Paciolan
Location
US-CA-Irvine
Category
Product Engineering
Type
Full-Time

Overview

Paciolan is the #1 primary ticketing company in college athletics, and the #2 largest primary ticketing provider in the US including performing arts, arenas, and professional sports. As a leader in ticketing, fundraising, marketing, analytics, and technology solutions, we power more than 500 live entertainment organizations, selling over 120 million tickets a year.

While we are the market leader in many areas, we will never act too big or move too slow as a company. At Paciolan, we come to work ready to innovate and succeed, and we always have fun doing it. You may not recognize our name, because we white-label our consumer channels, but we create great products at scale…not just once a year Black Friday, but every day our events go on sale!

 

As we continue to grow, we need awesome, passionate software engineers that love data to join us in designing and developing complex, scalable, and highly-available data warehouses, streams and reports for our B2B and B2C ecosystem. If your passionate about understanding the data, bridging current systems and helping design the future in a distributed and scalable cloud environment then we want to talk with you.

Responsibilities

What you’ll do

 

  • Collaborate with our product managers and engineers to understand the data schema, build new structures, dimensions and data infrastructure.
  • Write lots of SQL, stored procedures, scripts, ETL and streams using best practices, design patterns, and frameworks to make your solutions relevant today and into the foreseeable future.
  • Continually optimize data movement, storage and access.
  • Build quality "back-end" solutions that prepare for growth in both data volume and concurrent usage ensuring automation and excellent monitoring.
  • Perform exploratory source data analysis, including ad-hoc SQL queries, to proactively understand the source data models, and to find and expose data quality problems or data that violate assumptions and business rules, and may cause unexpected output in the developed solution.
  • Effectively leverage automated data profiling tools when available. Consistently deliver quality SQL solutions and ETL and/or streams while documented designs and unit test plans.
  • Participate in design sessions with your team members, coming up with the optimum technical solution that not only meets the business requirements, but does so with performance, scalability, and maintainability in mind.
  • Troubleshoot any production data issues. Bugs can bite even the best of us. But when you squash a bug, you’ll implement an automated test for it so it will never come back to haunt us again.
  • Deliver on your commitments. Because you’re accountable, everyone on the team has confidence that at the end of each two-week sprint, the tasks you’ve been assigned meet the team’s definition of done.
  • Innovate. There’s always something we can improve upon, whether it be process or tools or technology choices. Maybe a Slack bot ? If you can dream it, you get to build it.
  • If you’re senior level, you’ll actively drive code review, architecture choices, mentoring of other engineers and owning a large slice of our tech.

Qualifications

What to bring

 

  • Bachelor’s degree or equivalent experience in software engineering.
  • Experience with the latest MSSQL version, an expert level of experience with SQL, stored procedures and scripts.
  • Strong knowledge of KPI/Metrics per business process.
  • You love to automate all the things, having worked in continuous delivery environments that automatically compile, test, and deploy the application every time code is committed into the git repo, using tools like Maven and a continuous integration server like Jenkins or Bamboo.
  • You collaborate with folks in DevOps to come up with ways to make continuous delivery even faster and more efficient across all our environments, including production.
  • You thrive in fast-paced agile environments using software development methodologies like Scrum, SAFE, or Kanban to consistently deliver value to our clients and fans around the world.
  • You’re passionate about building software that matters, since the software you build also helps bring our millions of fans to the experiences they will never forget, the moment they step into that live event.

 

An Extra “Awesome”

 

  • Strong understanding of Dimensional Modeling and Star/Snowflake schema
  • Knowledge/experience with Cassandra, Amazon Redshift
  • Knowledge of Node.Js, Elastic Search and/or Kafka.

 

What’s in it for you

Just like the teams we work with, we team up at Paciolan too! You’ll find espresso machines, basketball hoops, ping pong tables and lots of options for hanging out with your coworkers such as: a running club, soccer club, yoga class, the bar method class, company sponsored events off-site and many more. We have a Starbucks attached to our building for your caffeine fix as well as several restaurants and food trucks nearby, that is, if you missed any of the food that is often ordered in.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed