TransUnionRemote
Lead Engineer, Data Development
Illinois, United States of America
Full Time
1 week ago
$107,598 - $115,802 USD
Visa Sponsor
Key skills
ETLJavaOracleSQLSSISTableauVBAAnalyticsStatistical AnalysisSQL Server
About this role
Role Overview
- Develop statistical processes that produce reports and analytics for clients in the financial services industry
- Analyze data and utilize advanced statistical techniques to test data quality and create benchmark solutions
- Work directly with clients and other financial institutions to resolve critical issues in data quality
- Develop proof-of-concept statistical processes involving diverse data sets
- Engage in data loading, cleansing, transforming, processing, and validation
- Improve existing SQL-DTS packages to transform into a SSIS master package
- Develop predictive algorithms with SSIS to generate modeling data for statistical analysis
- Validate predicted data by completing trend analysis, population behavior analysis, and related statistical analysis techniques
- Responsible for processing and validating modeling data from different markets including the US, UK, Canada, and Australia
Requirements
- Master’s degree in Computer Science, Statistics, Mathematics, Business Administration, or a related field plus 2 years of experience in Data analytics required
- Bachelor's degree in Computer Science, Statistics, Mathematics, Business Administration, or a related field plus 5 years of progressive experience in Data analytics also acceptable
- SQL Server
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- VBA
- MS Visio
- Tableau
- Qlikview
- Java
- Oracle
- XML
- DTS packages
- ETL processes
- experience manipulating, analyzing, and modeling based on large datasets
- experience in Financial Services and Analytical Consulting Services
Tech Stack
- ETL
- Java
- Oracle
- SQL
- SSIS
- Tableau
- VBA
Benefits
- flexible time off for exempt associates
- paid time off for non-exempt associates
- up to 12 paid holidays per year
- health benefits (including medical, dental, and vision plan options and health spending accounts)
- mental health support
- disability benefits
- up to 12 weeks of paid parental leave
- adoption assistance
- fertility planning coverage
- legal benefits
- long-term care insurance
- commuter benefits
- tuition reimbursement
- charity gift matching
- employee stock purchase plan
- 401(k) retirement savings with employer match
- access to TransUnion’s Employee Resource Groups