Analytics Architect

Orion Groups; Fort Worth, Town of Texas (TX, WI); Hybrid; USD 84,000 - 140,000; Full time

Job summary

Orion Groups in McKinney, Texas, seeks an Analytics Architect in the Dallas area to lead the development and delivery of business intelligence solutions, with a focus on drafting reports and dashboards using MS Fabric, MicroStrategy, BO, and other enterprise reporting tools.

This opportunity involves translating business requirements into effective BI solutions for an enterprise health system in the Dallas area. The role offers hybrid work in Dallas, Texas, and a salary of $130,000–$140,000.

Qualifications

• 10+ years of BI development experience in an enterprise environment.
• Strong technical skills with MS Fabric, MicroStrategy, and BO; data modeling proficiency.
• Experience delivering end-to-end BI and analytics solutions, including requirements gathering and deployment.

Responsibilities

• Help maintain data integrity and deliver insights to support decisions.
• Deliver reporting and analytics solutions, including dashboards and metrics from multiple sources.
• Engage stakeholders to clarify needs, ensure data quality, and address data issues.
• Design, build, test, deploy and maintain complex BI solutions using MS Fabric, Power BI, Power Automate, Google BigQuery, SQL.
• Support BI architecture, governance, and continuous improvement with design standards and documentation.

Skills

BI development

Data modeling

SQL

Power BI

MS Fabric

Education

Bachelor's degree in Business, Accounting, Information Systems, or Engineering

Tools

MS Fabric

MicroStrategy

BusinessObjects

Google BigQuery

Power Automate

Power BI

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 an Analytics Architect, in the Dallas area, to lead the development and delivery of business intelligence solutions, with a focus on designing and implementing reports and dashboards using MS Fabric, MicroStrategy, BusinessObjects (BO), and other enterprise reporting tools. This opportunity involves translating business requirements into effective BI solutions for an enterprise health system in the Dallas area.

OPPORTUNITY

Direct Hire; Hybrid in Dallas, Texas (U.S. -- Central Time Zone)

SALARY

$130,000 -- $140,000

KEY RESPONSIBILITIES

• Help maintain the consistency and integrity of reported data, work with stakeholders to define reporting requirements, and deliver analytical insights to support strategic and operational decisions.
• Deliver reporting and analytics solutions (40%) -- Develop, maintain, and deliver timely and accurate scheduled reporting, dashboards, metrics, and analytical solutions. Integrate and summarize data from multiple sources to provide actionable insights aligned with business requirements.
• Partner with stakeholders and ensure data quality (20%) -- Independently engage business stakeholders to clarify reporting and analytical needs, define requirements, and ensure solutions address the intended business purpose. Validate data for accuracy, integrity, and security; identify anomalies and perform root-cause analysis to resolve data issues.
• Develop BI solutions and ad hoc analytics (30%) -- Design, build, test, deploy, and maintain complex BI solutions and business-unit-specific analyses using MS Fabric, Power BI, Power Automate, Google BigQuery, SQL, and other enterprise reporting tools. Provide analytical recommendations and identify opportunities to improve reporting, data processes, and business insights.
• Support BI architecture, governance, and continuous improvement (10%) -- Contribute to BI solution architecture and ensure established design standards, governance requirements, documentation practices, and internal processes are followed. Stay current with emerging BI technologies and practices and apply relevant innovations to improve reporting and analytics capabilities.

KEY EXPERIENCE

• 10+ years of development experience of Design, develop, and implementing solutions using BI tools in an enterprise environment.
• Technical skills in MS Fabric, MicroStrategy, BO, data modeling, and related technologies.
• Experience delivering end-to-end BI and analytics solutions, including requirements gathering, solution design, development, testing, deployment, and ongoing support.
• Hands-on experience with enterprise BI and data technologies, including MS Fabric, Power BI, Power Automate, Google BigQuery, SQL, or comparable reporting and analytics platforms.
• Advanced experience with SQL and relational databases, including querying, integrating, analyzing, and troubleshooting complex datasets.
• Experience applying data quality, validation, security, governance, and documentation practices within reporting and analytics environments.
• Experience analyzing complex data structures, relationships, dependencies, and data flows to identify issues and opportunities for improvement.

EDUCATION

• Bachelor's degree in Business, Accounting, Information Systems, or Engineering

INTERVIEW PROCESS

• 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]