Data Engineer

Job Description

Apiphani is a technology-enabled managed services company dedicated to redefining what it means to support mission-critical enterprise workloads. We're a small but rapidly growing company, which means there's lots of room for growth and learning opportunities abound!

Apiphani is dedicated to creating a diverse and inclusive work environment for all as a fundamental component of our business. Diversity and inclusion are the bedrock of creativity and innovation. Without diversity of experience and thought, we would fail to progress as a company and as a team. Apiphani strives to foster an environment of belonging, where every employee feels respected, valued, and empowered. We embrace the unique experiences, perspective, and cultural background, which only you can bring to the table. Data Engineer

Job DescriptionAn experienced data engineer using various methods to transform raw data into useful data systems. You will be responsible for designing, developing, testing, and deploying data pipelines, data warehouses, data lakes, and data products that support business needs. You will also work closely with data analysts, data scientists, and other stakeholders to ensure data quality, reliability, and availability. For example, you will develop and configure programs and jobs for data ingestion, transformation, data enhancement, efficient DB design and storage, and accessible by data end consumers. Overall, you'll strive for efficiency by aligning data systems with business goals.In this data engineering position, you should have strong data analysis skills with the ability to combine, correlate and resolve data conflicts from different sources. You will need skills and experience with several programming languages and knowledge of machine learning methods is a plus.Job Duties

Design, build, and optimize data pipelines using various tools and technologies such as SQL, Python, AppFlow, Glue, etc.

Implement data quality checks, data validation, and data governance processes to ensure data accuracy and consistency.

Develop and maintain data models, schemas, and metadata to support data analysis and reporting.

Create and manage data warehouses, data lakes, and data marts using cloud platforms such as AWS, Azure, or GCP.

Collaborate with data analysts, data scientists, and other business users to understand their data needs and provide data solutions.

Collaborate with technical, including DevOps, engineering, and compliance, to ensure seamless cloud implementation and adherence to best practices.

Develop data and cloud architecture documentation, including diagrams, guidelines, and best practices for reference and knowledge sharing.

Troubleshoot and resolve data pipeline issues, ensuring minimal downtime and data integrity.

Optimize data pipelines for performance, reliability, and data quality, utilizing best practices in data engineering.

Build algorithms and prototypes that combine raw information from different sources.

Document solutions and provide DataOps support for production data pipelines.

Required Skills

Bachelor's degree in Computer Science, Engineering, Mathematics, or related field, or equivalent work experience.

3+ years of experience in data engineering or related roles.

Proficient in SQL and at least one programming language such as Python, etc.

Experience with data pipeline orchestration and scheduling tools such as AWS Glue, Lambda, etc.

Experience with cloud-based data platforms and services in AWS. Azure, or GCP are a plus..

Experience with data warehouse and data lake design and architecture.

Experience with data quality, data testing, and data governance methodologies and tools.

Strong analytical and problem-solving skills, attention to detail, and communication skills.

Ability to work independently and collaboratively in a fast-paced environment.

Experience working with a modern data catalog such as Alation, Collibra, etc. is a plus.

Ability to prepare data for prescriptive and predictive modeling is a plus.

Experience working with AI technologies such as Amazon Q is a plus.

Base Salary

$30,000—$36,000 USD

Company Benefits

Medical/dental/vision - 100% paid for employees, 50% paid for dependents

Life and disability - 100% paid for employees

401K - 3% match, no employee contribution necessary

Education and tuition reimbursement - up to $50K annually

Employee Stock Options Plan

Accident, critical illness, hospital indemnity benefits offered through our providers

Employee Assistance Program

Legal assistance

Unlimited PTO

Full-time