Data Engineer
Remote, REMOTE, United States
Applications have closed
Allegis Global Solutions
The world of work has changed. As the leading provider of workforce solutions, we guide companies through a transformative journey to rethink the way work gets done.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 accomodation@allegisglobalsolutions.com.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: CI/CD Data analysis Data pipelines Data warehouse Engineering Excel FiveTran Git Java Machine Learning Pandas Pipelines Power BI Python R Redshift Scala SQL Statistics Tableau
Perks/benefits: Career development Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs