Apply on Employer Site

ORC · 2 weeks ago

Business Intelligence Reporting Analyst - Remote

United States

Full-time

Remote

Mid Level

$90K/yr - $100K/yr

3+ years exp

ORC is a respected right-of-way acquisition firm offering purpose, stability, and growth. They are seeking a Business Intelligence Reporting Analyst to develop and maintain complex SQL queries, create interactive Power BI dashboards, and support reporting and analytics needs.

Real Estate

Culture & Values

No H1B

Responsibilities

Develop, optimize, and maintain complex SQL queries to support reporting, analytics, and operational data needs

Partner with data owners and stakeholders to understand database schemas, relationships, and data integrity requirements

Troubleshoot and resolve SQL query performance issues using best-practice optimization techniques

Build robust Power BI data models using Power BI Desktop, including data transformation with Power Query (M) and relationship modeling

Design intuitive, interactive Power BI dashboards and visualizations aligned with business goals

Create advanced DAX measures to support KPIs, calculations, and analytical logic

Ensure semantic model accuracy, usability, performance, and scalability

Develop and maintain SSRS and Power BI Report Builder paginated reports, including detailed tabular formats for operational and compliance reporting

Transform queried datasets into well-structured reports with clear formatting, parameters, and filtering capabilities

Migrate, modernize, and enhance existing reports as business needs evolve

Design, build, and maintain Mail Merge templates for communications, notifications, and operational correspondence

Ensure Mail Merge solutions dynamically integrate with data sources to support high-volume and personalized messaging

Qualification

SQLPower BIDAXSSRSData analysisProblem-solvingCollaborationCommunicationFlexibility

Required

Minimum of (3) three years of experience developing BI reporting solution

Proven experience writing complex SQL queries across relational database platforms

Advanced proficiency in Power BI Desktop, including M Query, DAX, modeling, and visualization best practices

Hands-on experience with SSRS or Power BI Report Builder for operational reporting

Ability to create and maintain Mail Merge templates in Word or similar tools

Strong analytical mindset with the ability to work with large datasets and distill insights for technical and non-technical audiences

Must own an iOS or Android smartphone to access ORC systems

Legally authorized to work in the United States without sponsorship/visa

Preferred

Experience with data warehouses, specifically Snowflake

Benefits

Health, dental, and vision benefits

401(k) with company match and disability coverage

Paid time off, sick time, and holidays

Tuition reimbursement and professional training

Recognition programs and growth opportunities

Free Calm membership for you and up to five others

Company

ORC

Since 1969, ORC has been a leading ROW service provider for public agencies, utilities, and energy clients, driving responsible infrastructure progress nationwide.

Founded in 1969

Charlotte, North Carolina, USA

201-500 employees