Remote Dbt Sql Jobs in Oregon (NOW HIRING)

Description

For the Dev position I'd say the top three technical skills are fluency with SQL and Python, familiarity with team project work via git/source control, familiarity working with Snowflake/web based integration tools (Airflow/Workato/Mulesoft).

Day to day tasks will likely be tasked with a given legacy integration, deconstruct the requirements (since there's no documentation), then rebuild it using Workato following new design principals (pub/sub, API). We have a couple legacy web apps that if we can get to, would be helping to rebuild them within AWS.

Position Details

A candidate for this position will focus on refactoring legacy workflows—transitioning traditional flat-file transfers and batch ETLs into modern, API-driven, pub/sub, and orchestrated integration solutions.

Basic Function

Under limited direction, design, develop, and support complex system integrations, pipelines, web applications, and cloud-based data systems within the district’s enterprise environment. Serve as a technical expert in web application development lifecycle and ETL orchestration. Collaborate with other team members to ensure adherence to data governance standards, and produce reliable and supportable infrastructure aligned with District priorities.

Representative Duties

The classification specification does not describe all duties performed by all incumbents within the class. This summary provides examples of typical tasks performed in this classification.

● Design, build, and maintain scalable integrations and solutions sourcing data from SIS, HR, Finance, transportation, assessment, vendor platforms, and other enterprise systems. E

● Design, build, and maintain custom web applications and agentic workflows.

● Leverage and inform the development of Snowflake data models. E

● Manage integrations using tools such as dbt, Workato, SQL, Python scripts, APIs, and cloud-native services; monitor workflows and resolve data pipeline issues. E

● Ensure adherence to data governance policies, privacy requirements, and security standards including FERPA, role-based access, and metadata documentation. E

● Support the development and implementation of districtwide data strategies, standards, and best practices. E

● Analyze complex data issues, troubleshoot system errors, and perform root-cause analysis to identify long-term solutions. E

● Demonstrate a commitment to the Portland Public Schools Racial Equity and Social Justice Commitment by applying the PPS Racial Educational Equity Policy and RESJ Framework in daily practices and data governance decisions. E

● Maintain current knowledge of Snowflake capabilities, cloud data engineering trends, emerging technologies, and industry best practices; participate in professional development. E

● Perform related duties as assigned.

“E” indicates essential duties required for compliance with the Americans with Disabilities Act.

Knowledge and Abilities

Knowledge of

● SQL, dbt, API-driven integrations and ELT/ETL concepts. Cloud environments (AWS/Azure) and data tools (Python, Workato, Airflow, Git).

● Modern web development, hosting and Software Development Life Cycle.

● Data governance, metadata management, role-based access control, and FERPA requirements.

● Technical documentation, and Agile development practices.

● Equity-centered data practices and culturally responsive communication.

Ability to

● Design, build, and maintain efficient, reliable scripts and automations.

● Use programming languages and tools (Python, SQL, dbt, Git, etc.) to develop integrations and data manipulation.

● Analyze complex data structures, identify system issues, and implement solutions.

● Collaborate with cross-functional teams and communicate technical concepts to nontechnical audiences.

● Ensure data accuracy, security, and compliance with district and legal requirements.

● Support the District’s Racial Educational Equity Policy and contribute to an inclusive work environment.

● Work independently, maintain confidentiality, and deliver high-quality customer service.

Education and Experience

Education

Bachelor’s degree in computer science, information science, data engineering, or a closely related field. A master’s degree in a related discipline is desirable.

Experience

Three (3) or more years of combined experience conducting technology business process analysis, development and integration for multiple platforms, and implementing end-user quality assurance test plans for software acceptance across multiple platforms.

Experience with public-sector or K–12 education environments is a plus. Any combination of education and experience that provides the required knowledge and abilities may be considered.

Special Requirements

Work hours may include occasional evenings or weekends in support of data releases, upgrades, or critical system events.

Remote Work Eligibility

Onsite

Skills

etl, api, pub/sub, dbt, SQL, ELT/ETL, Cloud environments (AWS/Azure) and data tools (Python, Workato, Airflow, Git)

Top Skills Details

etl,api,pub/sub,dbt,SQL

Additional Skills & Qualifications

Knowledge and Abilities

Knowledge of

● SQL, dbt, API-driven integrations and ELT/ETL concepts. Cloud environments (AWS/Azure) and data tools (Python, Workato, Airflow, Git).

● Modern web development, hosting and Software Development Life Cycle.

● Data governance, metadata management, role-based access control, and FERPA requirements.

● Technical documentation, and Agile development practices.

● Equity-centered data practices and culturally responsive communication.

Ability to

● Design, build, and maintain efficient, reliable scripts and automations.

● Use programming languages and tools (Python, SQL, dbt, Git, etc.) to develop integrations and data manipulation.

● Analyze complex data structures, identify system issues, and implement solutions.

● Collaborate with cross-functional teams and communicate technical concepts to nontechnical audiences.

● Ensure data accuracy, security, and compliance with district and legal requirements.

● Support the District’s Racial Educational Equity Policy and contribute to an inclusive work environment.

● Work independently, maintain confidentiality, and deliver high-quality customer service.

Experience Level

Intermediate Level

This is a Contract position based out of Portland, OR.

The pay range for this position is $40.00 - $45.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision • Critical Illness, Accident, and Hospital • 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available • Life Insurance (Voluntary Life & AD&D for the employee and dependents) • Short and long-term disability • Health Spending Account (HSA) • Transportation benefits • Employee Assistance Program • Time Off/Leave (PTO, Vacation or Sick Leave)

This is a fully onsite position in Portland,OR.

This position is anticipated to close on Aug 12, 2026.

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.