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:
<<career overviewhighly 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. qualificationsdatabases/ accessnetezzahadoop/big dataamazon redshift , s3software productsoracle d2k, forms & reports 10goracle apps 11ghadoop impala /hive/sparkamazon web services, redshift programming languagesoracle pl/sql & sql, impala sqlpythonjava(basics), cvisual basic, coding in ms excel using vba, power queryunix/vmssoftware toolspl/sql developer, visualizer, nps admin tool & aginity for netezza/redshiftform & report builderelastic search, logstash and kibanacloudwatch exports to exceleclipse, project. ms visio, power query with excelputty, attachmate reflection,hpsd, remedy, service pointnsi, vss, ibm rational clear case & clear quest, tortoise svn, githubhp quality center , jirahadoop hue, chronological order.01 - t-msis (transformed medicaid statistical information system)client: centers for medicare and medicaid services (cms)location: windsor mill, marylandduration: 09/2015-till daterole: technical analyst/senior developer /architect /data analystsolution environment: oracle 11g, informatica, unix, amazon web services (aws), redshift work experience team lead/senior developer /architect /data analyst, 06/2014- 08/2015exela technologies inc.– ,9.2 years of extensive experience in business analysis, system analysis, design, development and implementation of various projects with strong experience in database system and project management.good knowledge of hadoop ecosystems, hdfs, aws, netezza, oracle, hive, sqoop, impala and amazon redshift.implemented proof of concepts on running hadoop, migration from multiple databases (netezza, oracle) to hadoop.experience in working with different data sources like flat files, xml files and databases key participant in all phases of the sdlc ranging from requirement analysis design, development and testing (unit, system, integration, regression, product).ability to design database schemas, performance tunes sqls, troubleshoot, improve logic and move data through the enterprise.experience in writing complex sql queries involving multiple tables inner and outer joins.experience in creating tables, views, triggers, stored procedures, user defined functions and other sql statements for various applications.streamlined sql, improved speed via query optimization, modified tables, and enhanced metrics maintain accurate and organized notes on the status of development projects.experience d in: application development & implementation.agile & waterfall software development model client-onsite, client - offshore and onsite-offshore model change management, incident & problem management supply chain management system ( transportation and warehousing) media research - nielsen media research.project management, agile scrum master.team lead/senior developer /data analyst, 05/2012- 05/2014perspecta inc.– ,indiasolution environment: oracle 11g, netezza (7.0.2), tibco, unix responsibilities: analysis and design, development & implementation of software solutions team handling, software estimation & impact analysis.evaluated business requirements and prepared detailed specifications that follow project guidelines required to develop written programs involved in loading data from unix file system to netezza analyzed the data by performing netezza queries and reviewed the results with data science team.revised procedures that solve complex business problems with due considerations for hardware/software capacity and limitations, operating times and desired results.analyzed large amounts of data sets to determine optimal way to aggregate and report on it.provided quick response to ad hoc internal and external client requests for data and experience d in creating ad hoc reports.rfcs, change management and version control.review of code and test scenarios.maintenance & support of existing software applications, status reporting 04 - ikea cargo network systems.service delivery manager, 05/2009- 04/2012ikea it–city.germanyoracle 10g, d2k, forms 10g, open vms responsibilities: service delivery management incident, problem and change management.analysis and design & implementation of changes identified in support.ensuring on-time delivery (otd), first time right (ftr).ensuring e2e application is up and running (24/7) status reporting 05 - job-jar ge oil & gas.software developer, 05/2007- 04/2009ge oil & gas–city.indiaoracle 10g, d2k, unix, apps (11.) responsibilities: analysis and design, development & implementation of change requests.rfcs, change management and version control.software estimation & impact analysis.ensuring on-time delivery (otd), first time right (ftr).requirement analysis and technical design document creation.involved in developing/changing modules as per technical design documents.sql-query tuning created indexes on selective columns to speed up queries and enhanced performance using optimization techniques-normalization, indexing and transaction isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.designed and developed sql stored procedures to replace existing business logic.development of indexing schemes for most efficient insert, update and select involved in system testing & integration testing status reporting. education and trainingbachelor of technology:computer science and engineering,expected in--,gpa:status-computer science and engineeringb.tech - cse:,expected in2006-mahatma gandhi university-,kerala.gpa:status-degree:,expected in2001-mahatma gandhi university board of secondary education-,keralagpa:status- skills ad, agile, analyst, application development, architect, automation, big data, business analysis, c, change management, cms, hardware, network systems, client, version control, data analyst, data analysis, data modeling, databases, data base, database, delivery, eclipse, xml, forms, , ibm, indexing, informatica, java, leadership, logic, notes, managing, excel, project, migration, mill, enterprise, oil, open vms, optimization, , developer, oracle pl/ /sql, processes, coding, programming, project lead, project management, python, , quest, quick, reporting, requirement, research, scrum, sdlc, set top box, scripts, software development, sql, strategy, structured, supply chain management, system analysis, tables, team player, tibco, toad, transportation, troubleshoot, unix, visio, visual basic, vba, visualizer, vms, warehousing, written communication skills.