Lead Data Analyst

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). Desired Skills 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 Equal Opportunity We are an Equal Opportunity Employer. TIAA does not discriminate against any candidate or employee on the basis of age, race, color, national origin, sex, religion, veteran status, disability, sexual orientation, gender identity, or any other legally protected status. Pay Range $107,000/yr - $141,000/yr #J-18808-Ljbffr