Location: Remote - East Coast (Candidate will have the flexibility to work out of their home office but must reside within the Eastern Time Zone. Candidate will be expected to travel to the Charlotte, NC office at least 2-3 times a year)
Schedule: Full-time, Exempt

Why Join ORC?
The Right Work. The Right People. The Right Culture.
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.

What We Offer

Competitive base pay: $100,000-$125,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

What You’ll Do

Design and Develop: Architect, build, and optimize Snowflake data models, schemas, and pipelines (4+ years of hands-on experience with Snowflake required.)
Data Warehousing: Implement and enforce best practices for data warehousing, including metadata management and data modeling
Automation & Orchestration: Automate workflows using DBT and other orchestration tools
SQL Development: Write, test, and optimize complex SQL and T-SQL queries, stored procedures, and Snow SQL scripts for data extraction and transformation
AI Integration: Design and implement Snowflake semantic models for integration with Snowflake Cortex Analyst, Document AI, and other AI tools
ETL & Data Integration: Build and maintain robust ETL processes to integrate structured and unstructured data from multiple sources
Reporting: Develop complex reports and dashboards using analytics and BI tools such as Power BI to meet business requirements
Performance Optimization: Analyze and tune query performance leveraging Snowflake Query Profiler, micro-partitioning, and optimizer insights
Security & Compliance: Implement identity and access management, row-level security, data masking, encryption, and other key security controls in compliance with enterprise and industry standards
Collaboration: Work cross-functionally with accounting, engineering, analytics, and other departments to analyze processes and determine requirements
Troubleshooting: Proactively identify and resolve data ingestion, transformation, and performance issues
Documentation & Governance: Maintain comprehensive documentation of data architectures, solutions, and operational procedures
Collaboration Tools: Use platforms such as Jira and Zendesk for organization, task tracking, and project management

We’re Looking for Someone Who

Has strong problem-solving skills and a willingness to dive deep into technical challenges
Has deep expertise in Snowflake, SQL, and a solid understanding of data warehousing principles
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.
Is flexible and resourceful, with the ability to adopt new technologies quickly
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
Balances technical innovation with cost and resource constraints
Communicates effectively with strong verbal and written skills, and can collaborate seamlessly with both technical and non-technical colleagues

Minimum Requirements

Minimum of (5) five years of hands-on experience with data warehousing, ETL/ELT pipelines, and CI/CD automation within modern cloud environments
Minimum of (4) four years of hands-on experience with Snowflake
Strong proficiency in SQL
Proficiency with Microsoft Office Suite (Outlook, Word, Excel) and electronic databases Must own an iOS or Android smartphone to access ORC systems

Bonus Points if you have experience as a data analyst in financial/accounting environments.

Relocation and per diem are not provided

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

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.

ORC is one of America’s most respected right-of-way acquisition firms. Our services not only include providing outsourced right-of-way services to public agencies, but also electric transmission, oil and gas pipelines, fiber optic, and sewer and water infrastructure. We are excited to be part of the renewable energy forefront for wind and solar projects.

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.

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.

ORC Corp - National 00

Latest Jobs

Data Engineer/Developer