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: <<SummaryDetail oriented and team focused epidemiologist with 8 years of experience working as an epidemiologist and statistician for public health agencies.
SkillsStatistical Analysis and Coding: SAS, R, SQL, EpiInfoData Visualization: Tableau, Arc GISMicrosoft Suite: Excel, Access, Word
ExperienceEpidemiologist/Data Analyst,07/2021-CurrentCalifornia Department Of Public Health–City,STATE,Current epidemiologist on the Epidemiology and Surveillance Team within the COVID-19 California Department of Public Health (CDPH) response responsible for maintaining and providing case-based surveillance and epidemiologic data for COVID-19 cases in the state of California.Generated daily and weekly reports identifying COVID-19 trends including case rates, death rates, test positivity and health equity measures.Monitored data quality of death, duplicate, and reinfection data and worked with individual counties and other partners.Led efforts to create a process for deduplicating COVID-19 reinfection data by working closely with the data team and responding to feedback from individual counties.Assigned to the MPOX emergency response for 8 weeks and produced daily reports and visualizations using SAS and R. Led efforts to improve on LGBTQIA+ representation in data.Created a staff roster using SAS from several different teams on the emergency COVID-19 response. Combined multiple datasets and created a new dataset with unique variable key.Assisted with coding of COVID-19 racial equity analyses in SAS.Research Statistician IV,12/2017-07/2021Hawaii Department Of Health–City,STATE,Developmental Disabilities Division's research statistician responsible for submitting annual reports to national agencies, consulting on data needs, assisting in division's new IT project, and providing data quality control.Analyzed variety of data sources including fiscal data, Medicaid claims, and demographic data.Coordinated efforts to transition entire division to new database system. Trained staff on data analysis concepts and methods, and use of Microsoft Excel and new system.Recommended data quality improvement policies and standards.Assisted with legislative reports and generated frequent data reports to Division Director.Lead of PPE Distribution efforts to providers across the state of Hawaii during COVID-19 pandemic when the division was assigned responsibility for allocating donated PPE. Allocated millions of units of PPE across hundreds of providers by analyzing needs versus requests. Coordinated hundreds of allocations with donors, distribution centers, and organizations.Research Statistician III,07/2017-12/2017Hawaii State Hospital–City,STATE,Research statistician for the Department's Maternal and Child Health BranchCollected and analyzed data from reproductive health care providers around the state and produced weekly reports using Microsoft Access & Excel.Assisted supervisor in providing data for annual grants.Submitted a poster that was accepted for a national maternal and child health conference.Epidemiology Fellow,07/2015-07/2017CSTE/Hawaii Department Of Health–City,STATE,Two year epidemiology fellowship through the Council of State and Territorial Epidemiologists, funded through CDC and assigned to Hawaii Department of Health.Provided epidemiological support for maternal and child health capacity in Hawaii.Developed multiple research projects for adolescent health, injury prevention, teen births, and infant mortality.Proficient analysis of multiple data sources: Behavioral Risk Factor Surveillance System, Youth Risk Behavior Survey, Pregnancy Risk Assessment Monitoring System, Vital Statistics, Medicaid claims data using SAS.Produced reports for grant applications and legislative briefings.Developed surveys for different audiences and evaluated surveillance systems.Participated in Hawaii Dengue outbreak investigation in 2015.Presented oral sessions and posters at national and statewide conferences, trainings, and workshops.Mentored graduate student interns working on oral health.Evaluated programs and projects and received opportunity to attend national program evaluation training.
Education and TrainingMasters of Public Health:Epidemiology,Expected in05/2015-University of Georgia-Athens, GA,GPA:Status-UGA Dual Degree Program: obtaining masters and bachelors degrees within 4 yearsCoursework: clinical epidemiology, modeling infectious disease (PhD course), biostatistics, environmental health, health policy, clinical trials, and health promotion and behavior3.9 GPABachelor of Arts:International Affairs,Expected in05/2015-Univeristy of Georgia-Athens, GA,GPA:Status-Honors International Scholar 2014Zell B. Miller Scholarship Recipient 2011-20153.9 GPA>>. The result is, No Fit

Fit assessment: No Fit