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 data modeling.
- Possesses experience in designing and implementing ETL/ELT data pipelines.
- Has proven experience with transactional databases (preferably SQL Server).
- Demonstrates a good understanding of transactional databases and how they work (ACID properties, Isolation Levels, Concurrency Control, etc).
- Utilizes advanced SQL skills, and is capable of writing and optimizing complex queries.
- Has hands-on experience with AWS.
- Has competence in programming with C#.
- Preferably has experience with Apache Kafka, Redshift or Snowflake and CDC patterns.
#LI-AP1
#LI-Onsite
#LI-Hybrid
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.
Top Skills
What We Do
Orion is a wealthtech powerhouse delivering an integrated suite of fully connected, disruptive technology and investment solutions on an open architecture platform.
Our tech-enabled fiduciary process empowers financial advisors to seamlessly attract new clients, connect planning goals to investment strategies, and help achieve each investor’s unique definition of financial success.
Orion is committed to understanding the needs of growth-minded advisors which directs our M&A and product development strategies. We’ve made it our goal to seamlessly connect each stage of the advisor-client relationship with solutions that are fully connected yet provide the flexibility and choice to be adopted in its entirety or as stand-alone components that complement existing capabilities.
Combined, our brand entities, Orion Advisor Tech, Orion Portfolio Solutions, Brinker Capital Investments, Redtail Technology, and TownSquare Capital, create a complete offering that empowers firms to broaden their offering, increase efficiency, and spur growth.
Supporting over 5 million technology accounts and thousands of independent advisory firms, Orion is the platform of choice for all growth-focused advisory firms looking to strengthen their client relationships, gain a competitive edge in a crowded marketplace, and build strong, profitable businesses
• • •
Orion is committed to having a diverse and inclusive workforce. Individuals seeking employment at Orion are considered without regards to age, color, disability status, ethnicity, genetic information, national origin, race, religion, gender, sexual orientation, gender identification, veteran status or any other factor protected by law.
Our Social Media Disclosure: https://bit.ly/3oTnWu7
