Sr. Data Engineer

Vivid Seats Chicago , IL 60602

Posted 3 months ago

The Opportunity:

As a Sr. Data Engineer, you will:

  • Have a holistic view of Vivid Seats overall data architecture and understand how the individual parts are interconnected

  • Create technical designs while thinking of data governance, data quality and security. and get buy in from peers

  • Model and assist in designing our transactional data stores while partnering with our engineering teams.

  • Build databases and tooling around data stores for use by our production systems.

  • Design the life cycle of the data transformation working taking into account needs from our BI team, data governance, data quality and security. This approach will include batch processing and streaming of data feeds.

  • Interact with technical and non-technical business units within the company

  • Stay up to date on new and emerging technologies, planning accordingly to incorporate valuable concepts to enhance our data schema and capabilities.

  • Guide junior data engineers

To be successful, you'll need:

  • A proven career in data modeling for data platforms that support transactional systems and data warehousing

  • Deep expertise with 3rd Normal Form Modeling, Star Schema Modeling, Modeling tools, Data Dictionary tools, and Data Governance

  • Expert knowledge of a relational database platform such as MySQL, Postgres, Oracle or SQL Server

  • The ability to create, gather input on, and own the implementation of a design strategy

  • Familiarity with data migration tools such as Liquibase or Flyway

  • Experience with one of the newer data warehouse technologies such as Redshift, Big Query or Snowflake

  • Cloud experience with either GCP, AWS or Azure and experience running data platforms within a cloud environment

  • ETL Pipeline and tooling experience

  • A willingness to being in an on-call rotation

Additional Experience of Interest:

  • Coding and scripting experience using Java, Python, or Bash

  • Experience with Configuration as Code tools such as Ansible, Terraform etc.

  • Experience with continuous integration, testing, and deployment using tools such as Git or Jenkins

What We Offer:

Vivid Seats is the largest independent online ticket marketplace, sending tens of millions of fans to live events. Experiences Matter- which is why we continue to grow year over year. Working at Vivid Seats provides an opportunity to scale our best in class platform, allowing our fans to sit closer and see more.

At Vivid Seats, you will have the opportunity to work with the flexibility and speed of a startup; while operating at massive, profitable scale. We keep our teams lean, allowing each and every employee direct accountability to creating a positive ticket buying experience. We are relentless and move quickly to release new features and content to our applications. Good ideas are heard and implemented, and hard work rewarded. Being a part of our team means having the ability to drive impact and own the innovation that connects our tens of millions of unique monthly users to the memorable experiences that only live events create.

We are passionate about creating memorable experiences for our fans and the best in class experience for our employees. Vivid Seats offers competitive compensation levels, individual and team-based bonus opportunities, generous benefits package and Flex PTO policy plus a variety of workplace perks. The most exciting one: We offer our employees $100 worth of credits each month to spend on Vivid Seats tickets along with promotional discounts. At the heart of it, we are all fans of great live events. We want to help you get there more often.

Location:
111 N Canal Suite #800

Chicago, IL 60606

#LI-TA1


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Data Engineer

Echo Global Logistics

Posted 2 months ago

VIEW JOBS 8/22/2019 12:00:00 AM 2019-11-20T00:00 Position Purpose As a Senior Data Engineer on the Echo Global Logistics team, you will contribute to database management of large scale web-based applications through the use of SQL, C#, and .NET tools. These technologies enable Echo's business while supporting architectural vision of quality, scalability, performance and function. Our proprietary software is created with the goal to simplify transportation for our customers and carriers, and is one of our largest competitive advantages in an ever growing market. Echo Global Logistics has recently been ranked the third largest digital company by employee size in Chicago and we are continuing to see increased growth in virtually all of our technical teams. Additionally, we have been ranked as the #1 Inbound Logistics 3PL for 2017 and look forward to speaking with you further about our team! Essential Position Functions You... * See technology as a passion, not something you just do between 9-5 * Possess the ability to create new solutions; we operate on a web based platform and constantly facing unchartered waters * Possess strong fundamentals within coding technologies and a willingness to wear several hats when called upon * Do not wait for something to break; find a problem before it becomes one and constantly aiming to improve * Having a willingness to vocalize these ideas and pick yourself up if you get knocked down We… * Value passionate technologists, go-getters, and people who never stop seeking ways to improve existing technology * Have a high focus on career development and the runway to get you there * Work hard, period * Offer competitive compensation, benefits, 401k, challenging projects, company wide events, coworkers and leaders who will push you to get better, a sense of community not found anywhere else Responsibilities: Data Engineer's work in conjunction with Software Engineers, DBA's, Business Analysts, Quality Assurance and business owners * Serve as a member of a data team that solves complex challenges and builds working database solutions using SQL Server, T-SQL, SSIS, stored procedures, views, user-defined functions, and table functions * Develop solutions and contributing to development, leveraging Object-Oriented programming techniques (.Net), Software Development Lifecycles, Unit Test Techniques, and Debugging/Analytical Techniques. * Collaborate with the team to develop database structures that fit into the overall architecture of the systems under development. * Code, install, optimize, and debug database queries and stored procedures using appropriate tools and editors. * Perform code reviews and provide feedback in a timely manner. * Promote collective code ownership for everyone to have visibility into the feature codebase. * Present technical ideas and concepts in business-friendly language. * Provide recommendations, analysis, and evaluation of systems improvements, optimization, development, and maintenance efforts, including capacity planning. * Identify and correct performance bottlenecks related to SQL code. * Support timely production releases and adherence to release activities. * Contribute to data retention strategy. Position Requirements * 1-3 years in commercial-grade business applications environment leveraging the following: * SQL Server, T-SQL, SSIS, stored procedures, user-defined functions and table functions * Managing design risk * 1-3 years leveraging OO programming techniques * Software development lifecycles, Unit test techniques, debugging/analytical techniques What's in it for you? * Help career growth by joining industry leader and continuing to advance Echo web based technologies * Working with an organization with defined market goals, products, customers, revenue, and development teams * Experienced mentors to learn and adopt new practices * Ability to introduce your own views and takes on our product offerings * Work in wide variety of data management * Ability to constantly enhance and improve applications * Have a clearly defined career growth track with enough flexibility to pave your own way All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, status as a qualified individual with a disability, or Vietnam era or other protected veteran. Echo Global Logistics Chicago IL

Sr. Data Engineer

Vivid Seats