Lead Enterprise Data Architect

at  US Bank National Association

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

Be a part of transformational change where integrity matters, success inspires and great teams collaborate and innovate. As the fifth-largest bank in the United States, we’re one of the country’s most respected, innovative, ethical and successful financial institutions. We’re looking for people who want more than just a job – they want to make a difference! U.S. Bank is seeking a Software Engineer who will contribute toward the success of our technology initiatives in our digital transformation journey.
This position will be responsible for the analysis, design, testing, development and maintenance of best in class software experiences. The candidate is a self-motivated individual who can collaborate with a team and across the organization. The candidate takes responsibility of the software artifacts produced adhering to U.S. Bank standards in order to ensure minimal impact to the customer experience. The candidate will be adept with the agile software development lifecycle and DevOps principles.

BASIC QUALIFICATIONS:

• Bachelor’s degree, or equivalent work experience
• Six to eight years of relevant experience

PREFERRED SKILLS/EXPERIENCE:

• This role/position requires a very strong foundation and practical skills working with Data Modelling , Data Architecture and Cassandra.
• Ability to transform business requirements into technical data solutions.
• Ability to analyze complex data challenges, identify root causes, and develop innovative solutions.
• In-depth understanding of banking operations, regulations, and compliance requirements to tailor data architecture solutions effectively.
• Comprehensive knowledge of database storage systems, encompassing relational databases (SQL-Server, PostgreSQL, Oracle etc), NoSQL databases (Cassandra, MongoDB etc.), data lakes, and lake house architectures for batch and real-time analytics.
• Experience with data modeling tools like Informatica PowerDesigner or Hackolade.
• Strong data modeling expertise in building conceptual, logical, and physical data models to represent business requirements and translate them into scalable data solutions.
• Experience with Medallion architecture for building lakehouse and data warehouse in Azure.
• Proficiency with cloud computing platforms, particularly Azure or AWS Cloud Platforms.
• Strong experience with big data platforms such as Synapse Analytics, Microsoft Fabric, Hadoop/hive, Greenplum, and Databricks etc. for batch and real-time analytical requirements.
• Proficiency in design principles and hands-on experience with data processing languages, including SQL programming for data modeling, Spark/Python for big-data processing, and data science applications.
• Knowledge of BI and Analytical tools such as Tableau, PowerBI, and/or Alteryx etc.
• Enterprise Architecture Framework: Familiarity with industry-standard enterprise architecture frameworks such as TOGAF etc
• Familiarity with data governance and data quality best practices
• Understanding of data security principles, encryption techniques, and privacy regulations (e.g. GDPR, CCPA) to ensure data compliance.
• Excellent problem-solving and analytical skills, demonstrating meticulous attentions to details.
• Strong communication, collaboration, presentation, and interpersonal abilities, facilitating effective collaboration across teams and stakeholders.
• Relevant certifications ( e.g. Microsoft Certified) are advantageous. Azure Certifications like AZ-900, DP-900, and/or DP-100 are preferred.
  If there’s anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants.

ESSENTIAL RESPONSIBILITIES:

• Foster strong stakeholder relationships to ensure data architecture and strategies align with business objective, driving technical data solutions to meet stakeholders needs and driving data-driven insights.
• Champion data architecture excellence by establishing and promoting best practices, design patterns, and standards that elevate data model quality and consistency across the enterprise.
• Design and develop data architecture solutions through conceptual & logical modeling, data diagrams, data flows, and drive variety of physical data models optimized for performance, scalability, supporting various data access patterns, and data consumption patterns (e.g., reporting, analytics, machine learning etc.)
• Develop data models that leverage Cassandra distributed database system, supporting high-performance data processing, analysis, and supporting online banking at scale.
• Implement canonical data models that standardize data structures and formats, supporting large-scale analytics workloads, fueling business intelligence, and reporting in lakehouse and data warehouse environment.
• Lead the development and implementation of enterprise-level master data management strategies, architectures, and solutions, ensuring accuracy, consistency, and integrity of critical data assets across the organization, and enabling a single, trusted source of truth for business-critical data.
• Integrate a CI/CD framework that automates the development, testing, and delivery of data artifacts, ensuring streamlined data pipelines.
• Expert in implementing data denormalization and aggregation techniques for performance optimization.
• Demonstrate expertise in industry-wide fintech logical models, including customer logical model, payments, and loans logical models etc.
• Develop and maintain technical documentation of data architecture and data models.
• Participate in proof-of-concept and pilot projects to evaluate new data architecture solutions and technologies.
• Demonstrate expertise in target state and referential architectures by applying pattern-based solutioninng to effectively address diverse use cases and drive efficient data architecture solutions.
• Design and implementing data catalog and metadata management solutions.

Our approach to benefits and total rewards considers our team members’ whole selves and what may be needed to thrive in and outside work. That’s why our benefits are designed to help you and your family boost your health, protect your financial security and give you peace of mind. Our benefits include the following (some may vary based on role, location or hours):

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