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:
<<summarysalesforce data migration and sql bi developer offering 7 years of leading cross-functional teams and completing projects on-time. seamlessly manages workload to meet deadlines. skills salesforce data migration expertsalesforce data loader expertsalesforce administratorstrong microsoft sql server, mysql, sap skills ssis and ssrs expertfluent in tsql, c++, microsoft toolsdata warehousing and analyticsjira and tfsstrong decision makerexcellent communicatorteam playerself-starteractive directory knowledgerequirements analysis and design phases experience 08/2013tocurrentsalesforce data engineering managertalent rover llc–city,state,managing all data migrations into talent rover.migrate data from multiple sources into salesforce.create complex queries to extract data from sql server and/or mysql based on the client's requirement.created data migration templates to migrate from multiple sources into salesforce.manage multiple teams across the globe to complete the implementation life cycle on time.work with project managers and delivery leads to plan for the sprints and successful implementation of the project.meet with clients pre sales to provide the quote for data migration after analyzing there data and functionality.create ssis package templates for the data migration from similar sources.complete the data mapping with client and project manager.have weekly meeting with multiple clients to update on the progress in the project.complete the first data migration into salesforce and guide clients to perform the data validation and track issues.complete the data validation and get the signoff from client.plan for the delta or go-live load and support the client after go-live.manage multiple client's implementation in parallel.use data loader and workbench to get the data into salesforce. 07/2013to 08/2013ms sql server / ssis/ssrs architectestuate inc–city,state,create a single data warehouse to hold the data from individual data warehouses.added a new dimension table and modified the data model of the data warehouse depending on the requirement.implement etl solution to extract data from multiple sources into one dw.designed the high-level design document of the complete process flow.created a ssis/etl package to run across different data warehouses just by changing the connection string of the data source.designed a sql agent job that triggers the ssis package on a schedule.created reports to compare data between different data warehouses.created stored procedures and complex queries to extract the required data from the final data warehouse.created a web page to implement a simple authentication page for the uses to access the reports.the users can enter the required parameter for each report and execute the report.all the reports were using dynamic parameters, which used to be the input for the stored procedures to fetch the appropriate data.reports had an option to select single or multiple data warehouses from the drop down menu.implemented different types of charts for the graphical representation of the data.deployed the ssis/etl with a one-click deployment to the test and production servers.deployed reports on to the report server with a simple deployment utility. 04/2011to 03/2013ms sql server / ssis, ssrs developer (technical team lead) / data architectworkers' compensation insurance rating bureau wcirb–city,state,designed database after analysis of the business requirement.designed the high-level design document of the complete process flow.worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.designed development plan and the assigned individual task to team.worked with an offshore development team, communicating on a daily basis with the team.designed the complete flow of the file processing.designed power shell to monitor the file location for the file existence and copy/move to specific location after looking at a character inside the file.inserted into the tables from the power shell by calling stored procedures.designed the file processing using the queue (first in first out) concept.implemented the queue logic by starting sql agent jobs (which pointed to deployed ssis packages on the integration server).designed ssis packages to implement the file processing logic depending on the source of the file.deployed ssis packages with a simple one-click deployment to the integration server.maintained different branches in tfs as development for release 2 and testing for release 1 were together.resolved the conflicts while merging code in tfs. , uat and production from tfs.designed reports using ssrs for the client as per their specifications.deployed ssrs on to the report server with an easy way of deployment.created subscriptions on the deployed reports using report manger.called those subscriptions using a stored procedure (which fired the report subscription and saved the reports on the file server).used database.sqlcmdvars for deploying the database instances giving the flexibility to change the variables used in the deployment.implemented the sql agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.created the sql server users and file server users with required permissions by including them in the scripts.implemented the power shell as a windows service (which is used to monitor the file existence).implemented matrix tabular and charts while creating the reports using ssrs.used expressions extensively for hiding textboxes, display and hiding charts, matrix and tabular depending on certain conditions.used parameters, images to retrieve appropriate data from the common data source added globally.saved images in a binary form in the configuration tables for easy retrieval from ssrs.implemented derived column, file system task, conditional split, lookup transformation, ole db command, data conversion, data flow, execute sql task, bulk task, script task, for each loop, ftp task and other tasks in ssis.optimized the loads by adding indexes wherever needed, dropped and recreated indexes while doing the full loads.maintained the sql server agent jobs to run depending on the requirement.used ibm ole db connection manager to connect to ibm db2 database and get some input data to the look up loads.used update and merge statements while working on the incremental loads. 10/2010to 04/2011ssis technical leadfocus on the family–city,state,worked with an offshore development team, communicating on a daily basis with the team.defined planned and lead the development tasks.tracked and reported status, risks and issues to the business.designed and developed ssis packages to import and export data from ms excel and flat files.implemented ssis packages for data export/import and created maintenance procedures and deployed them to the server.extensively used ssis import/export wizard, for performing the etl operations.built control flows and data flow for incremental data loads.involved in automation of jobs that perform incremental load on a timely basis using lookup's and data is delivered in the form of flat files to certain storage points.used configuration files for changing variables easily.worked with ssis package event handlers, property expressions.designed the production rollout strategy and migration of assets from environment to environment.implemented data integrity procedures and logics.assessed requirement and defined the strategy, technical architecture, implemented plans and delivery of a data warehouse.made the ssis code changes depending on the business requirement deployed the changes ssis packages and propagated them into different environments.worked on encryption of the file set using pgp and gpg.designed ssis packages to send the encrypted file to different vendors using winscp.designed ssis packages to shrink, backup, encrypt databases.designed ssis packages to copy data from historical server (ibm) to sql server 2008 using liked servers and open queries.designed ssis packages to populate data into listselect database for the reporting team.implemented audit tasks tables in the databases to maintain logs for the sql server agent jobs.implemented full loads (once a week) and incremental loads (daily) in schedules.created new views, synonyms, stored procedures, functions and triggers to accomplish the changes in the requirement.successfully fixed the errors in the ssis packages and was able to rerun the jobs from the checkpoint files.worked on different kinds of transformations like import column, export column, lookups, derived column, merge join, fuzzy lookup, forloop, foreachloop, conditional split, union all, script component in ssis as per the client's requirement.implemented the changes depending on the new releases into data warehouse, adding new columns, changes in the data types of the columns, new tables etc.optimized the loads by adding indexes wherever needed, dropped and recreated indexes while doing the full loads.used update and merge statements while working on the incremental loads.maintained the sql server agent jobs to run depending on the requirement. education and trainingexpected indec 2009totomasters of science:computer science computer science and electrical engineeringstate university of new york-new paltz,nygpa:computer science 3.37 computer science and electrical engineering created a parallel parking simulator using a scribbler (robot) and python language via bluetooth princeton college of engineering and technology (jntu) hyderabad, andhra pradesh, indiaexpected inmay 2008totobachelors:atomic energy central school-hyderabad,gpa:on electrical and communication scored 67.67 % participated in crime scene investigation workshop help during shaastra 06 (iit madras) built a street light timing simulator with a group of 4 as my final year project from wine yard technologies kakaitya academy (bie) hyderabad, andhra pradesh, india intermediate in mathematics physics and chemistry (mpc) scored first division 76.4%.expected intotoclass x:central board of secondary education (cbse)-,gpa:scored 65.6 % -live, automation, backup, c++, charts, chemistry, concept, encryption, client, clients, data conversion, data migration, data validation, data warehouse, data warehouses, databases, database, data warehousing, delivery, etl, fetch, ftp, ibm, db2, logic, managing, mathematics, excel, windows, migration, mysql, communicator, , page, physics, presenting, progress, , reporting, requirement, requirements analysis, sales, sap, self-starter, servers, shell, scripts, script, microsoft sql server, sql server, strategy, tables, team player, tsql, web page, workbench.