Cybersecurity Data Warehouse Lead Developer

TIAA has an opportunity for a Cybersecurity Data Warehouse Lead Developer to join their Security Applications Development team. This role will design, develop, and maintain data warehouses and data lakes in our enterprise cloud environment. This includes but is not limited to the development of dashboards, interactive analytical reports, extracts, and other data visualization tools. In addition, will design, schedule, and maintain ETL jobs to support the enterprise reporting and metrics.

This role will have responsibility for leading projects, monitoring and troubleshooting data lake performance and maintenance of cybersecurity reporting tools. This is a team lead role which will have responsibility for oversight and mentoring of a team.

Key Responsibilities and Duties

• Serve as a subject matter expert (SME) for cybersecurity on data warehouse and metrics.

• Designs, creates, deploys, and updates programs for a specific device, the web, or an operating system.

• Collaborate with cyber security teams to understand needs and determine appropriate solutions.

• Translates client requirements into application features and ensures the timely delivery of fully functional software applications.

• Creates metrics and dashboards.

• Perform code reviews.

• Develop and deploy ETL jobs.

• Understand client needs, designing prototypes, writing code, performing testing, and maintaining technical documentation.

• Write high-quality code to program complete applications on schedule.

• Drive progress on various database development activities.

• Mentor and train junior members of the development team.

• Coordinate with Business Analysts on metrics and dashboard requirements.

Educational Requirements

• Bachelor's Degree Required

Work Experience

• 5 Years Required; 7 Years Preferred

Physical Requirements

• Physical Requirements: Sedentary Work

Career Level

9IC

Qualifications:

Required:

• 5 years’ experience writing SQL queries and creating procedures.

• 5 years’ experience developing with AWS Glue, AWS Lambda, and EC2.

• At least 3 years’ experience with SQL Server data warehouse development.

• At least 3 years’ experience working on a database development team.

• At least 3 years’ experience developing metrics and reporting.

• At least 2 years’ experience working in a cybersecurity environment.

• 2 years’ experience leading a team.

Preferred:

• Possess in-depth knowledge of programming for diverse operating systems and platforms using development tools.

• Experience performing analyses and problem-solving.

• Attention to details and time-management skills.

• 2+ years of experience with project management.

• Experience managing contractors working on the team.

• Experience with Snowflake or Redshift databases.

#LI-VR

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

Anticipated Posting End Date:

2024-11-30

Base Pay Range: $104,900/yr. - $169,800/yr.

Actual base salary may vary based upon, but not limited to, relevant experience, time in role, base salary of internal peers, prior performance, business sector, and geographic location. In addition to base salary, the competitive compensation package may include, depending on the role, participation in an incentive program linked to performance (for example, annual discretionary incentive programs, non-annual sales incentive plans, or other non-annual incentive plans).

Company Overview

Every worker deserves a secure retirement. For more than 100 years, TIAA has delivered it for millions of people. Founded to help educators retire with dignity, today weʼre a market-leading retirement company fueled by world-class asset management. But weʼre not just another legacy financial services firm. Weʼre fighting harder than ever before for our clients and the many Americans who need us.

Benefits and Total Rewards

The organization is committed to making financial well-being possible for its clients, and is equally committed to the well-being of our associates. That’s why we offer a comprehensive Total Rewards package designed to make a positive difference in the lives of our associates and their loved ones. Our benefits include a superior retirement program and highly competitive health, wellness and work life offerings that can help you achieve and maintain your best possible physical, emotional and financial well-being. To learn more about your benefits, please review our Benefits Summary (https://www.tiaa.org/public/pdf/benefits-at-a-glance.pdf) .

Equal Opportunity

We are an Equal Opportunity/Affirmative Action Employer. We consider all qualified applicants for employment regardless of age, race, color, national origin, sex, religion, veteran status, disability, sexual orientation, gender identity, or any other protected status.

Read more about the Equal Opportunity Law here (https://www.dol.gov/general/topics/posters) .

Accessibility Support

TIAA offers support for those who need assistance with our online application process to provide an equal employment opportunity to all job seekers, including individuals with disabilities.

If you are a U.S. applicant and desire a reasonable accommodation to complete a job application please use one of the below options to contact our accessibility support team:

Phone: (800) 842-2755

Email: accessibility.support@tiaa.org

Privacy Notices

For Applicants of TIAA, Nuveen and Affiliates residing in US (other than California), click here (https://www.tiaa.org/public/tiaa-nuveen-privacy) .

For Applicants of TIAA, Nuveen and Affiliates residing in California, please click here (https://www.tiaa.org/public/tiaa-nuveen-ca-privacy) .

For Applicants of Nuveen residing in Europe and APAC, please click here (https://www.tiaa.org/public/nuveen-eu-uk-privacy) .

TIAA started out over 100 years ago to help ensure teachers could retire with dignity. Today, many people who work at not-for-profits rely on our wide range of financial products and services to support and strengthen their financial well-being.

Privacy Notices

• For Applicants of TIAA, Nuveen and Affiliates residing in US (other than California), click here (https://www.tiaa.org/public/tiaa-nuveen-privacy) .

• For Applicants of TIAA, Nuveen and Affiliates residing in California, please click here (https://www.tiaa.org/public/tiaa-nuveen-ca-privacy) .

• For Applicants of Nuveen residing in Europe and APAC, please click here (https://www.tiaa.org/public/nuveen-eu-uk-privacy) .

Nondiscrimination & Equal Opportunity Employment

TIAA is committed to providing equal opportunity across all employment practices and we believe our employees have a right to a diverse and inclusive workplace.

EEO is the Law (https://assets.phenompeople.com/CareerConnectResources/TIAAGLOBAL/documents/22-088_EEOC_KnowYourRights-1688394514088.pdf)

Pay Transparency

Philadelphia Ban the Box (https://www.phila.gov/media/20210423160847/Fair-Chance-Hiring-law-poster.pdf)