It's fun to work in a company where people truly BELIEVE in what they're doing!
We're committed to bringing passion and customer focus to the business.
The Role
We are seeking a
Senior Data Engineer to join our team at our Pittsburgh office located in the Strip District (and remote for the time being). This individual should have experience with data systems for operational and analytical purposes, advanced SQL knowledge, and skill in working with complex ETL processes that move millions of data points quickly.
Our Engineers are designing and developing our market-leading security training and assessment software. Our goal is to help organizations teach their employees to secure behavior through interactive web applications, received, and managed by our customers on our proprietary SaaS platform. Our team specifically is responsible for ensuring that our end users and administrator can access their data to gain information and insight into their people-based security risk and plan their mitigation strategy.
The ideal candidate is enthusiastic to work in a fast-paced environment supporting a global SaaS product. As a Senior Data Engineer, you will lend your skillsets to help lead the design and implementation of a key customer-facing component that has high visibility and value within the organization as well as provide subject matter expertise in data modeling and processing to the rest of the organization.
Your day to day
- Work with other data engineers on the system design and delivery of scalable, secure, and supportable enterprise software solutions for our customer-facing platforms
- Participate in our agile work-flow process, including concept development, architectural design, design specification, story decomposition, planning, execution, testing, acceptance, and retrospection
- Build and refine efficient data structures and queries that return information quickly and accurately.
- Work with other development teams to understand and meet the needs of their data utilization.
What You Bring To The Team
- 5+ years of work experience with SQL
- 3+ years of work experience with either MySQL or PostgreSQL
- 3+ years of experience designing, developing, and supporting applications in a cloud environment
- BS/BA in a software-related field
- Experience with large-scale ETL processes, including technologies such as Airflow with Python.
- You should possess advanced knowledge of SQL in either PostgreSQL or MySQL environments (or both).
- Familiarity with AWS is a plus, especially including a subset of the following services RDS, EC2, S3, Data Pipeline, Glue, SNS, Kinesis, Lambda, DynamoDB, EMR, Redshift, and Elasticsearch
- Comfort in working across multiple operating systems, including macOS and Windows
- Comfortable with Git for version control
- Can work independently and thrives with autonomy
Preferred Skills
- Advanced SQL knowledge
- Advanced ETL experience moving data at scale
- Experience designing and deploying applications on Amazon Web Services
- Experience building customer-facing applications at scale
If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!