Company Overview:
Orrum Clinical Analytics (OCA) was born from a commitment to patient quality and safety by leaders in perfusion and extracorporeal life support services. OCA leverages technology to revolutionize patient care by transforming clinical data into actionable knowledge. As we continue to expand our data infrastructure and analytics capabilities, we are seeking a skilled and experienced senior data engineer to join our dynamic team.
Job Description:
As an analytics engineer at OCA, you will play a crucial role in building and maintaining our infrastructure to support business intelligence, reporting, and analytics needs. You will work closely with our cross-functional teams to ensure the availability, reliability, and efficiency of our data pipelines and data models. Your expertise in SQL and data modeling will be essential in crafting robust and scalable solutions to drive data insights and decision-making. Compensation for this position will be based on the candidate's qualifications and relevant experience. This position is eligible for remote work with travel. Preference will be given to candidates in the Detroit and Atlanta metro areas.
Responsibilities:
- Model and transform raw data in Snowflake using dbt to ensure quality, consistency, and readiness for analytics.
- Collaborate with external data teams to develop new data streams for ingestion, modeling, and analysis.
- Optimize and fine-tune data pipelines and query performance to enhance efficiency and reduce latency.
- Implement and maintain monitoring, logging, and alerting systems for proactive detection and resolution of data pipeline issues.
- Ensure data security, integrity, and compliance with relevant regulations.
- Establish and maintain metadata repositories to track data lineage, definitions, and usage, supporting robust data governance.
- Manage schema changes and versioning to support evolving data needs.
- Stay current with industry trends and best practices in data engineering and analytics technologies.
Requirements:
- Proven experience as a Data/Analytics Engineer with 4+ years of hands-on experience in writing SQL and developing data models in a data warehousing environment.
- Expert SQL skills for data modeling and query optimization.
- Extensive experience with data modeling in Snowflake.
- Proficiency in using dbt for data transformation and pipeline management.
- Strong understanding of data warehousing concepts and best practices.
- Experience with data pipeline monitoring, logging, and alerting.
- Knowledge of data security and compliance requirements.
- Ability to manage schema changes and version control.
- Proven experience in Agile methodologies, including Scrum or Kanban.
- Excellent documentation and data governance skills.
- Continuous learner with an eye on industry trends and new technologies.
Preferred Skills (a plus):
- Experience with dbt (Data Build Tool) and its implementation for data transformation and modeling.
- Experience with Snowflake data warehouse and its features.
- Proficiency in Python
- Proficiency in Github including Github Actions and CI/CD.
- 6+ years of hands-on experience in writing SQL and developing data models in a data warehousing environment
- Experience leading data engineering projects from conception to deployment, including requirements gathering, architecture design, development, testing, and deployment.
Location:
This is a flexible location position, allowing for remote work. However, preference will be given to candidates based in the Detroit or Atlanta areas.
Benefits:
At OCA, we believe in fostering a positive work environment that encourages innovation, collaboration, and professional growth. As part of our team, you will enjoy a competitive salary, comprehensive benefits package, flexible working hours, and opportunities to participate in challenging projects that make a real impact.
How to Apply:
If you are a talented and driven Analytics Engineer looking for an exciting opportunity to contribute to a forward-thinking organization, please submit your resume and a cover letter detailing your relevant experience and achievements. We are excited to review your application and explore the potential of having you on our team.
OCA is an equal opportunity employer and encourages candidates from diverse backgrounds to apply.
Note: This job description is intended to provide a general overview of the position and its responsibilities. It is not an exhaustive list of all duties, responsibilities, or qualifications associated with the role.
Job Type: Full-time
Pay: $85,000.00 - $135,000.00 per year
Benefits:
- 401(k)
- 401(k) 4% Match
- 401(k) matching
- Dental insurance
- Health insurance
- On-site gym
- Paid holidays
- Paid time off
- Work from home
Compensation package:
Experience level:
Schedule:
- 8 hour shift
- Monday to Friday
Ability to Relocate:
- Plymouth, MI 48170: Relocate before starting work (Required)
Work Location: In person