Time zones: EST (UTC -5), CST (UTC -6), MST (UTC -7), PST (UTC -8), AKST (UTC -9), HST (UTC -10), GMT (UTC +0), CET (UTC +1), AST (UTC -4), FKST (UTC -3), NST (UTC -3:30)
As a Senior Data Engineer at Aurora Payments, you will play a strategic role in building a best-in-class data architecture. This role will be a non-management lead position responsible for managing all one-off and long-term data requests, while interfacing with internal engineering, IT, and business users.
This role is 100% remote eligible and <5% business travel is possible. Aurora Payments has physical offices located in Phoenix, AZ, Las Vegas, NV, Miami, FL, Atlanta, GA, Wroclaw, Poland, and Ho Chi Minh City, Vietnam and you are welcome (but not required) to work from any of those locations if located nearby.
- Develop and sustain a state-of-the-art data architecture across the organization.
- Compile and manage comprehensive data sets that adhere to both functional and non-functional company needs.
- Engage in the enhancement of internal processes by:
- Implementing automation to replace manual tasks.
- Enhancing the efficiency of data transmission.
- Upgrading our systems to scale effectively and meet growing demands.
- Establish robust systems to streamline the data lifecycle, including extraction, transformation, and loading, utilizing tools such as Python and SQL.
- Craft analytical tools leveraging the data pipeline, delivering key insights into customer growth, operational enhancements, and pivotal business metrics.
- Collaborate closely with leadership and teams across Product, Operations, and Design domains to fulfill the company’s data technical and infrastructural requisites.
- Architecting data pipelines to cleanse, morph, and consolidate diverse data sets.
- Applying best practices in software development to refine our backend infrastructures.
- Creating comprehensive models of data streams, both incoming and outgoing, to enable in-depth organizational analysis.
- Formulating models to provide insights for business strategy inquiries.
- Facilitating interdepartmental communication to align on data requirements and usage.
- 7-10 years of progressive experience with advanced data warehousing and analysis.
- Proficiency with ETL frameworks such as Fivetran.
- Familiarity with relational and NewSQL database technologies (we use numerous Postgres compatible databases including Google Cloud SQL Postgres, AlloyDB, and CochroachDB).
- Expertise in managing data pipelines and workflows.
- Practical experience with cloud services, particularly GCP, and tools like Google BigQuery. We are a BigQuery warehouse shop.
- Skilled in using Python and/or R for data exploration and analysis.
- Proven track record in conducting thorough root cause analysis on data and processes, with the goal of driving business insights and improvements.
- Development of processes that underpin data transformation, establish data structures, and manage dependencies and workloads.
- Analytical prowess with both structured and unstructured data sets, with a history of deriving meaningful insights from complex and disparate data sources.
- Strong project management capabilities and organizational skills.
- Proven experience in collaborating with and supporting cross-functional teams.
- Outstanding problem-solving skills coupled with the ability to communicate effectively.
- Self-motivated, eager to learn, and committed to personal growth and development.
- Advocacy for best practices in the field and a dedication to continual learning.
To apply for this job, please email your details to hr@risewithaurora.com