Lead Data Analyst
TIAA · Dallas, TX
- On site
- Full-time
- $132,000 / year
- Dallas, TX
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Analyze complex datasets for business insights.
- Translate business needs into technical data solutions.
- Ensure data quality and governance standards.
- Develop ETL processes and work with cloud platforms.
- Communicate findings to technical/non-technical audiences.
About the role
Lead Data Analyst
TIAA is seeking a Lead Data Analyst to join their team. This role involves programming and configuring software to meet organizational business needs. You will analyze complex datasets to identify trends, patterns, and insights that support business objectives, and translate business requirements into technical specifications for data solutions.
As a subject matter expert in Applications Development & Support, you will perform data profiling, Source to Target mapping, and validation to ensure accuracy and consistency. You will also support the implementation and maintenance of data governance frameworks and standards, ensuring data quality through regular audits and adherence to data management policies. Documenting data flows, data lineage, and system integrations across upstream and downstream systems is a key responsibility. Collaboration with stakeholders to define and maintain data definitions, business rules, and metadata is essential.
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 platforms 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
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.
Key Skills/Competency
- Data Analysis
- SQL
- Data Warehousing
- Data Modeling
- ETL
- Cloud Data Platforms
- Data Governance
- Business Intelligence
- Problem Solving
- Communication
Skills & topics
- Lead Data Analyst
- Data Analysis
- SQL
- Data Warehousing
- Data Modeling
- ETL
- Cloud Data Platforms
- Data Governance
- Business Intelligence
- TIAA
- AWS
- Azure
- Google Cloud
- Tableau
- Power BI
- Agile Methodology
- Software Development
How to get hired
- Customize your resume: Highlight your 5+ years of SQL experience and data warehousing/modeling skills.
- Showcase cloud and ETL expertise: Emphasize your experience with cloud platforms and data integration tools.
- Demonstrate data governance knowledge: Detail your experience with data governance activities and tools like Collibra.
- Prepare for technical questions: Be ready to discuss data analysis, SQL, data modeling, and ETL processes.
- Research TIAA's values: Align your application and interview responses with TIAA's mission and culture of impact.
Technical preparation
Master SQL for complex queries and data manipulation.,Practice data warehousing and dimensional modeling concepts.,Gain hands-on experience with cloud data platforms.,Build and document ETL processes for data integration.
Behavioral questions
Describe a complex data analysis project.,How do you translate business needs into data solutions?,How do you ensure data quality and governance?,How do you communicate technical findings effectively?
Frequently asked questions
- What is the expected career level for a Lead Data Analyst at TIAA?
- The Lead Data Analyst role at TIAA is classified as Career Level 8IC, indicating an individual contributor role with significant expertise and leadership potential.
- What are the primary technical skills required for this Lead Data Analyst position?
- Key technical skills include 5+ years of SQL and relational database management, 3+ years in data warehousing and data modeling, and 2+ years with cloud-based data platforms (AWS, Azure, GCP) and ETL processes.
- Does TIAA prefer a specific educational background for the Lead Data Analyst role?
- While a university degree is preferred for the Lead Data Analyst position, TIAA also strongly emphasizes the required work experience of 5+ years, with 7+ years being preferred.
- What is the anticipated salary range for the Lead Data Analyst job at TIAA?
- The base pay range for this Lead Data Analyst position is $101,000 to $132,000 annually, with actual salary dependent on relevant experience and other factors.
- How does TIAA approach data governance and quality for its data analysts?
- TIAA emphasizes data governance through required experience in data cataloging, source to target mappings, and adherence to data management policies, ensuring data quality via regular audits and validation.
- What is TIAA's stance on remote work for the Lead Data Analyst role?
- The job description emphasizes a collaborative in-office environment, suggesting that this Lead Data Analyst role is likely on-site or hybrid, focusing on teams working across organizational boundaries.
- Are there opportunities for career growth within TIAA for a Lead Data Analyst?
- TIAA offers meaningful learning experiences and development pathways, encouraging associates to grow their skills and advance their careers, particularly within their mission-driven culture.
- What domain knowledge is preferred for this Lead Data Analyst position at TIAA?
- Financial/Asset Management domain knowledge is preferred for this Lead Data Analyst role, which would be beneficial given TIAA's industry.