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: <<SummaryHuman Resources Professional with 11-year background in SAPHR experience (emphasis on employee, organizational, and payroll data), and training. Highly detail-oriented and organized. Advanced analytical and resolution skills. Excellent presentation and organizational skills.  Demonstrate effective written and verbal communication, sound judgment, and work ethics.  Ability to supervise staff members, establish good working relationships with clients and colleagues.
Experience02/2011to11/2011International Data AnalystChevron Corporation–City,STATE,Implemented expatriate policies and business processes in Global Advantage IHR (GA IHR), optimized the system to facilitate the expatriate administration processes, conducted business process reviews, and utilized knowledge sharing and standardization to create expatriate administration best practices.Processed semi monthly payrolls for ~3,135 expatriates to and from the United States including: created, maintained, audited remuneration templates, as well as, researched and corrected variances.Provided leadership in the use of the software and continually searched out and implemented business process improvements.Maintained data integrity, inbound interfaces, system knowledge and functionality.Collaborated with Human Resources Information Management Group, Human Resources Service Center Expat Team, Payroll Operations on SAPHR updates and answered employee questions regarding elements of over-base compensation and hypothetical taxes.09/2006to02/2011Organizational Data AnalystChevron Corporation–City,STATE,Serviced a population in the SAP - HR system of 28,965 employees in domestic and international locations.Processed merit increases and other SAP actions using the Compensation Tool and the Salary Planner for the respective populations.Managed batch updates for union/general increases, Cost of Living Adjustments, market adjustments, and 3x3 ratings.Conducted analysis and executed retroactive processing.Responded to detailed and complex inquiries from the Manager, Human Resources Information Management; telephone/email requests from Line Managers and Human Resource Representatives.01/2009to07/2009Team Leader, Human Resources Service CenterChevron United Kingdom Limited–City,STATE,Led the day-to-day activities of the Human Resources Service Center (HRSC) for nine HRSC Administrators.Allocated workload using Transaction Management System and ensured that service center adhered to service-level agreements. Actively used sound judgment by facilitating complex, customer service issues and produced systematic tangible resolutions.Produced budget analysis for the 2009 financial plan comprised of scenarios ranging from 5%, 10%, and 20%.Constructed a detailed resource analysis report using Crystal Ball software to substantiate the number of skilled Full Time Employees (FTEs) essential to operate and maintain the stability of the HR Service Center (results: 5.25 FTEs).Reestablished and strengthened partnerships with third party vendors, and empowered team members to make line-level decisions.10/2000to08/2006Senior Personnel Data MaintainerChevron Corporation–City,STATE,Started as a Personnel Data Maintainer and quickly promoted to Sr. Data Maintainer position leading the day-to-day activities of the Human Resources Information Management US Group for 27 Personnel Data Maintainers (PDMs) that included:Participated in compiling and analyzing data; developed recommendations for process improvement and project enhancement and project development efforts. Provided support and problem resolution for managers and employees on SAP tools (i. e., Manager’s Desktop and Employee Self Service).Responded to initial systems start-up complexities and variable processes, acted as a troubleshooter, and mentored Junior PDMs.Accurately analyzed and entered management requests into SAPHR for transactions such as hiring/rehiring, transfers, promotions, salary changes, leaves of absence, terminations, payroll taxes, etc.Assisted in creating/maintaining positions and organizational structure within SAPHR; including generation of reports and analysis of position data.  Performed data audits and clean up.  Completed work required to accomplish reorganizations within SAP.
SkillsHRIS Software:  SAP – Human Resources Module, Business Warehouse , Global AdvantageMicroSoft Office Products: Excel, Word, PowerPoint, Outlook, Visio, AccessAriba, Virtual Edge, Org Publisher, Lotus Notes, KnowledgePlanet, Learning Management System (LMS), Transaction Management System (TMS), Security Watchdog
EducationExpected in2014totoAssociate of Science:Business AdministrationMerritt College-Oakland,CAGPA:3.67 GPAExpected in1987totoCertificate of Completion:PIC/XEROX Word Processing ProgramJohn Adams Community College-San Francisco,CAGPA:>>. The result is, Good Fit

Fit assessment: Good Fit