ETL Developer: Data Pipelines & BI Dashboards

Robotics Prcocess Automation, LLC; Dallas (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC designs, configures, develops, tests and deploys ELT/ETL processes and self-service reporting assets to enable data exploration for end users. They proactively communicate with data consumers to improve performance of data workflows and ensure compliance with standards.

The team builds data models, participates in governance, and collaborates with agile teams to groom features and stories, while supporting data warehouses and pipelines across the organization.

Qualifications

• Experience with relational database management systems (Oracle / MS SQL Server).
• Experience with SQL.
• SDLC knowledge and best practices.
• Data wrangling across tools and languages.
• Strong technical writing and presentation skills.
• Data visualization with Tableau, D3.js, R/Shiny, SAP Products.
• Familiarity with JIRA/Trello for project tracking.
• Lean-Agile principles and practices.

Responsibilities

• Designs, configures, develops, tests and deploys ELT/ETL processes and self-service reporting assets.
• Builds data models and supporting data warehouses.
• Interprets process outputs and improves workflow performance.
• Participates in data governance and enterprise Agile ceremonies.
• Provides operational support for data systems and pipelines.

Skills

Relational DBMS

Programming languages

SDLC knowledge

Data wrangling

SQL

Technical writing

Data visualization

Lean-Agile

Data modeling

Process optimization

JSON/BSON/XML parsing

Web APIs

Python

R

Cloud: AWS/Snowflake

Tools

Tableau

D3.js

R/Shiny

SAP Products

Git

CodeCommit

Subversion

JIRA

Trello

AWS

Snowflake

Job description

ROBOTIC PROCESS AUTOMATION LLC designs, configures, develops, tests and deploys ELT/ETL processes and self-service reporting assets to enable data exploration for end users. They proactively communicate with data consumers to improve performance of data workflows and ensure compliance with standards.

The team builds data models, participates in governance, and collaborates with agile teams to groom features and stories, while supporting data warehouses and pipelines across the organization.