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.

Resume:
<<profilehighly motivated sales associate with extensive customer service and sales experience. outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market. core qualificationsexpertise in full project life cycle development for implementation and integrationmotivational and co-ordination skills with ability to deliver systems on scheduleanalyze and drill data marts for information miningchange management process for data qualityexperience d in requirement analysis, test design, test preparation, test execution, defect management, and management reporting.experience d in developing data mapping, performance tuning and identifying bottlenecks of sources, mappings, targets and sessions.experience d in development of etl mapping and scripts. understand , debug of etl jobs, for transforming data , remove duplicatesexperience d with batch systems scheduling and processing.jad sessions to determine the requirements for purchase order requisition conceptual modelexperience with large enterprise data warehouse (olap) architecture design including logical and physical model development.data models and enterprise data models.expertise in extracting and transforming large data-sets; experience with etl tools like ibm infosphere data stage, ssisexperience d working with offshore vendors and establishing offshore teams and processes.demonstrated experience with database technologies (e.g. sql server, sybase, mysql).move data from oracle to sybase using sybase gatewayexperience with hybrid cloud platforms, oracle vm serverhands-on experience with production reporting and bi platformssetup oracle rac clusters for production and non-production environment professional experience lead data/database architect, 12/1993- 12/1994–.worked collaboratively with team members using microsoft lync / webex; led/coordinated meetings between multiple time zones with both on/offshore team members.provided findings with questions to business analysts for verification; provided metadata such as allowed values, defaults , constraints , domain inconsistencies, data layouts for flat files etc.for reference to data modeling or etl team.worked on txbase erp software for inventory systems at the factory worked on shop floor in understanding the movement of items from bins to factory floor understand and identify data relationship for inventory of items and automating of issues/receipts using scanner software design and creation of models for maintaining product receivables and issues generation of reports of stock ledger for use by purchase department for ordering of new items schedule of quotations and bill of materials for each items building of large database in sybase system 10 for inventory and materials generation of purchase orders from quotations.design and creation of tables for each process change management impact analysis of data.sr programmer/systems analyst, 11/1988- 12/1993na–.jad sessions to determine the requirements for purchase order requisition conceptual model designed logical and physical data models.analyzed source data to determine what meta-data was to be included in the logical data model performed data mapping to determine where identified source data belonged in the data base.created forward engineered sql from case tool, which was loaded to build and maintain the data base.used transact sql to load data into sybase/mssql server to load source data into the data base designed tables for bank reconciliation system , purchase order requisition system identified attributes , entities and converted into physical tables for different account heads related to company purchase order requisition system towards identifying of customers , supplier rates , deviation from scheduled delivery dates.designed tables related to generation of max/min levels of inventory in hand for production reports for cost of total stock in hand installation of audit trail for the system for changes made and a report to management about date-time of change enforce data integrity using primary key , foreign key and composite key identifying indexes on tables for optimum data retrieval residency status: united sates citizen.senior data technical solutions architect,-–.responsibilities at aig: provide production support to various oracle/sybase/microsoft database environments across enterprise.developed dump/restore scripts for sybase.rman backup scripts hot/cold backup and datapump scripts for oracle.setup automated alerts for disk space monitoring, database server up-time monitoring, thru ca pronet.oracle/sybase security patch updates on database home , when available through scheduled change tickets.autosys job scheduler for scheduling jobs, viz backup/dump/ order to maintain support from software vendor.work with application teams on upgrade schedule.setup test servers/database for upgrade testing.written security stored procedures as required by compliance for password security.server, query, application performance tuning when there is deterioration in query performance.reverse engineer physical database to logical models when needed using powerdesigner/embarcadero/er-win as needed for identifying table/data relationship.schedule time with unix engineers for san migrate of datafiles/ database needs to be migrated to a new host. education training from ibm in datastage/parallel extender, infosphere datastage training in ldom , -memory database from oracle university project management training towards certification masters in administrative management - mumbai university:,expected in--,gpa:status- skills administrative, backup, , case tool, , data modeling, data warehouse, databases, data base, database, datastage, delivery, engineer, -win, etl, gateway, ibm, inventory, ledger, management reporting, materials, max, meetings, memory, mysql, enterprise, olap, oracle, processes, project management, quality, reporting, requirement, san, scanner, scheduling, servers, sql server, mssql, sql, sybase, tables, transact sql, unix, , written.