Job Summary
As an Associate Engineer, you will contribute to implementing the Commercial Card roadmap, including ETL processes, data modeling, and data quality enhancements. The role involves configuring data ingestion for bank and processor feeds, implementing new functionalities for rebate solutions, supporting UAT, bug fixes, production deployment, and code migration.
Key Responsibilities
- Develop standardized data models and define data types and relationships between database attributes.
- Utilize MSSQL, TSQL, PostgreSQL, and Python to develop tools for data mining, analysis, and visualization.
- Build complex algorithms and data transformation logic using SQL to align and load data into relational databases, data extracts, and reports.
- Write complex SQL queries for data manipulation, insertion, deletion, and updates.
- Ensure SLAs and business agreements for deliverables are met on a daily, weekly, or monthly basis.
- Maintain industry-standard documentation, operational manuals, and runbooks for production processes.
- Review code to ensure accuracy, adherence to standards, and optimization for performance.
- Collaborate with functional teams to resolve issues and ensure product quality.
Additional Responsibilities
- Escalate issues or risks to management with recommendations for mitigation or resolution.
- Track and validate progress of monthly and daily processes, providing timely updates to the team to identify issues early.
- Inform clients and escalate risks to SLA as necessary.
Qualifications
- Education: Bachelor’s/Master’s Degree in Computer Science, Information Technology, or a related field.
- Eligible Batches: 2023, 2024.
Technical Skills Required
MSSQL, TSQL, PostgreSQL, Python, ETL, Data Modeling, Data Quality, SQL Queries, Data Mining, Data Analysis, Data Visualization, Rebate Solutions, Code Optimization, SLA Management, Documentation, Agile Development.
Additional Information
This is a hybrid role requiring in-person attendance at a TransUnion office location for a minimum of two days per week. The role demands collaboration with both onshore and offshore teams to ensure seamless execution and delivery of business requirements.
