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:
<<summarypractical database engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. offering 12-year background managing various aspects of development, design and delivery of database solutions. tech-savvy and independent professional bringing outstanding communication and organizational abilities. hardworking and reliable data engineer with strong ability in building data pipelines. highly organized, proactive and punctual with team-oriented mentality. skills requirements gatheringanalysis and modelingdata warehousingsql reportingbusiness intelligencedata managementmicrosoft sqldatabase analysissql tuningcritical thinking experience senior data engineer, 12/2017-currentsplunk– ,adept in troubleshooting and identifying current issues and providing effective solutions.managed performance monitoring and tuning while identifying and repairing issues within database realm.worked as part of project teams to coordinate database development and determine project scopes and limitations.trained non-technical users and answered technical support questions.collected, outlined and refined requirements, led design processes and oversaw project progress.created conceptual, logical and physical data models for use in different business areas.wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.applied conceptual, logical and physical & dimensional/relational model designs to etl tasks.managed end-to-end operations of etl data pipelines, maintaining uptime of 95%.assisted in user acceptance testing for accounting/marketing users, verifying etl jobs complied with assigned parameters, achieving desired results.worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.worked closely with team members to deliver project requirements, develop solutions and meet deadlines.senior database consultant, 02/2013- 12/2017amazon.com, inc.– ,created informatica mappings/etl’s usinginformatica power centerto load the data from oracle, mysql databases to sql server 2016 databases hosted on aws cloud.performed the data manipulations using variousinformaticatransformations like expression, lookup, update strategy, router and sql transformation.designedinformaticaworkflows with many sessions with event with task, event raise task and email task. scheduled the created workflows/jobs usinginformatica scheduler.created multiplet-sqlobjects mainly stored procedures and functions for new and existing software application requirements.created multiple linked servers for ease of the users to execute commands on remote servers.developed new code and fine-tuned existing stored procedures to improve performance while utilizing the sql server profiler and database engine tuning wizard.created ssis packages to migrate data from legacy systems such as oracle, vertica, sql server, flat files to centralized it destination. created ssis packages utilizing different ssis transformations likescript component, merge join, look upand implemented error handling and logging.performed unit testing and qa testing at various levels of the etl’s and actively involved in team code reviews.developed report models using report builder and distributed reports in multiple formats using sql server reporting services (ssrs) in business intelligence development studio (bids) and sql server data tools(ssdt). createdparameterized, cascaded, drill-down, cross-tab and drill-through reportsusing ssrs 2008 r2/2012.created ad hoc queries in t-sql, stored procedures and views to store the data of third parties, and use them in ssrs reports to generate reports on the fly. worked with multivalued parameters for parameterized reports in ssrs.developed vba scripts for periodic financial (daily, weekly) reports generated directly from excel utilizing power pivot options in excel.managed report delivery based ontime driven and data driven subscriptionsandreport securityfor providing ssrs reportserver level, folder level and item levelpermissions to various users across the organization based on role based access control(rbac).worked on resolving any performance issues with ssis packages and ssrs reports and fine tune them for better performance.worked on cleaning up users on sql server and audit the access level. revoke inappropriate access, setting up ad groups and grant access based on the created groups.worked on databaseperformanceandmaintenancedutiessuch astuning,backup,restoration.provide on-call support for production job failures. resolve and close the time critical incidents in an appropriate way. perform root cause analysis, create problem report and work on any subsequent code changes to stop them from re-occurring.database consultant, 08/2011- 02/2013amazon.com, inc.– ,involved in gathering business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.usingt-sqlcreated complexstored procedures, functions, cursors, tables, and viewsand used other sql joins and statements for applications in sql server 2005/2008.developed standalonessispackages to extract data from different sources likesql server, flat files, excel, oracle, and sybasetransform and load the data onto required databases.usingssistransformations filtered bad data from different sources usingderived column, lookup, fuzzy lookup and conditional split.involved in creation of technical specs, design documents, implementation documents, and unit testing/test case /test plan documents and maintained issue logs.using script component inssiswrotec#.netcode to generate dynamic file names and create a text files. debugged and verified the values getting stored invariablesin run-time usingc#code.created dynamicssispackages through variables and script task components (c # and vb.net) and scheduled the packages using sql server agent to process and load the data.scheduled the package based on the enterprise calendar through sql server agent. created several one-time and recurring jobs for package scheduling.created xml file for package configurations and implemented parent-child package configuration inssispackages. implemented error and event handling: precedence constraints, break points, data grid and logging inssispackages.usingssrsdeveloped multiple types of reports including sub reports, parameterized and drill down reports using global variables, expressions and functions based on the requirements provided.deployedssrs.rdl reports on to the report server and created time driven subscriptions on the deployed reports.created cubes with multiple fact measures groups, and multiple dimension hierarchies based on the reporting needs usingssas.modified existing dimensions and created new dimensions as per new business requirements.created gui interfaces using c#.net and .net framework to simplify the database access to end business users. enhanced existing gui interfaces based on new requirements and improved efficiency.resolved and closed production incident tickets generated because of failure of daily jobs. education and trainingmaster of science:electrical engineering,expected in 01/2011-california state university - sacramento-sacramento,cagpa:status-.