Data Engineer

  • Full-time

Company Description

We are founded on a culture that is passionate about transforming the way the world acquires talent by delivering client-focused solutions that make a difference for businesses worldwide. From refining how businesses manage their contingent workforce to strengthening employer brands to recruit top talent, our integrated solutions drive business results.

As an industry leader, we draw upon decades of experience to design innovative tools, products and processes. We develop competitive practices that position organizations for growth and we deliver the insight needed to succeed in today's global marketplace.

As a workplace, we focus on relationships – with each other, our clients and our candidates. In fact serving others is one of our core values. We support open communication and recognize that giving constructive criticism can be even harder than receiving it. We appreciate the fearless and the passionate, who force us to be better. Everything we do sits on a pillar of diversity - diverse perspectives, backgrounds and ideas drive innovation and make us successful.

See what it’s like to work at AGS by searching #LifeAtAGS on any social network.

Job Description

We’re looking for a data engineer to join our team and help us mature our analytical capabilities by modelling our most important business processes and creating useful data models in our data warehouse.

You’ll be able to make a big impact almost immediately with some quick wins and you will have the opportunity to own solutions end-to-end with a lot of autonomy. We’ll support your growth and actively look to help you develop your technical skills, ensure you’re doing work you enjoy, and make sure you’re advancing your career.

We recently completed setting up our overall data infrastructure / stack for analytics, and now is a fantastic time to join the company in this role. We leverage Fivetran to ingest data from various data sources into Redshift which functions as our data lake. We then transform the loaded data using DBT and materialize our data models back into our Redshift cluster to create our data warehouse.

We are at the very beginning of a super exciting stage of our team’s journey, we expect to grow rapidly and for you to grow with us, and we can’t wait to talk to you about the job in more detail.

  • You will partner deeply with various business teams as an analyst to understand their processes / analytical needs, help them define potential solutions, and build data products to support and enable them
  • You will be responsible for designing conceptual data models and implementing them in the data warehouse (e.g. facts / dimensions / metrics)
  • You will work with our team of software engineers to help guide data models for the application database, profile and optimize critical application queries, and support in-app reporting by writing stored procedures. This is something you will grow into as you become more knowledgeable about both the industry and the application database
  •  You may be asked to do some ad-hoc reporting / analytics, build basic dashboards, help with data pipelines for machine learning projects, etc. To be clear, your primary function (~80%+ of your time) is in defining and implementing useful data models, but this is a startup, so you should be comfortable wearing multiple hats as needed while the team grows

Required Skills/Competencies

  • You are an excellent communicator / listener, able to bridge the gap between technical and non-technical teams. You have a curious nature, a strong desire to learn how business processes work, and a passion for solving real world problems that can drive positive business results. Prior experience in some sort of business / data analyst role would be great.
  • You know how to model real world phenomena in analytically useful ways. You should be familiar with the Kimball methodology and have practical experience building data models / data warehouses. We follow an extract, load, transform methodology and leverage DBT framework for creating data models – prior experience with this is not required, but you must have actually designed and implemented data models in the past using some framework / tooling.
  • You are comfortable owning solutions end-to-end and making things happen. We are hiring more for aptitude than prior experience, but we’re looking for someone who doesn’t particularly love bureaucracy and prior experience in early stage startups is a positive signal to us
  • Bonus points for understanding data structure / algorithms and practical experience writing highly performant code in languages like Java, Scala, Kotlin, Python, C, C++, Go, etc.

Qualifications

  • You should have years of experience writing SQL for analytical purposes with a strong understanding of how databases work and how to tune queries to make them efficient.
  • You have some data analysis experience, able to understand stakeholder problems, find and pull relevant data, and answer difficult questions using queries, visualizations, statistical methods, etc. Relevant technologies might include SQL, Pandas, R / Tidyverse, Excel, PowerBI / Tableau, etc.
  • You have some experience with software engineering, particularly with git flows, writing unit tests, CI/CD for data pipelines, and monitoring production environments. If you don’t know this stuff we will teach you as needed, but it’s important that you understand you are producing deliverables used in production environments and we care a lot about quality and having good processes / high standards to support this

Additional Information

AGS is an Equal Opportunity/Affirmative Action Employer (M/F/Disability/Veterans). We will consider all applications without regard to race, gender, sexual orientation, gender identity, age, color, religion, national origin, veteran status, disability, genetic information or any other status protected by applicable law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to disability, please call 844-604-7059 or email [email protected].

Privacy Policy