Lead Software Engineer - Azure (Multiple openings) in San Francisco, CA.

U.S. Bank • San Francisco, CA

12h • $161,670 - $189,625

About The Position

At U.S. Bank, we’re on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to discover what makes you thrive at every stage of your career. Try new things, learn new skills and discover what you excel at—all from Day One. Job Description U.S. Bank is seeking a full-time Lead Software Engineer - Azure (Multiple openings) in San Francisco, CA. Essential Responsibilities: Work on U.S. Bank’s next generation cloud-based data and AI platform to enable data success cross business units within the company. Lead the design, development, and migration of on-premises data applications and tools to public cloud platforms, with a primary focus on Azure. Oversee the end-to-end lifecycle of software products, including design, development, testing, operation, and maintenance, ensuring high quality and reliability. Take full stack ownership by consistently delivering production-ready, testable code using Spark, Scala, Python, Java, SQL, and Azure Cloud technologies. Architect and implement optimal solutions that adhere to architectural best practices, emphasizing scalability, reliability, and performance, particularly within Azure Synapse Analytics, Azure Data Factory, SSIS, Azure Spark pool, Apache Airflow, and ETL frameworks. Integrate Azure Event Hub and Azure Function Apps to enable real-time data streaming, event-driven processing, and seamless connectivity between distributed systems. Design and implement Splunk logging solutions by routing application and infrastructure logs through Azure Event Hub, ensuring robust monitoring, alerting, and operational visibility. Utilize Terraform modules to automate the deployment of Azure Synapse Analytics, Azure Event Hub, and associated resources, ensuring infrastructure as code best practices. Define and assign appropriate Azure RBAC roles within Terraform modules to enforce least-privilege access for Synapse, Event Hub, and related services. Analyze system failures, propose and implement design changes, and drive operational improvements across data warehousing and cloud-based environments. Make informed design and coding decisions with a strong focus on customer experience and business requirements. Incorporate feedback from code reviews and ensure all code meets established standards and best practices. Conduct code reviews for team members, providing guidance on engineering best practices, compliance, and development procedures. Ensure all aspects of product development comply with security and regulatory requirements, especially in cloud and data warehousing contexts. Champion the adoption of emerging technologies, such as Kubernetes/AKS, Docker, and CI/CD automation, and contribute to the evolution of best practices supporting the organization’s technology transformation. Leverage previous experience with Pentaho for ETL and data integration solutions, ensuring seamless migration and interoperability with Azure-based architectures. Apply expert-level knowledge of PostgreSQL for database design, optimization, and management within both on-premises and cloud environments. Use the following tools and technologies: Azure Data Studio, Synapse studio, VS Code, SSIS, Airflow, SAS, CyberArk Security, Azure Event Hub, Azure Function App, Azure Data Factory, Azure Data Lake, AzCopy, Python, Spark, SQL, Terraform, Docker, Github Copilot, Azure Gen AI, DBeaver, and Splunk. Position supervises two (2) peers including an Associate Software Engineer and Senior Software Engineer.

Requirements

• This position requires a Bachelor’s degree or equivalent in Computer Science or Computer Engineering and 5 years (progressive, post-baccalaureate) software development experience.
• Must also have 24 months of experience with each of the following: 1) Designing, developing, and implementing software components using SQL and Synapse Analytics. 2) Working on Data Warehousing Development, including building / managing large scale data warehouses using Azure Synapse Studio and Batch Data Processing. 3) Migrating on-prem data applications and tools to public cloud including Azure Data Lake and AzCopy. 4) Working with cloud-based data and AI platforms including Github Copilot, Azure Gen AI, and VS Code. 5) Performance Tuning queries using SQL on Azure Data Studio, DBeaver and monitoring using Splunk logging.

Responsibilities

• Work on U.S. Bank’s next generation cloud-based data and AI platform to enable data success cross business units within the company.
• Lead the design, development, and migration of on-premises data applications and tools to public cloud platforms, with a primary focus on Azure.
• Oversee the end-to-end lifecycle of software products, including design, development, testing, operation, and maintenance, ensuring high quality and reliability.
• Take full stack ownership by consistently delivering production-ready, testable code using Spark, Scala, Python, Java, SQL, and Azure Cloud technologies.
• Architect and implement optimal solutions that adhere to architectural best practices, emphasizing scalability, reliability, and performance, particularly within Azure Synapse Analytics, Azure Data Factory, SSIS, Azure Spark pool, Apache Airflow, and ETL frameworks.
• Integrate Azure Event Hub and Azure Function Apps to enable real-time data streaming, event-driven processing, and seamless connectivity between distributed systems.
• Design and implement Splunk logging solutions by routing application and infrastructure logs through Azure Event Hub, ensuring robust monitoring, alerting, and operational visibility.
• Utilize Terraform modules to automate the deployment of Azure Synapse Analytics, Azure Event Hub, and associated resources, ensuring infrastructure as code best practices.
• Define and assign appropriate Azure RBAC roles within Terraform modules to enforce least-privilege access for Synapse, Event Hub, and related services.
• Analyze system failures, propose and implement design changes, and drive operational improvements across data warehousing and cloud-based environments.
• Make informed design and coding decisions with a strong focus on customer experience and business requirements.
• Incorporate feedback from code reviews and ensure all code meets established standards and best practices.
• Conduct code reviews for team members, providing guidance on engineering best practices, compliance, and development procedures.
• Ensure all aspects of product development comply with security and regulatory requirements, especially in cloud and data warehousing contexts.
• Champion the adoption of emerging technologies, such as Kubernetes/AKS, Docker, and CI/CD automation, and contribute to the evolution of best practices supporting the organization’s technology transformation.
• Leverage previous experience with Pentaho for ETL and data integration solutions, ensuring seamless migration and interoperability with Azure-based architectures.
• Apply expert-level knowledge of PostgreSQL for database design, optimization, and management within both on-premises and cloud environments.

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level