Position: Data engineering/Data Analyst role
Location: Richmond, VA, McLean VA, Hybrid, Local to Richmond Prefer
Duration: 3 months - (Based on Performance Extension Possible)
USC/GC
Data engineering/Data Analyst role
Looking for person help in lot of complex SQL.
100-1000 of lines in SQL
Concern with data of the product
Building from scratch using lot of tools.
Transfer data from one system to another
Pipelines for data transfer.
SQL expertise in must
Converting tableau reports to AWS quicksight.
In line with target architecture
Understand Quicksight, access provision,
SQL and Quicksight must
Snowflake database
Some reporting from analytical databases
Large data queries running on snowflake so should know how to optimize data on snowflake.
Python - automation efforts are done in asset 360.
Python is used for automation.
Must have
Python scripting and automation
SQL
Snowflake
AWS QuickSight, S3, EC2, security groups and assess controls.
Tableau - nice to have.
One round - one hour - video interview - panel - Q&A, based on resume, situation based, walking through the scenario of how dashboard is created.
Basic understanding of Quicksight is necessary as large number of dashboards are moving to Quicksight.
Initial work
Converting dashboards and reports to Quicksight.
Dealing with Complex SQL reports, changes, migration