Senior Cloud Data Engineer

About This Opportunity
Join our innovative Cloud Data Team, where we lead the charge in maintaining a robust real-time data streaming platform and managing diverse data targets within AWS, including Redshift, DynamoDB, and OpenSearch. Our platform, architected and built on top of Apache Kafka, replicates nearly 1 billion events daily from thousands of SQL Server databases to multiple cloud data stores, ensuring optimal performance with low latency and high throughput.

We are seeking a seasoned Senior Data Engineer to play a key role in maintaining and monitoring our real-time data streaming platform, integrating new datasets, enhancing features, managing data targets, and crafting complex data queries to fulfill customer needs. This role demands a solid understanding of data engineering, cloud technologies, and large-scale data environments.

For External Candidates
Candidates must work in-office at one of the following locations for at least 3 days per week: Omaha, NE; Sacramento, CA; Hebron, KY.
For Internal Candidates
All internal employees, regardless of their current work arrangement (remote or in-office), are encouraged to apply.

In This Role, You'll Get To:
- Maintain and monitor our data streaming platform to ensure performance, reliability, and data quality.
- Collaborate with other teams to integrate new datasets.
- Implement new platform features and tools.
- Manage and optimize cloud data targets, ensuring efficient data storage and retrieval.
- Develop and refine SQL queries tailored to customer requirements, ensuring data accuracy and efficiency.

We're Looking For Talent Who:
- Has solid knowledge in data engineering with a strong foundation in data architecture and modeling.
- Possesses experience in designing and implementing ETL/ELT data pipelines.
- Has proven experience with transactional databases (preferably SQL Server) and a good understanding of their operation (ACID properties, Isolation Levels, Concurrency Control, etc.).
- Utilizes advanced SQL skills, capable of writing and optimizing complex queries.
- Has hands-on experience with AWS.
- Demonstrates programming competence in C#.
- Preferably has experience with Apache Kafka, Redshift or Snowflake, and CDC patterns.

Salary Range
$90,784.00 - $140,617.00
The pay listed in this posting indicates the estimated pay at the time of this posting; however, may vary depending on geographic location, job-related knowledge, skills, and experience. In addition, Orion offers a competitive benefits package which includes health, dental, vision, and disability coverage on day one, 401(k) plan with employer match, paid parental leave, pet benefits including pawternity leave and pet insurance, student loan repayment, and more.

About Us
As One-Orion, we accomplish our best work by being personally accountable to each other and the clients we serve. We are creating a welcoming environment where everyone is respected, valued, and heard. Our willingness to disrupt ourselves and the industry ensures we stay ahead of client expectations. Thinking differently is in our DNA – we innovate, push boundaries, reject the status quo, and relentlessly pursue transformative outcomes. It is our collective will to win that drives Orion’s success and powers success for our clients and everyone at Orion.