Cybersecurity Data Warehouse Lead Developer

$104,900 - $169,800/Yr

TIAA - Frisco, TX

Full-time - Mid Level

Frisco, TX

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Cybersecurity Data Warehouse Lead Developer at TIAA is responsible for designing, developing, and maintaining data warehouses and data lakes within the enterprise cloud environment. This role involves creating dashboards, analytical reports, and data visualization tools, as well as leading projects and mentoring a development team. The position requires collaboration with cybersecurity teams to ensure effective solutions and the timely delivery of software applications.

Responsibilities

• Serve as a subject matter expert (SME) for cybersecurity on data warehouse and metrics.
• Design, create, deploy, and update programs for specific devices, the web, or operating systems.
• Collaborate with cybersecurity teams to understand needs and determine appropriate solutions.
• Translate client requirements into application features and ensure timely delivery of fully functional software applications.
• Create metrics and dashboards.
• Perform code reviews.
• Develop and deploy ETL jobs.
• Understand client needs, design prototypes, write code, perform testing, and maintain 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.

Requirements

• Bachelor's Degree 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.

Nice-to-haves

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

Benefits

• Comprehensive Total Rewards package
• Superior retirement program
• Highly competitive health, wellness, and work-life offerings