Salesforce Data and Marketing Cloud Intelligence Architect

U.S. Bank; Quinte West; On-site; CAD 155,000 - 182,000; Full time

Benefits offered by this job

Healthcare coverage

401(k) retirement plan

Paid vacation

Holiday opportunities

Life insurance

Disability insurance

Job summary

U.S. Bank seeks a Salesforce Datorama Architect to design data harmonization, ingestion, and visualization strategies, turning multi-source marketing data into actionable insights. You will lead API/ETL integrations, create advanced dashboards, and ensure data governance for enterprise-level analytics.

Responsibilities include data modeling, robust ETL pipelines, and governance to optimize performance for high-volume datasets across marketing channels and CRM platforms.

Qualifications

• 5+ years in marketing data engineering with 3+ years in Salesforce Datorama (MCI).
• Strong SQL skills, API-based integrations, data modeling and ETL experience.
• Deep understanding of marketing channels, KPI frameworks, and attribution.
• Proficiency across CRM and marketing automation platforms; Salesforce schema knowledge.

Responsibilities

• Design data models and harmonize disparate data sources (media, CRM, web, email).
• Build ETL pipelines, custom connectors, and API integrations.
• Configure calculated dimensions, measures, and widgets to drive KPI frameworks.
• Enforce data governance and optimize performance for high-volume datasets.

Skills

Salesforce Datorama

SQL

API integrations

Data modeling

ETL

Marketing analytics

CRM platforms

Education

Bachelor's degree

Equivalent work experience

Tools

Salesforce Data Loader

SOQL

ETL tools

Job description

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, enabling the communities we support to grow and succeed in the right ways, all more confidently and more often—that’s what we call the courage to thrive. 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. Try new things, learn new skills and discover what you excel at—all from Day One.

As a wholly owned subsidiary of U.S. Bank, Elavon is committed to building the platforms and ecosystems that help over 1.5 million customers around the world to achieve their financial goals—no matter what they need. From transaction processing to customer service, to driving innovation and launching new products, we’re building a range of tailored payment solutions powered by the latest technology. As part of our team, you can explore what motivates and energizes your career goals: partnering with our customers, our communities, and each other.

Job Description

A Salesforce Datorama (Marketing Cloud Intelligence) Architect designs and implements complex data harmonization, ingestion, and visualization strategies, transforming multi-source marketing data into actionable insights. They lead API/ETL integrations, create advanced dashboards, and ensure data governance for enterprise-level marketing analytics.

Key Responsibilities

• Data Architecture & Modeling: Design data models, normalize, and harmonize disparate data sources (media, CRM, web, email) within MCI.

• Implementation & Integration: Build robust ETL pipelines, custom connectors, and API integrations.

• Advanced Analytics: Configure calculated dimensions, measures, and complex widgets to drive KPI frameworks.

• Governance & Optimization: Enforce data governance, naming conventions, and optimize performance for high-volume datasets.

• QA & Release Management: Implement QA processes for data accuracy, testing, and system deployment.

Required Skills and Qualifications

• Experience: 5+ years in marketing data engineering, with 3+ years specifically in Salesforce Datorama (MCI).

• Technical Expertise: Strong SQL skills, knowledge of API-based integrations, and experience with data modeling and ETL.

• Marketing Domain Knowledge: Deep understanding of marketing channels, KPI frameworks, and attribution.

• Platform Knowledge: Proficiency in CRM and marketing automation platforms.

• Proven experience with data modeling, relational databases (SQL), data mapping, and API integration.

• Deep understanding of Salesforce schema, SOQL,Data Loader, ETL tools, and master data management.

Desired Certifications

• Salesforce Certified Data Architect
• Platform Data Architect.
• Marketing Cloud Intelligence Accredited Professional

.

Basic Qualifications

• Bachelor’s degree, or equivalent work experience
• Six or more years of related experience in marketing and marketing strategy with proven ability to deliver results

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.

Benefits:

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:

• 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

Review our full benefits available by employment status.

U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law.

E-Verify

U.S. Bank participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States and certain U.S. territories. The E-Verify program is an Internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. Learn more about E-Verify program.

The salary range reflects figures based on the primary location, which is listed first. The actual range for the role may differ based on the location of the role. In addition to salary, U.S. Bank offers a comprehensive benefits package, including incentive and recognition programs, equity stock purchase 401(k) contribution and pension (all benefits are subject to eligibility requirements). Pay Range: $111,095.00 - $130,700.00

U.S. Bank will consider qualified applicants with arrest or conviction records for employment. U.S. Bank conducts background checks consistent with applicable local laws, including the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act as well as the San Francisco Fair Chance Ordinance. U.S. Bank is subject to, and conducts background checks consistent with the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA). In addition, certain positions may also be subject to the requirements of FINRA, NMLS registration, Reg Z, Reg G, OFAC, the NFA, the FCPA, the Bank Secrecy Act, the SAFE Act, and/or federal guidelines applicable to an agreement, such as those related to ethics, safety, or operational procedures.

Applicants must be able to comply with U.S. Bank policies and procedures including the Code of Ethics and Business Conduct and related workplace conduct and safety policies.

Posting may be closed earlier due to high volume of applicants.