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: <<Career OverviewHighly accomplished Data Architect / Technical Lead with a verifiable track record of designing and implementing complex IT system and exceeding expectations. Practiced in clarifying business requirements, performing gap analysis between goals and existing procedures/skill sets, and designing process and system improvements to increase productivity and reducecosts. Extensive experience in data mapping, data migration, ETL, and data modeling for OLTP, OLAP, relational and dimensional models. Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with stakeholders, developers and business leads . Recognized technical leadership skills, consistently delivercomplex, large-scale projects on time and within budget.
QualificationsAnalyticsBusiness IntelligenceManaging ScopeDatabase/Query Performance TuningStructured Query Language (SQL)
Education and TrainingManassas,VAExpected in––BS:Information Systems-GPA:➢ BS, in Information Systems, Strayer, Manassas, VA
Work ExperienceLumen Technologies-Integration Lead/ Data ArchitectNaples,FL,08/2014-04/2015Large Snack Food Company - DallasLarge Beverage Company - New YorkLed data integration effort to completion.Perform data integration troubleshooting with the clients ETL and batch teams.Wrote mapping and WSDL code based on client requirements.Monitored interface data loads using Accenture CAS Mat Tool and custom written SQL.Recommended performance improvements to client and Accenture architectsTexas State Agency - AustinInterfacing with client SMEs to document the as is environment in preparation for a new PBM vendorAnalyzing the organizations reports and interfaces that are needed to continue business continuityCreated and maintain System Inventory, User  Interaction and RICEFW documentationGathering and preparing documentation that was contributed to the RFP and will be used during the transition to a new vendor.Oil & Gas Company - ChicagoLed the creation and definition of the WEDS logical data architecture to support core data types: master data, transaction data, structured/unstructured data, digital documentsDeveloped strategies and options for data migration and data cleansingData Asset Strategy definition, Data Model Definition, Extraction and Transformation logicWrote custom functions and stored procedures to clean and transform dataAccenture Contractor Jobs-Technology ArchitectDenver,CO,05/2014-09/2014Led the technical information gathering effortCreate and demonstrated the importance of RICEFW documentationConducted meetings to discuss the data and process flow of internal and external systemsKey contributor in the evaluation of PBM vendors and their systemsAccenture Contractor Jobs-Data ArchitectSacramento,CA,11/2013-04/2014Led the creation and definition of the WEDS logical data architecture to support core data types: master data, transaction data, structured/unstructured data and digital options for data migration and data cleansing.Assisted with developing strategies for Management Information (MI) activities.Created a successful ETL proof of concept that extracted/transformed/loaded data and then linked the IDs from different systems into one universal ID.Wrote custom functions and stored procedures to clean and transform data.Technical liaison with vendor SMEs during the evaluation of different data applications and documents.Evaluated Smart Plant applications for use in the migration of structured and unstructured brownfield data.Developed strategies and options for data migration and data cleansingData Asset Strategy definition, Data Model Definition, Extraction and Transformation logicAssisted with developing strategies for Management Information (MI) activitiesCreated a successful ETL proof of concept that extracted/transformed/loaded data and then linked the IDs from different systems into one universal IDWrote custom functions and stored procedures to clean and transform dataTechnical liaison with vendor SMEs during the evaluation of different data applications and functionsArmed Forces Services Corporation-Data/Solutions ArchitectCity,STATE,11/2009-09/2013Data Architect and Team lead for a refactoring project.Responsible for leading the development of refactoring a Natural application to C# and from ADAbase to SQL Server.Implemented a process for configuration management within the company.Conducted peer reviews, estimation meeting and conducted testing cycles.Mentored junior developers in database practices and principles.Conducted data migration tasks as required by the company and projects.Moved all key infrastructure services within the company into a cloud infrastructure.Maintained the data integrity of the company's financial data used by Deltek.Created ETL scripts and processes as needed to support the companies' data request.Maintained the availability of all data driven systems.Supported project teams with data tasks.Used as a technical resource during proposals.Booz Allen Hamilton-Data ArchitectCity,STATE,01/2003-01/2009Created complex data models for DoD and government agencies.Worked with classified and unclassified data.Data lead for multiple development projects.Wrote, tested and optimize database scripts and procedures.Designed and implemented database designs used in the development of data driven web based applications.Interfaced with clients to gather reporting requirements.Sent to at-risk projects to win back client confidence.Designed and developed ETL processed for data migration tasks.Performed advance administration and troubleshooting of database engines.Worked with developers to design and optimize data access layers within the application code base.Provided technical feedback to upper management and support staff during proposals.
SkillsEtl, Extract, Transform, And Load, Data Migration, Database, Proposals, Clients, Access, Data Models, Dod, Engines, Web Based, Sql, Testing, C#, Change Management, Configuration Management, Data Integrity, Deltek, Estimation, Ms Sql Server, Natural, Solutions, Sql Server, Team Lead, Application Development, Bottling, Data Integration, Integration, Integrator, Issue Management, Mapping, Master Data Management, Mdm, Technical Product Marketing, Topo, Tpm, Architecture, Data Architecture, Data Cleansing, Data Model, Ids, Liaison, Stored Procedures, Transaction Data, Unstructured Data, Data Mapping, Data Quality, Data Structure, Data Warehousing, Database Analysis, Database Design, Dimensional Data, Federal Government, Microsoft Sql Server, Pricing, Security, Sql Server 2005, Documentation, Process Flow>>. The result is, Good Fit

Fit assessment: Good Fit