Data Cleanse Developer

Tucker Rose Associates

Defines and executes project systems engineering activities that may consist of systems planning, performance management, capacity planning, testing..

SUMMARY:
Tucker Rose Associates is seeking a Data Cleanse Developer help support a program/group at the US Department of Veterans Affairs in Austin, TX.
  
RESPONSIBILITIES:
· Defines and executes project systems engineering activities that may consist of systems planning, performance management, capacity planning, testing and validation, benchmarking, information engineering, and systems engineering plan development and staffing.
· Provide subject matter expertise on performance tuning and query optimization to data analysts, data scientists, data warehouse developers, and full-stack peers
· Participate in building, enhancing, and owning a DevOps culture following Agile/Scrum Methodology
· Experience working in an Agile Project Management environment
· Enforcing code documentation, framework standards, and team processes
  
REQUIREMENTS:
· Bachelor’s Degree in Computer Science, Engineering, Math, or equivalent
· 6+ yrs. of experience in the Information Technology Industry
· Advanced Oracle/SQL scripting skill
· Systems Engineer experience in Script Automation/DevOps tools (job schedulers, creating Windows executables, Jenkins/Python pipeline, etc.)
· ETL or data cleanse experience
· Experience building custom reports
· Experience with Momentum database
· Windows command, PowerShell, or AIX/Linux/Unix/Perl scripting experience
· Extensive experience developing data-intensive solutions in large data warehouse environments using RDBMS, such as SQL Server (preferred), Postgres, DB2, Oracle
· Highly advanced writing SQL queries, DML and DDL, CDC/change tracking patterns, data cleansing, indexes and performance tuning.
· Enterprise development experience coding in at least one, but preferably more than one, procedural/OO language, e.g., C#, Python, PowerShell
· Detecting data patterns and issues
· Data engineer experience leading dynamic data pipeline builds
· Experience using Tableau and Power BI or similar data visualization tool
· Led a successful team of at least 5 (Scrum Team size)
· Exposure to Enterprise Data Warehouse, Data Lake, Big Data, unstructured data, in-memory data stores and column store Indexing
· Ability to be flexible with scheduling (sometimes we work long hours, weekends, nights, etc.)