Description
sql optimization
power bi
data modeling
dax measures
ssrs reporting
mail merge
Employees must avoid any relationship or activity that might impair, or even appear to impair, their ability to make objective and fair decisions when performing their jobs. To avoid conflicts of interest, employees are prohibited from performing any services for clients or perceived clients during nonworking time that are normally performed by ORC, including the sale of real estate.
- 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
- Is able design, develop, and optimize scalable, secure, and high-performance data solutions to serve various applications
- Is able to provide indirect support for programming and development initiatives as needed.
- Develop, optimize, and maintain complex SQL queries to support reporting, analytics, and operational data needs
- Create advanced DAX measures to support KPIs, calculations, and analytical logic
- Ensure Mail Merge solutions dynamically integrate with data sources to support high-volume and personalized messaging
- Design, build, and maintain Mail Merge templates for communications, notifications, and operational correspondence
- Partner with data owners and stakeholders to understand database schemas, relationships, and data integrity requirements
- 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
Requirements
power bi
sql
ssrs
3+ years
problem solving
team player
We’re Looking For Someone Who
Physical Requirements: While performing the duties of this job, the employee is regularly required to clearly communicate and exchange information in person, via phone and email. Substantial repetitive movements of the wrists, hands and/or fingers due to high amounts of computer usage and typing. Expected to spend long spans of time in front of a computer screen. Able to read, understand and interpret department related documents and data. This is a largely sedentary role; however, the employee is occasionally required to move about inside the office to access files, office equipment and to interact with other members of the staff.
Location: Remote (Candidate will have the flexibility to work out of their home office but must reside within the Eastern Time Zone)
- Advanced proficiency in Power BI Desktop, including M Query, DAX, modeling, and visualization best practices.
- Enjoys working on a small development team and thrives in collaborative settings such as peer programming sessions
- Is a team-first player who remains positive when asked to take on tasks that indirectly support programming projects
- Is flexible and resourceful, with the ability to adopt new technologies quickly
- Legally authorized to work in the United States without sponsorship/visa
- Design intuitive, interactive Power BI dashboards and visualizations aligned with business goals
- 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
- Hands-on experience with SSRS or Power BI Report Builder for operational reporting.
- Minimum of (3) three years of experience developing BI reporting solution
- Ability to create and maintain Mail Merge templates in Word or similar tools.
- Proven experience writing complex SQL queries across relational database platforms.
- Has strong problem-solving skills and a willingness to dive deep into technical challenges
- Communicates effectively with strong verbal and written skills, and can collaborate seamlessly with both technical and non-technical colleagues
Benefits
Right of Way is where infrastructure meets innovation—shaping roads, utilities, and communities for the future. At ORC, we offer more than a job—we offer purpose, stability, and growth. You’ll join a team that values collaboration, workplace flexibility, and long-term opportunity.
Bonus Points if you have experience with data warehouses, specifically Snowflake.
Our job titles may span more than one career level. Compensation for this position is dependent upon many factors, such as training, transferable skills, work experience, business needs, and market demands. The base pay range is subject to change and may be modified in the future. This role may also be eligible for benefits and employee travel reimbursements.
Relocation and per diem are not provided
- Paid time off, sick time, and holidays
- 401(k) with company match and disability coverage
- Tuition reimbursement and professional training
- Recognition programs and growth opportunities
- Health, dental, and vision benefits
- Competitive base pay: $90,000-$100,000 per year
- Free Calm membership for you and up to five others
Training + Development
Information not given or found
