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:
<<profilehas a master’s of science degree in management information systems with business intelligence concentration.has 5+ years of experience working as a sql server developer, sql dba, and data analyst with excellent analytical and problem-solving skills to work with minimal supervision.strong knowledge and experience of rdbms like ms sql server 2008 r2/2012, ms access, mysql and t-sql (queries, stored procedures).strong knowledge and experience in business intelligence –ssis, ssrs, ssas, power bi ( power pivot, power query, power view, power map and pivot table,).experience in windows server 2008/2012 active directory administration(users and computers, dns, dhcp)experience with data analysis and visualization tools like excel and tableau core qualificationsbusiness intelligence /data analyticsdatabase development /administrationwindows server administrationwindows azuredata warehouse/ excel, mysqlssis, ssas, ssrs, power bit-sql, vba (ms access), excel macrostableaurapidminer, xlminer (data mining)html, css, wordpress, dreamweaver, photoshop, javascript professional experience sql devloper/dba/data analyst, 09/2012- 03/2015market footwear, fred lurie associate inc.–city,state,responsibilities:created etl packages involving various data sources (sql server, flat files, excel source files, etc) using ms ssisdeveloped data quality solution using sql server data services (dqs) as part of etlanalyzed data using using ssas, excel, tableau and power bi tools for decision making processbuilt self service business intelligence dashboards using power bi tools in excel.wrote t-sql queries for data analysis and reportingdeveloped reports using ms sql server reporting services (ssrs) and excelhelped decision makers to understand data on reports and dashboards and gain insights.installed, administered and maintained ms sql server 2008/2012, including upgrades, security, configuration and service packsdesigned, implemented, and maintained sql server databases.designed and implemented tables, views, functions, stored procedures and triggers in sql server.planned and implemented sql server security and database permissionsperformed database performance analysis and tuning using database engine tuning advisor, sql server profiler and sql server extended eventssetup high-availability as part disaster recovery strategy for the sql server 2012 databases (failover clustering, database mirroring, log shipping and replication).sql server developer/dba, 07/2009- 08/2012cifra systems–city,state,responsibilities:as a mid-level dba, installed, configured, administered and secured sql servers 2008/2008 r2.created and optimize database objects, e.g. tables, views, indexes, cursors, stored procedures, functions and triggers.scheduled and automated maintenance plans using sql server job agent.scheduled and automated full/differential/transactional backups and implemented recovery strategies.configured and monitored database mirroring, replication and log shipping as hadr strategy.planned and implemented sql server security and database permissionsextensively used joins and sub-queries for complex queries involving multiple tables.created indexes (clustered and non-clustered) to speed up query performance.designed excel dashboard for tabular and chart reports with drill down functionality.web designer/sql dba/developer/media specialist, 02/2005- 04/2009miami christians fellowship–city,state,designed desktop database application in ms access using vbadeveloped financial report using ms access and excelcreated website for the organization utilizing html, wordpress, css, php, msssql and mysqlperformed regular website maintenance and update while also designing graphics for banners, flyers, format and upload them to organization’s websitetrained staff members how to utilize computers, use software to maintain website and other media support servicesweb developer and database support, 07/2003-2005hotsilhouette, inc.–city,state,responsibilities:developed and maintained company's websites using dreamweaver, html, css, asp.net, javascript.designed and managed back-end sql server databases for web applications.wrote complex t-sql queries to manipulate datadesigned and edited graphics and photos for websites using photoshop.installed, configured and managed sql server and access databases.analyzed sales data from different sources and created dashboards using ms excel.provided technical computer support to end users. education master of science:management information systems,expected in2015-nova southeastern university-fort lauderdale,flgpa:status-concentration: business intelligenceassociate of science:computer programming and analysis,expected in2003-miami dade college-miami,flgpa:status-bachelor of science:agriculture (plant science),expected in1988-haremaya university of agriculture-haremaya,harergpa:status-.