For the given job description <<ROR Partners is a rapidly growing, client-driven digital marketing and data company. We offer proven marketing solutions to a variety of vertical industries on a nationwide basis.
ROR is seeking a Principal Data Engineer to serve as a key data architect and team leader on our data engineering team. The successful candidate will have demonstrated deep understanding and passion for designing and implementing robust ETL and ELT data pipelines. Position is remote and reports to the VP, Engineering. Salary is $170K to $195K and is determined by factors such as location, experience, and expertise. 
What you will doBuild, maintain, and administer our Snowflake data warehouse using Data Build Tool (dbt)Implement and maintain data pipelines between various operational systems and our data warehouse using Python, Airflow and integration platformsCreate and maintain documentation of data architectureCollaborate with internal and external stakeholders to ensure that data requirements are addressedMentor and lead other data engineering team members and participate in peer design and code reviewsShip production-quality features independentlyWork efficiently and productively in a remote-first work environmentCommunicate and collaborate effectively, both verbally and in writingLearn independently - keep up to date with developments in the field
QualificationsWhat we are looking forHistory of professional experience shipping production quality code independentlyAbility and desire to lead and mentor a team of data engineersExpertise with SQL and cloud-based analytical data warehouses (Snowflake preferred)Expertise building end-to-end data pipelines using Airflow and dbt (data build tool) or comparable technologiesDeep understanding of ETL and ELT patterns and best practicesStrong data modeling skills and familiarity with the Kimball data warehousing methodologyExperience writing Python code for data processingDesire to continually keep up with advancements in data engineering practicesExperience conducting design and code reviewsStrong analytical skills and independent learning styleExperience with git and use of the command line requiredExperience with AWS and CloudFormation, or comparable cloud services and IaC tools preferredExperience with Docker and Docker Compose preferredSubject matter familiarity with digital marketing and digital activation is preferred
EducationTrainingRequired: BS Degree in computer science or related STEM field
Experience8+ years of experience in data science, software engineering or related technical fields.
ROR Partners is an Equal Opportunity Employer. ROR Partners policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. ROR Partners also prohibits harassment of applicants and employees based on any of these protected categories.
ROR Partners will provide accommodations to applicants as needed.>> the resume: <<SummaryData Entry experienced and adept at inputing and maintaining databases. Certified in 10-key and skilled at creating effective organizational and filing systems. Types 60 WPM. Experience working in office setting with confidentiality as one of my top priorities.
HighlightsMicrosoft Office proficiencyMeticulous attention to detailSelf-directedExcellent communication skillsStrong problem solverResourcefulPleasant demeanorCustomer service-orientedMulti-line phone proficiencyFiling and data archivingHIPAA complianceTime management
EducationGED 
Sprague High SchoolSalem,ORExpected in––High School Diploma:-GPA:Chemeketa Community CollegeSalem,ORExpected in––Associate of Arts:2 year Oregon transfer degree-GPA:Sept 2011 to present/96 credit hours with associates degree anticipated.
ExperienceWestern Paper Distributors-Receptionist/Data EntryAlbuquerque,NM,08/2011-11/2015Arranged appropriate travel, agendas, necessary contacts and flight information.Scheduled meetings and assisted with meeting materials and agendas.Handled and distributed all incoming and outgoing mail.Managed incoming and outgoing calls for office.Scheduled and confirmed appointments.Communicated with employees via phone, email and in person to obtain and give information.Successfully established effective systems for record retention by creating database for daily correspondence tracking. Data entry main part of daily job duties.Arlington County, Va-Human Services SpecialistArlington,VA,11/2008-08/2011Interviews applicants to determine need and eligibility and then makes a preliminary assessment of client's needs and explores alternative resources to link clients to.Questions applicant to verify information.Explains rules, regulations, procedures and responsibilities to applicants.Makes changes to client's information based on reported changes (eg, changes in household, income, or resources).Makes decisions for continued eligibility and issues benefits for state food stamp, medical, daycare, Domestic Violence program and other programs for clients of the Department of Human Services.Daily contact with applicants, outside community partners, community resources and providers.Telephone, in person, and email contact daily.Sometimes deal with hostile individuals.Fhi 360-Program AssistantDurham,NC,07/2008-11/2008Work closely with JOBS program participants.Regularly update attendance on Tracs, make new steps for activities, set-up daycare for JOBS clients and answer daycare questions.Conduct home visits, make follow-up phone calls, narrate information using Tracs system.Navigate all DHS screens to find information regarding client's case information, answer phone calls, emails, and file case information in client files.Work with clients on employment goals, Work experience sites, JOBS Plus sites, and others.Assist TANF case managers with case load.Montgomery County, Oh-Transition CounselorDayton,OH,02/2008-07/2008Work from a client centered practice framework- providing high quality personal support to assist them to address a range of barriers which may be preventing them from moving forward.Establish a positive working relationship with clients, which are founded on dignity and respect.Provide assessment of clients and develop clear and transparent solution focused action plans for transitional purposes.Provide relevant and timely information and advice to clients to enable them to make informed decisions and develop problem solving capacity for when they release from custody.Advocate with and for clients where appropriate in a way that build their capacity and confidence to advocate on their own behalf.Source appropriate services and provide supported referral to specialized services including drug.and alcohol, housing, food, counseling, clothing resources, parole and probation etc.Teach life skill classes around transitional services.Case manage individuals.Follow the expectations of the Department of Corrections.Arlington County, Va-Corrections Transition CoordinatorArlington,VA,03/2007-08/2007Transition Services include: Conducting classes for individuals 120 days from release, processing social security and birth certificate applications, finding suitable housing, clothing, food boxes, etc.Extensive communication with the public, outside resources, and other state and county agencies.Meeting with inmates to provide one on one service, interviewing and taking notes on their individual needs.Helping to find resources for them in the county they are paroling to.Answering kytes (in-facility communication), emails, and phones.Attending meetings, trainings, and workshops.Researching community resources, finding mentors, and services.Handing out food stamp packets, disability packets, DMV info, and many other items that individuals incarcerated may need.Handling phone conferences between outside resources and the inmates, and parole offices and the inmates.Setting up call-outs for appointments such as, Parole officers, community partners, transition fairs, housing, and mentors.Teaching classes and getting individuals into the institution for speaking engagements.Collaboration of agencies to remove barriers that prevent offenders from accessing services.Establish structured community referral system including having ongoing communication and collaboration among community corrections and other various organizations.Use faith-based services and Home For Good Program.Have over 250 community contacts for the transition program at Santiam and Mill Creek.Over 65% of time is spent communicating with outside community and partner organizations to help incarcerated individuals transition successfully into the community.Work closely with institution counselors, security staff, and management team.Security, assist with transition services for paroling inmates.Department Of Corrections-Corrections OfficerCity,STATE,07/2005-03/2007Provide positive reinforcement to inmates, patrol housing, and conduct bunk searches.Interact continuously with inmates; provide positive reinforcement when appropriate, and role model appropriate behavior using the Oregon Accountability Model.Prepare and write a variety of reports regarding inmate conduct and other institutional issues using a wide range of programs including DOC 400.Restrain violent inmates, may sight and fire weapons, patrol housing units keeping constant control of housing unit and inmate population.Conduct bunk searches and may come in contact with unsafe items.Enter and retrieve information using a computer, and answer housing unit telephones.Conduct inmate pat downs that include: inspecting inmates for contraband hidden in various areas.Distinguishing distant emergency whistles, listen for whispers and conversations at a distance, and react instantly and appropriately to emergencies.Supervise inmates in a variety of housing and work environments.Operates an institution vehicle to transport inmates.Always works as a team player keeping DOC procedures and policies in mind.DPSST trained.Department Of Human Services-Human Services SpecialistCity,STATE,11/2004-03/2005Manage caseload, determine ongoing client eligibility, and make referrals.My duties in this position where as follows: Assessing the needs of applicants, determining eligibility, issuing benefits for the Food Stamp and state medical programs, managing a caseload that varied from 150-200 clients at a time, kept up on all eligibility requirements including rules and regulations, made referrals for clients to outside local agencies that could possibly assist them, answered a mulit-line phone, responded to numerous emails per day from inside my agency and outside partners in the community, case managed and determined ongoing eligibility at review time, responded to a high volume of mail that came in every day, prepared and maintained proper narration on each client's case using computer program, typed up letters and memos that went out to clients, conducted face to face interviews to gather information that would help me determine eligibility, team work, and client/customer confidentiality.Explained food stamp and state medical program guidelines, policy and procedures to clients and potential clients.Monitored client's cases for updates, case status, and case reviews/re-determinations.I also received experience working the front reception desk and seeing a high number of people on a daily basis some who became irate or hostile, answered many questions regarding different programs available, handed out applications, helped clients and potential clients fill out applications and other material, referred clients to other outside resources in their community, answered a multi-line telephone and either transferred the calls to the appropriate person or helped the caller with questions surrounding their benefits or the program they were on, working the mailroom which including retrieving all incoming mail and distributing to workers and managers in office, being extremely organized and timely, processed applications and reapplications for the food stamp, medical, and TANF.>>. The result is, Good Fit

Fit assessment: Good Fit