Lead Data Analyst

TIAA•Frisco, TX

3d•Onsite

About The Position

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.

Requirements

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).
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.

Nice To Haves

University (Degree) Preferred

Responsibilities

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