Role: Senior level Data Analyst (12+ years)
100% remote (Local to Dallas, Texas or local to Texas candidates are preferred)
Tools: SQL Developer (Oracle), SQL Server (SSMS), SSIS packages, Snowflake cloud, Mainframe related tools, Visual studio, Erwin/E-R studio.
Detailed Skillset
Data Analysis Techniques
SQL proficiency
Joins
Sub queries
procedures
Database languages (SQL Server, Oracle, Snowflake, Postgres)
Data Modeling
Normalization and de-normalization
OLTP and OLAP
Erwin/E-R studio/DB Schema
Data migration experience
ETL Experience
SSIS
Informatica
ETL vs ELT
Change Data Capture (CDC)
Slow Changing Dimensions (SCDs) – Type 1 & Type 2
Mainframe SQL experience
Azure DevOps (ADO)
Snowflake cloud