An understanding of data architecture and modeling practices and concepts including entity-relationship diagrams, normalization, abstraction, denormalization, dimensional modeling, and meta data modeling practices.
Financial\Asset Management domain knowledge is preferred.
Experience with data visualization and reporting tools (e.g., Tableau, Power BI, or similar platforms)
Usage of MYGAIT and prompting.
Related Skills
Agile Methodology, Continuous Integration and Deployment, Data Analysis, Debugging, DevOps, Enterprise Application Integration, Operating Systems Management, Problem Solving, Programming, Software Development, Software Development Life Cycle, Web Application Development
At TIAA, we're on a mission to build on our 100+ year legacy of delivering for our clients while evolving to meet tomorrow's challenges. We equip our associates with future-focused skills and AI tools that enable us to advance our mission. Together, we are fighting to ensure a more secure fin
Benefits
Vision insurance
Additional Information
The Lead App Development & Support job programs and configures software to meet the organization's business needs. Under limited supervision, this job identifies and analyzes business software needs, writes complex code to optimize the performance and efficiency of the organization's IT platform/infrastructure and conducts testing to ensure programs are functioning properly. This job is considered a subject matter expert in the Applications Development & Support area.
Key Responsibilities and Duties
Analyze complex datasets to identify trends, patterns, and insights that support business objectives
Translate business requirements into technical specifications for data solutions
Perform data profiling, Source to Target mapping, and validation to ensure accuracy and consistency
Support the implementation and maintenance of data governance frameworks and standards
Ensure data quality through regular audits, validation processes, and adherence to data management policies
Document data flows, data lineage, and system integrations across upstream and downstream systems
Collaborate with stakeholders to define and maintain data definitions, business rules, and metadata
Help design and develop ETL (Extract, Transform, Load) processes to support data integration initiatives
Work with cloud based data platform and relational databases, SQL queries, and data modeling techniques to support analytical needs
Troubleshoot data-related issues and provide technical support for production systems
Participate in testing activities by supporting QA resources with test case development, execution, and defect tracking
Partner with business stakeholders, IT teams (ETL, QA & Production support)
Communicate findings, insights, and recommendations clearly to both technical and non-technical audiences
Participate in cross-functional project teams to support enterprise and vertical initiatives
Contribute to continuous improvement efforts by identifying opportunities for automation and process optimization
Educational Requirements
University (Degree) Preferred
Work Experience
5+ Years Required; 7+ Years Preferred
Physical Requirements
Physical Requirements: Sedentary Work
Career Level
8IC
Required Skills -
5 or more years' of experience in SQL and relational database management systems.
3 or more years' of experience with data warehouse concepts and data modeling concepts and practices
2 or more years' of experience with cloud-based data platforms (e.g., AWS, Azure, Google Cloud)
2 or more years' of experience in ETL processes and data integration tools
Experience in Microsoft Excel (Advanced formulas, pivot tables, and data manipulation)
Experience in data governance activities (Business Glossary, Data catalogs, source to target mappings) and exposure to Collibra is preferred.
Experience of Reference data management (tools like EDM / DRM preferred).
Tiaa · Dallas, TX