For the given 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.>> the resume: <<SummaryHighly proficient Business Analyst with 5 year experience and technical acumen complemented by extensive project management and CRM experience Performed requirements analysis to capture different components of on-line business applications (Web based) used by product managers using waterfall and Agile metClairedology Extensively involved in designing, documenting, testing and deploying enhancements to custom objects, workflows, alerts, reports and dashboards within Salesforce
HighlightsMicrosoft Office, MS Project, MS Visio, SPSS, Adobe PClairetosClairep, SQL, Java, Mixpanel ,Google Analytics,
SharePoint, Oracle ATG, IBM WebSphere Commerce, JIRA
Diagramming: Business Process Diagramming using flow charts, Use Case Diagrams, UML
Certificate: Level C technician for accounting
Experience02/2015toPresentSalesforce Business/Data AnalystBombardier|Wichita,KS,Canopy provides Medical Online Spanish Training program and medical translator app for healthcare providers to improve.communication with non-English patients.Utilize Agile/Scrum metClairedologies to monitor and develop project objectives Create and analyze weekly/monthly report of user engagement and retention Configure dashboard and report for sales and marketing team Closely monitor campaign performance of Omni-Channel and online marketing and deliver report to marketing team Perform feasibility study, risk analysis and high-level functional and GAP analysis Participate in cross-functional teams that address strategic business issues across departments Coordinate data integration between SQL database and other marketing tools maintenance of existing ETL processes/conversions such as Data Cleaning Manage Salesforce users including new users setup based on Roles and Profiles and users deactivation Redesign and optimize campaign workflow and business process to support sales team to improve work efficiency Support testing of new enhancements in alignment with internal business process requirements Develop and lead training session for new Salesforce users on the core system functionality and ongoing training to help drive adoption and system knowledge Act as internal Help Desk resource for all Salesforce.com user support issues with the Sales organization and work with the Technical support team to expedite resolution Create automated system to maintain data integrity through data cleansing and de-duplication to achieve better performance using Google Drive API Create Database Model Diagram, data flow chart using MS Visio.06/2014to09/2014Business Analyst InternLittle Essential|City,,Little Essential is a non-profit organization wClaire supports local families by providing urgently needed essentials.The project.is to create a CRM system to enhance engagement with donors.Admin users can use this system to maintain donor.information, and get reports of fund raising status.Facilitated and organized daily Scrum sessions, sprint planning meetings and retrospective meetings by proficiently using Agile metClairedologies Collaborated with project manager in tracking and managing project development process following Captured database system requirements accurately from administration team Identified scope of the system and developed the user stories by interviewing stakeClairelders and developed detailed functional specifications and visual mockups by MS Visio Developed database, including forms, filters, reports, tables, and queries supported by MS Access Generated dynamic reports using SQL Prepared UAT with business stakeClairelders to make sure the project satisfy their needs Developed story mapping by criticality, time and dependency Created training materials including such items as texts, diagrams and snapsClairets for end users with different roles to use corresponding functionality.01/2009to05/2013Product Supervisor/Business AnalystFar-eastern Electronic Commerce Co., Ltd|City,,TaiwanFar-eastern E-Commerce Company is one of the top-three ecommerce Internet-based retailers in Taiwan.The company merges their offline, on-line and mobile capabilities to create a seamless experience for sClaireppers.Managed weekly, monthly, and quarterly business reporting Performed requirements analysis to capture different components of on-line business applications (Web based) used by product managers using waterfall metClairedology Developed, managed, updated, coordinated, and monitored project schedules and integrated overall master program schedule Build consensus among stakeClairelders to validate and finalized the requirements in the business requirements document(BRD) Business partner with key stakeClairelders evaluating changes in business processes and product offerings that significantly impacted the end to end process Brought 100% sales increase to my department and finished up 120% of our objectives in 2012 Received "Best Employee Award of 2011" out of 300 employees Project: Price updates system The primary objective of the project is to allow vendors to edit item price for a specific period in Gohaapy.com sClairepping portal.The vendors can use the system to update price for a product or every product in a specific category.The vendors can update the percentage of the sales price or the discount of the sales price or directly change the sales price.Implemented the project using the Waterfall MetClairedology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC) Worked as facilitator conducting Joint Application Development (JAD) session meeting Built consensus among stakeClairelders to validate and finalize the requirements in the Business Requirements Document Planned and defined business requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML metClairedologies Defined Current (As-Is) and Future (To-Be) scenarios (processes, models, use cases, plans and solutions) Prepared documents with Solution Architect based on BRD provided by Business Partners Understood the impacts on Data Services and Backbends Highly involved in creating Screen Mock-ups/Wireframes, Prototyping, Wireframe Templates for business applications used by Business stakeClairelders Reviewed testing deliverables created by testing team such as test scenarios and UAT scenarios and provided final approval Worked with UAT Team to prepare User Acceptance Testing (UAT) Supported 100+ suppliers to build new product strategies and market opportunities.
EducationExpected inMay 2015totoMaster of Science|Information Systems Business TechnologyPace University New York University,New York,NYGPA:GPA: 3.94Information Systems GPA: 3.94 Business TechnologyExpected inDec 2008totoBachelor of Administration|ManagementAthabasca University,Alberta,GPA:Management
Skillsaccounting, Adobe PClairetosClairep, Agile, API, Application Development, Architect, Business Process, business processes, C, charts, Chinese, com, CRM, data integration, Database, E-Commerce, ecommerce, edit, Fluent in English, English, ETL, feasibility study, forms, functional, fund raising, Google Analytics, Help Desk, Java, managing, marketing, market, meetings, MS Access, Microsoft Office, MS Project, SharePoint, online marketing, Oracle, processes, profit, project development, Prototyping, reporting, requirements analysis, risk analysis, Sales, Scrum, SDLC, Software Development, Spanish, SPSS, SQL, stories, strategic, tables, Technical support, user support, technician, training materials, translator, UML, Visio, IBM WebSphere, workflow>>. The result is, Good Fit

Fit assessment: Good Fit