Business Intelligence Analyst

Orion Groups; United States; Hybrid; USD 85,000 - 125,000; Full time

Job summary

Orion Groups in McKinney, Texas, is seeking a Business Intelligence Analyst to independently lead projects spanning revenue cycle operations reporting, pre-integration client reporting, and multi-division analytics. You will develop and streamline performance reports to help product lines make objective, data-driven decisions.

The role requires strong ETL, SQL, and data visualization skills, with experience in tools such as Power BI, Tableau, Alteryx, and MS SQL Server.

Qualifications

• 5+ years' experience working with ETL technology.
• Expert data gathering, analytical and data visualization skills.
• Experience presenting to product lines and executives.
• Advanced knowledge of relational DBMS and SQL.

Responsibilities

• Independently leads reporting projects across multiple product lines.
• Develops and streamlines performance reports to aid objective decisions.
• Performs high-complexity adhoc reporting.
• Acts as SME for multiple product lines and mentors others.

Skills

ETL

Data visualization

SQL

SQL Server

MySQL

Tableau

Power BI

Alteryx

MS Excel

Education

4-year college degree in Business / IS / Engineering

Tools

MS Access

AS/400

Showcase

Job description

ORION GROUPS is a professional services firm based in McKinney, Texas that provides experienced consultants to key organizations across the United States. We focus our talent expertise in both the financial and healthcare industries. Our capabilities in technology include application management, enterprise software systems, data strategies, integration, and IT infrastructure. We work diligently to listen and provide value to your unique needs. www.OrionGRPS.com

OVERVIEW

At Orion, we are seeking a Business Intelligence Analyst to independently lead projects related to revenue cycle operations initiative reporting, pre-integration client reporting, emerging client integration reporting and projects requiring expertise across multiple business reporting areas. This opportunity will focus on the development and streamlining of business performance reports that aid operational Product Lines to make objective decisions including improvement opportunities.

OPPORTUNITY

• Direct Hire; Hybrid in Dallas, Texas (U.S. – Central Time Zone)
• Scheduled work from home days: T/Th +1 more day, (M/W) in office

KEY RESPONSIBILITIES

• Independently works with all levels of management and across multiple product lines to determine reporting/project requirements and to research/resolve technical issues with reporting tools and functionality.
• Proactively works with team to create efficiencies in data retrieval and analysis and ensure proper documentation of all reports.
• Interprets data and presents key trends and important findings to product line leaders to help them turn it into actionable insights and improved performance.
• Performs adhoc reporting with high complexity.
• Serves as SME for multiple product lines, owns related processes and leads projects.
• Manages customer’s expectations to ensure timely delivery of needed reporting/projects to clients and various business unit stakeholders.

KEY EXPERIENCE

• 5+ years' experience working with ETL technology
• Expert data gathering, analytical and data visualization skills, including mentorship experience.
• Independent, logical thinker with strategic view of reporting offerings and proven ability to perform detailed data analysis, make recommendations and develop analytical reports and models that provide solutions for client.
• Troubleshooting and QA skills, with ability to research and problem solve complex technical issues independently within a timely fashion including managing projects simultaneously.
• Experienced and comfortable making presentations to product line leaders, Directors and Executive Leadership across multiple product lines.
• Expert knowledge/experience with reporting systems.
• Expert level knowledge of relational database management systems such as MS SQL Server/MySQL, AS/400, Showcase, MS Access including SQL language skills (creating/optimizing queries and stored procedures), including desktop applications (Microsoft Excel, Word, Access and PowerPoint).
• VBA, Alteryx, MicroStrategy, Tableau, Power BI or similar a plus

EDUCATION

• 4-year college degree in Business, Accounting, IS, Engineering OR 7 or more years of related experience Healthcare experience
• Quick turnaround: preliminary interview followed by team interview on phone and Google Meets.
• Typically, one round with the hiring manager, joined by the team (virtual interview), possibly two rounds if necessary.

Orion Groups is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact [e-mail]