Cybersecurity Data Warehouse Lead Developer

$104,900 - $169,800/Yr

TIAA - Frisco, TX

Full-time - Senior

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 managing ETL jobs to support enterprise reporting. The position also includes leading projects, monitoring data lake performance, and mentoring a development team.

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 in a relevant field.
• 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

• In-depth knowledge of programming for diverse operating systems and platforms using development tools.
• Experience performing analyses and problem-solving.
• Attention to detail 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 including retirement program and competitive health offerings.