hero

Accelerate your career.

Explore opportunities across TA's portfolio

Senior BI Data Engineer

Orion Advisor Technology

Orion Advisor Technology

Data Science
Multiple locations
Posted on Saturday, January 27, 2024

About this Opportunity:

As a Senior BI Data Engineer, you will work on an Agile team building data pipelines that drive analytic solutions. These solutions will generate insights from the data, enabling the organization to advance the data-driven decision-making capabilities for internal and external customers. This role requires a deep understanding of data architecture, data engineering, data analysis and reporting. The ideal candidate is a skilled data engineer with experience creating data products supporting analytic solutions. As we continue to evolve and live our Orion values, we are looking for someone to grow with us.

We can consider candidates for this position who are able to accommodate a hybrid work schedule and are close to one of our following offices: Omaha, NE, Berwyn, PA, Sacramento, CA, Hebron, KY, Chandler, AZ, Provo, UT, or Idaho Falls, ID.

In this role, you'll get to:

  • Own data ingestion projects from requirement gathering thru implementation

  • Solution design using Microsoft Azure services and related tools

  • Design of enterprise data models and Data Warehouse solutions

  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

  • Create specification of ETL pipelines, data integration and data migration design

  • Work within a project management/agile delivery methodology in a leading role as part of a wider team

  • Participate in on call rotation to ensure critical nightly loads complete

  • Maintain a high level of technical knowledge in all applicable programming languages and database formats

We're looking for talent who:

  • Has strong understanding of design techniques for ETL, Data Marts and Data Warehouses with dimensional models

  • Has ability to do research and problem solve autonomously

  • Has understanding of data management concepts

  • Has understanding of the importance of governance and security rules when handling data

  • Possess ability to convert business problems/challenges into technical solutions

  • Has bachelor’s degree or equivalent work experience in Computer Science, Management Information Systems (MIS), Information Technology (IT), or related field

  • Obtain Orion Industry Certification

  • Has minimum of 5 years of experience developing business intelligence solutions

  • Has hands-on experience delivering solutions using the Azure Data Analytics platform including Azure Databricks, Azure Data Factory and Azure Synapse

  • Has SQL expert, with Strong SQL Server experience

  • Possess proficient with Python for data engineering

  • Has experience with web APIs and data integration across internal and external systems

  • Preferably has experience with dashboarding tools such as Sisense, Tableau or PowerBI; Sisense

  • Owns and manages relationships with stakeholders directly and work effectively with people at all levels in an organization#LI-AP1

#LI-AP1

#LI-Onsite

#LI-Hybrid

Salary Range:

$103,584.00 - $162,615.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.