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: <<SummarySeasoned Data Architect adept at understanding mandates, developing plans and implementing enterprise-wide solutions. Complex problem-solver with an innovative approach. Ready to bring 1O-plus years of progressive experience and take on a challenging new role with growth potential.
SkillsData ManagementOrganizational SkillsCritical ThinkingTeam ManagementProblem ResolutionCustomer ServiceRelationship BuildingTeam BuildingSupervision & LeadershipPlanning & OrganizingFriendly, Positive Attitude
Experience08/2016toCurrentSr. Data Engineer | ArchitectHoneywell–Baltimore,MD,Used statistical software to analyze and process large data sets.Followed industry innovations and emerging trends through scientific articles, conference papers or self-directed research.Distilled data to devise solutions related to budgeting, staffing and marketing decisions.Recommended data analysis tools to address business issues.Provided global thought leadership in analytics solutions to benefit customers.Captured and shared best-practice knowledge amongst developers community.Cleaned and manipulated raw data.Created graphs and charts detailing data analysis results.Managed performance monitoring and tuning while identifying and repairing issues within database realm.Developed new functions and applications to conduct analyses.Assisted solution providers with definition and implementation of technical and business strategies.Tested, validated and reformulated models to foster accurate prediction of outcomes.Contributed to maintaining Azure-SQL, SQL Sever and DB2 databases in conjunction with data development and software engineering teams.Adept in troubleshooting and identifying current issues and providing effective solutions.Promoted customer success in building and migrating applications, software and services on Azure platform.Collaborated with solution architects to define database and analytics engagement strategies for operational territories and key accounts.01/2016to08/2016Sr. ETL DeveloperMillennium Health–City,STATE,Assessed code during testing stage to determine potential glitches and bugs.Conferred with project managers and other stakeholders to fully understand software design specifications and plan optimal development approaches.Employed integrated development environments (IDEs).Devised automation, backup and recovery protocols to preserve and safeguard data.Analyzed user needs and software requirements to determine design feasibility.Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.Applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.Designed customized technical solutions to meet functional specifications outlined by Millennium Health database customers.Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.Collaborated with Architects to define data extraction methodologies and data source tracking protocols.Utilized established design patterns to expedite novel software creation and support consistent performance results.Integrated object-oriented design and development techniques into projects to support usability goals.Analyzed code and corrected errors to optimize output.Identified opportunities for process improvements to decrease in support calls.Defined and documented SSIS ETL data mapping plans using Windows PowerShell scripting and custom solution from vendors (i.e. Pragmatic Works).Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.Assisted in User Acceptance Testing for Millennium customers, verifying ETL jobs complied with assigned parameters, achieving success during execution phasesCombined root-level authentication and authorization technologies with ongoing system design to harden finished solutions.Applied prescribed policies to programming syntax in compliance with internal language policies.Modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.Developed software for embedded systems, coding solutions for both new installations and in-situ hardware.Performed troubleshooting of post-release software faults to support live service and installed software patch design.Developed requirements for system modifications and new system installations.Recommended improvements to facilitate team and project workflow.Coordinated testing and validation procedures through software development lifecycle.Managed end-to-end operations of ETL data pipelines, maintaining uptime of 96%.Improved and corrected existing software and system applications.Applied Conceptual, Logical and Physical & Dimensional/Relational model designs to ETL tasks.05/2013to10/2015Sr. Database App | BI DeveloperTransCanada Corporation–City,STATE,Analyzed and developed technical and functional specifications for databases.Developed and updated all documentation related to database technologies for department.Built integrations from multiple data sources, including Salesforce and Pardot.Identified databases not reaching peak performance and determined ways to solve concerns.Applied various skills to evaluate, design, implement and optimize databases and database applications.Managed financial management systems, customer and production databases and inventory, production equipment and editing systems.Provided support to clients in understanding and manipulating data to obtain value through SQL and ETL technical processes and visual analytics tools.Managed all levels of internal analytics practice, including ETL, database administration, report development and integration.Produced complex database project with zero issues due to effective troubleshooting.Developed, designed and optimized data structures for analysis.Partnered with project management teams on development of scope and timelines.Assisted clients in understanding and manipulating data to gain value through SQL and ETL technical processes and visual analytics tools.Developed data models and database designs to plan projects.Developed and implemented security initiatives to protect important company data.Constructed database and warehouse, streamlined disparate data sources and unverified queries into main source.Wrote scripts and processes for data integration and bug fixes.Planned, designed and streamlined data structures for analysis.Supervised all levels of internal analytics practice, including ETL, database administration, report creation and integration.Built database and warehouse, including consolidating disparate data sources and unverified queries into central source.Created integrations from various data sources, including Salesforce and ERD Systems.02/2011to04/2013Database Application DeveloperBarclays Plc–City,STATE,Modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.Utilized established design patterns to expedite novel software creation and support consistent performance results.Employed integrated development environments (IDEs).Developed logic flowcharts and diagrams to use in program coding and workflow planning.Developed software for embedded systems, coding solutions for both new installations and in-situ hardware.Identified opportunities for process improvements to decrease in support calls.Analyzed code and corrected errors to optimize output.Liaised with clients to clarify business challenges and objectives to optimize performance of existing systems.Trained and coached new hires and junior developers and shared insight into ways to meet tight deadlines and improve overall efficiency.Coordinated testing and validation procedures through software development lifecycle.Combined root-level authentication and authorization technologies with ongoing system design to harden finished solutions.Identified, debugged and fixed system bottlenecks and problems.Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.Devised automation, backup and recovery protocols to preserve and safeguard data.Applied innovative approaches to application design through creative inception and planning.Contributed to requirements gathering and design development meetings.Improved and corrected existing software and system applications.Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.Assessed code during testing stage to determine potential glitches and bugs.Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.Conferred with project managers and other stakeholders to fully understand software design specifications and plan optimal development approaches.Applied prescribed policies to programming syntax in compliance with internal language policies.Recommended strategies to maximize performance and lifespan of equipment involved in software installations.Developed requirements for system modifications and new system installations.Performed testing on user defined functions and triggers.Utilized best practices to identify and remedy bugs in applications within specific timeframe.Recommended improvements to facilitate team and project workflow.Optimized application process flow to improve performance.Programmed applications and tools using object-oriented languages with goals of code abstraction, stability and reuse.Updated software upon release of vendor patches to mitigate vulnerabilities.Monitored equipment function to verify conformance with specifications.Analyzed user needs and software requirements to determine design feasibility.Applied application product support to contractors located internationally.Worked closely with brand and marketing teams across organizations to promote specific applications.Increased efficiency through task automation.Applied security measures into systems development, supporting final products' resistance to intrusion and exploitation.Assessed project scope to identify necessary requirements.Established clear system performance standards and wrote specifications.Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.Integrated object-oriented design and development techniques into projects to support usability goals.Reviewed project requirements to identify customer expectations and resources needed to meet goals.Performed troubleshooting of post-release software faults to support live service and installed software patch design.
Education and TrainingExpected in07/2006totoBachelor of Science:Electrical Electronics EngineeringUniversity Of Leicester-Leicestershire, England,GPA:>>. The result is, Good Fit

Fit assessment: Good Fit