Sr Data Analyst w/ SQL
Apply NowCompany: Saxon Global
Location: Charlotte, NC 28269
Description:
Top 5 Needs:
Must Haves
Nice to Have
- 6+ years of Data Analysis
- SQL Development experience
- Teradata Knowledge
- Able to read and write Python
Must Haves
- They need to be very good technically. Advanced SQL developer.
- Stored procedure, write complex queries. The important thing is writing queries to pull the correct data.
- Ex: They need to know an employee salary structure and pull that out, or find a missing interest floor across .
- Able to read/write Python scripts
- Banking background, or relevant financial services experience
- Must know: commitment, interest rates, obligations, etc.
- Teradata
- The data is in Teradata tables. They need to pull obligation loan data using Teradata.
- TSQL database
- Skilled in data analysis. Demonstrate critical thinking and understanding of banking & financial concepts.
- Ex: WalMart needs to build a new facility and needs a loan for $100M. But doesn't want the entire loan all at once, because they will have the burden of the entire interest. So they'll take $10M this month, $5M the next, etc. They will need to determine the weighted average of interest rate. Whether a business has one facility, multiple facilities, and multiple obligations. When someone writes SQL code, they should be able to write this kind of relationship into the data.
- Data lineage - They need to understand the process -- how data is moving from one place to the next. From iHub Staging table, etc.
- Agile / Jira
- Must be organized with strong attention to detail.
Nice to Have
- Some hands-on experience with Alteryx
- Able to write queries and integrate that with Alteryx