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: <<SummaryExperienced Tableau Engineer with critical analytical& statistical knowledge in developing Tableau Dash Boards, Performance Tune and prepare insightful Tableau reports. Built and published customized interactive reports, dashboards, and report scheduling. In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server. Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage. Performed data audits, data profiling activities, providing strategic data to BI teams. Familiar with Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Working knowledge in Windows Servers, API, Network technologies with Active Directory, SAML for authentication. Strong knowledge in SQL, PL/SQL, XML, Python programming and understanding of Data modeling (Dimensional & Relational) concepts Experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint. Involved in Trouble Shooting, Performance tuning of reports, tuning long running SQL and PL/SQL queries for better performance and resolving issues. Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports. Involved in upgrading Tableau platforms in clustered environment and performing content upgrades. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions. Expertise with data architecture, data interoperability and data analytics using Tableau and SQLs Experience in different project methodologies - Waterfall, and Agile/SCRUM Self-starter with ability to motivate teamwork and lead competently in diverse groups. Decision making ability to make sound Engineering, Management judgment. Innate problem solver, able to intellectually articulate business problems, identify critical problems, and achieve targeted results Worked closely with ETL developers and stakeholders to assist them with their agile development life cycle. Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using. Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas). Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
HighlightsBI Tools				: TableauETL Tools          : Informatica, Data Stage, Microsoft SQL Server Integrated ServicesRequirements Management      	: Requisite Pro, Microsoft Office (Word, PowerPoint   Excel)Change Management          : HP Open View, CA Service Manager, Lotus Notesamp; Service ManagementFront End Tools          : Microsoft Project, Microsoft Office, Visible AnalystDatabases          : Oracle 9i, SQL Server, DB2, Sybase, Teradata, MS AccessetcDocument management          : Visual Source Safe 6.0, Share point, Ultra Edit, DocumentumDefect management tool          : HP Quality center 10.0Programming Languages          : C, C++, HTML, SQL, PL/SQL, XML, Python, C#Data modeling          : ERwin, ER Studio, MS Visio Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.Prepared several analytical reports comprised of different data modeling techniques such as time series analysis, financial modeling, and trend mapping and supported in MATLAB programmingCollecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platformEnvironments: SQL/PL-SQL, ETL, Oracle, Windows Server, VMware, Active Directory, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, MS SQL, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, AngularJS, SQL Server, SSIS 2008, SSRS 2008, DB2, T-SQL, Oracle and SSMS, Asp.Net, C#, J-Query, MATLAB, Cognos 8.4,10.1 connection MS Office Suite, MS Visio, HTML, UML, C++, Java, MS Visual Basic, VB Script, Test Director, Client Server, Windows XP, MS Access, MS SQL, .NET, Agile, SOA
Experience01/1toPresentTableau Developer /Data AnalystAlteryx Inc.|,OR,Develop various Tableau dashboards and analytical reports and solutions for marketing efforts on medical products and business groups, using Calculations, Filters, Parameters and complex statistical analytics features of Tableau.Work on technical strategy, provided hardware and software configuration, understood client-wide BI implementation project, design and develop visualizations as per requested by CEO and CFO Adjust views/dashboards after initial POC presentation to CEO and CFO.Create views and dashboards on end client's sales data.Produce powerful dashboards using pie, bar, geo, and line charts that are viewed daily by CEO and CFO.Developed and modified database procedures, functions, packages to enhance and improve functionality using PL/SQL.Design and development of Tableau software applications to support reporting and Business Intelligence initiatives, using data analytics, visualization, reporting using OLAP (Online Analytical Processing), data mining, SQL, UNIX, Linux, and Java portal technologies; Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.Design and develop workbooks, global filter page, and complex parameters based calculations.Create action filters, parameters and calculate sets for preparing dashboards and worksheets in Tableau Access and transform massive campaign datasets through filtering, grouping, aggregation, and statistical calculation.Develop Tableau workbooks from multiple data sources using Data Blending.Work with team of developers to design and develop BI solutions on various marketing and campaign KPIs.Responsible for the design and development of data warehouse, analytics and visualization to meet the big data needs of various products and businesses.Design and deploy rich Graphic visualizations with drill down, and drop down and parameters from ERP databases and complex Dashboard and Storyboard Attributes, Hierarchies, Transformations, Filters, Prompts, Calculated fields, Sets, Groups.Created, organized and formatted reports, folders and other contents on Cognos Connection portal.Involved in migration of Cognos adhoc reports to Tableau workbooks.Converted business requirements into technical specification and design for Reporting Database/data mart, and Adhoc/standard reporting using Cognos 8BI.Perform query search via SQL knowledge and understanding of Data modeling (Dimensional & Relational) concepts Design different front-end forms & dynamic pages using CSS, HTML & given functionality with JavaScript, HTML5, CSS, JavaScript, JQuery, Angular.js Environments: Tableau Server, Tableau Desktop, Agile/Linux, HTML5, CSS, JavaScript, JQuery, Angular.js, Java Portal, PL/SQL, Windows Server, Oracle 10g/9i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA SCRIPT, J2EE,PL/SQL, Tomcat, MS Visio, MS SQL, Teradata, IBM Cognos 8.4,10.1 connection.01/1to01/1Sr. BI Consultant/ Tableau DeveloperGalaxy Solutions|,CT,Created and assisted users in Tableau dashboard development.Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters, Trend Lines, Statistics, and Log Axes.Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.Developed and designed User Interface using JavaScript, HTML/HTML5, CSS3, HTML5, jQuery, SASS, and AngularJS Performed relational database design and normalization, client-server development, OLAP analysis using pivot charts Migrated Cognos dashboards to Tableau showing Year over Year comparison of different key metrics, Premiums Vs Losses, IBNR etc.Developed Cognos Reports in compliance with user reporting standards Created Tableau extract files for improving the performance.Implemented various Validation Controls for form validation and implemented custom validation controls with JavaScript validation controls.Wrote DDL or DML SQL commands, visualizations in Tableau, to improve data quality, analyzed complex data systems and document data elements, data flow, relationships and dependencies describing what/how/where/why data is stored and how to access the data.Created SSIS packages using C# scripting, script components and script tasks for various Control Flow Tasks and Data flow.Worked with DBAs in order to schedule SSIS packages as jobs either daily, weekly, monthly.Wrote complex PL/SQL queries and designed SSIS packages to load the data into warehouse.Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.Created the test environment for Staging area, loading the Staging area with data from multiple sources.01/1to01/1Business Intelligence Analyst|City,STATE,Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Prepared Tableau dashboards using advanced features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.Created detailed technical design documents.Created Data Model for interface.Performed Logical and Physical data modeling within Tableau Server Experienced in Tableau Server Infrastructure: Installation & configuration of Tableau Server in clustered environment and REST API implementation.Involved in the production support and enhancement of the Sharepoint databases.Redesigned standards and procedures and bills of material tables.Created data maps using Informatica Power Exchange 5.1.2.Extensively used lookup, Expression, Aggregator, Normalizer transformation Performed Informatica code reviews.Created ETL design for real time data processing.Designed and implemented Informatica maps, workflows, schedules and scripts.Implemented mapping level data auditing and error handling, source to target mapping.Performed performance tuning of Informatica mappings and databases Involved in upgrading Tableau platforms in clustered environment and performing content upgrades.Wrote stored procedures/Triggers/Views in SQL server and Oracle Developed implementation plans for the SAP modules PP and PP-PI.Implemented Material Variant, Object dependencies, Variant Table, Functions, Variant Pricing, Order BOM and also managed implementation of PP and PP-PI design on SAP 4.7C release Experience in designing Business View Manager, Business Objects universes, complex Crystal and BO reports both Full and Thin Client Reports.Developed reports using Business Objects Web Intelligence to cater Ad-hoc reporting needs.Created reports using Business Objects functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formulae's.Used SQL Server Integrations Services (SSIS) to extract data (ETL), and quickly load data into SQL Server table, and handle data quality issues.Used SQL Server Reporting Services (SSRS) - Reporting Services Components and Business Intelligence Development Studio (BIDS) in order to design and develop reports.Worked in Windows Servers, API, Network technologies with Active Directory, SAML for authentication Environments: SAP BW/BO, SAP Business Objects XI R2 SP2,XIR 3.1 SP3, Designer, Infoview, Web Intelligence, Data Stage 8.1,Sql, PL/SQL, SQL server 2008, Xcelsius 2008,Live Office, Oracle 10g, Windows Server 2003,Clear Case,Clear Quest.MS Excel, MS SQL Server 2008/12 R2, Win Server 2008 R2, Active Directory, Oracle, Windows Server, VMware, Virtualization, Linux, Systems Engineering, Servers, Cisco Systems Products, VMware ESX, Microsoft Exchange, MS Office Suite, MS Visio, HTML, MS Access, JavaScript, HTML/HTML5, CSS3, DOM, XHTML, AJAX and jQuery, Bootstrap, SASS, AngularJS.08/2016to11/2016Business AnalystNA|City,STATE,Worked as a Data Analyst/ Business System Analyst and assisted the project manager in defining the Scope, Best Practices, Schedule, Business Change Management, and Develop Feasibility Study Report for Preliminary Study of the Project and Budget of the Project.Assisted the team members with documentations like Business Requirement Document and Use Case Specification Document by using DOORs, and Best Practice initiatives.Assisted in Data Analysis by Data Mapping then worked with the design team in the designing of the Databases with extensive use of ERDs for Data Validation, Data Modeling, Data Migration, Reference Data Analysis, and Data Conversion.Designed and developed Use Case Diagrams, Activity Diagrams and Sequence Diagrams by using MS Visio.Created a Decision Support System via Dimensional Modeling by ensuring appropriate FACTS tables, DIMENSIONS tables, attributes, and entities in order to generate MEASURES as required in Data Warehousing (EDW) and Data Migration by business users.Resource monitoring and repository Audit reporting.Worked on Backup and restoration.
EducationExpected intotoBachelor of Science|Chemical EngineeringOklahoma State University,Stillwater,OklahomaGPA:Chemical Engineering
Skills.NET, Asp.Net, Active Directory, Ad, Agile, AJAX, Analyst, API, Audit reporting, auditing, Backup, basic, big data, Budget, BI, Business Intelligence, Business Objects, C, C++, Change Management, charts, Cisco, Client Server, client-server, CMS, Cognos 8.4, Cognos, CA, hardware, content, Crystal, CSS, CSS3, Client, Data Analyst, Data Analysis, Data Conversion, data processing, Data Migration, data mining, Data Modeling, Data Validation, data warehouse, Databases, Database, Data Stage 8.1, Data Warehousing, Decision Support, designing, DIMENSIONS, DML, Document management, Documentum, DOM, DOORs, Edit, ERP, ERwin, ETL, XML, Feasibility Study, features, financial modeling, forms, Graphic, HP, Open View, HTML, HTML5, IBM, DB2, Informatica, J2EE, Java, JavaScript, JAVA SCRIPT, JQuery, J-Query, Linux, Lotus Notes, marketing, MATLAB, Access, MS Access, C#, MS Excel, Excel, Exchange 5.1.2, Microsoft Exchange, Microsoft Office, MS Office Suite, Office, PowerPoint, PP, Microsoft Project, Sharepoint, Share point, Win, Windows, 3.1, Windows XP, Word, migration, Modeling, Network, OLAP, Oracle 9, Oracle, PL-SQL, PL/SQL, page, Pricing, Programming, Python, Quality, Quest, real time, relational database design, reporting, Requirement, sales, SAP BW, SAP, SAP 4.7, Servers, scripting, scripts, script, Visual Source Safe 6.0, Specification, Sql, MS SQL Server, MS SQL, Microsoft SQL Server, SQL Server, Statistics, strategy, Sybase, System Analyst, Systems Engineering, Tableau, tables, Teradata, Test Director, Tomcat, T-SQL, Trend, UML, UNIX, upgrades, upgrading, User Interface, Validation, VB Script, View, Visio, MS Visual Basic, Web Intelligence, Windows Server, XHTML>>. The result is, Good Fit

Fit assessment: Good Fit