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: <<SummaryOver the past 11 years I have worked for the global leader in property information,Corelogic.Initially hired as an in-house programmer I now process raw files that contain assessor and taxroll data from virtually every county in the United States. These duties require the use of a variety of tools, but mainly consist of a great deal of analysis as well as programming responsibilities performed in a production environment.
HighlightsGuest servicesInventory control proceduresMerchandising expertiseLoss preventionCash register operationsProduct promotions
EducationNorthern Kentucky UniversityHighland Heights,KentuckyExpected inJuly 2004––Bachelor of Science:Information Systems Business Administration-GPA:Information Systems Business Administration
ExperienceStolle Machinery-Data & Program Services Analyst, SeniorKettering,OH,08/2004-CurrentProcess raw assessor and tax roll data as provided by counties which is implemented into Corelogic productsPerform extensive analysis and make business decisions based on data providedCreate and implement production templates for offshore analystsConduct online and teleconference meetings with offshore groups. Extensive use of the Natural programming language in a IBM mainframe environmentRegularly mentor less experienced analystsMust meet customer and company deadlines in a production environmentMust meet customer and company quality assurance standards in a production environmentUse an array of company tools and pubic websites to justify business decisionsCreate in-house programs using Visual Basic and Access programsWork remotely from my Bellevue, Kentucky home office.American Emergency Resources-Web Developer/IT ManagerCity,STATE,01/2004-08/2004Develop and maintain company's websiteAdminister network for small officeDevelop and administer company's database using Microsoft AccessDevelop and maintain a strategic plan for company's Internet presenceResponsible for changes and additions to productsCreate and implement graphic content for websiteDevelop and implement information security policies and procedures for all aspects of the organizationFifth Third Bank-Transmission Clerk-Retail LockboxCity,STATE,11/2001-01/2004Making daily deposits for 100+ customers according to deadlines on an imaged based platformUploading customer database files to company mainframe in order to transmit funds from our location to customer's accountResponsible for making sure that all customers' files are transmitted timely and accurately based on daily deadlinesMaintain daily back up database file by burning a virtual cd for each client that is then stored in our archivesPrepare daily package and report to be sent to our customers containing remittance statements, deposit slips, and correspondence workNewport Steel Corporation-Quality Control InspectorCity,STATE,03/1996-03/2000Visually inspect steel pipes for structural defects in a production settingPrepare samples for laboratory analysisResponsible for training new employees and participated in safety course workFamiliar with ultrasonic equipment, micrometers, and calipers
SkillsSoftware design (Cobol and Visual Basic, and PowerBuilder, Natural)Network Architecture (Client/Server, Peer-to-Peer, LAN and WAN, Network Security)Database Design/Administration (SQL, Sybase, Access)Web Design/E-Commerce (HTML, ASP, VB Script, Java Script, Visual InterDev, FrontPage, Dreamweaver, and Miva Merchant)Information Security (Development of policies and procedures using Security Systems Development Lifecycle)Microsoft Office (Excel, Word, Access, and PowerPoint)>>. The result is, No Fit

Fit assessment: No Fit