Business Intelligence Reporting Analyst - Remote

Business Intelligence Reporting Analyst - Remote

Base pay range: $90,000–$100,000 per year.

Location:

Remote – candidate must reside within the Eastern Time Zone.

Schedule:

Full-time, Exempt.

• Competitive base pay: $90,000–$100,000 per year.
• 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.

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

• Minimum of 3 years of experience developing BI reporting solutions.
• 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.

Experience with data warehouses, specifically Snowflake.

Make your mark on projects that matter. Apply now to join a supportive team that invests in your future.

ORC is an equal opportunity employer; all qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, or disability.