Senior BI Data Engineer
Orion Advisor Technology
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
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.
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.