Senior Data Architect - SQL & BI Automation

Windsor Advantage, LLC; Indianapolis (IN); Hybrid; USD 70.000 - 85.000; Vollzeit

Benefits dieser Stelle

Hybrid work schedule

Medical, Dental, Vision benefits

401(k) contributions

Life Insurance and Disability

Zusammenfassung

Windsor Advantage LLC, an affiliate of Capital Bank N.A., seeks a Data Architect to lead SQL Server based development and automate data functions across departments in Indianapolis. You will coordinate with managers, stakeholders, and developers while ensuring data privacy and reliability.

The role requires strong SQL, analytics, and BI visualization skills. The hybrid position includes collaboration with cross-functional teams and opportunities to influence data strategy and governance.

Qualifikationen

• Bachelor's degree in Math/Statistics, Business, Computer Science or equivalent.
• 3-5 years of experience in business analytics, data management, data architecture or comparable role.
• 3+ years of experience in web application development and/or Microsoft SQL database development.

Aufgaben

• Research and analyze data to support department goals and stakeholders.
• Lead data architecture projects across SQL Server technologies and coordinate with stakeholders.
• Develop automated visualizations and dashboards to communicate analytical results.
• Ensure data privacy, confidentiality and data integrity across teams.
• Propose methodologies and best practices to improve database performance.
• Lead weekly department meetings with cross-functional stakeholders.
• Collaborate with vendors and internal teams to address data needs and issues.
• Maintain coding standards and documentation.

Kenntnisse

Web application development

Problem solving

Data analysis

Communication

Team collaboration

Ausbildung

Bachelor's degree in Math/Statistics, Business, Computer Science or related field

Tools

SQL Server

Microsoft Excel

Python/Pandas

REST API

Snowflake

C#

VBA

Jobbeschreibung

About Us
Windsor Advantage, an affiliate of Capital Bank N.A., is one of the nation's leading Lender Service Providers (LSP). Windsor Advantage provides banks, credit unions and CDFIs with a comprehensive outsourced SBA 7(a) and USDA lending platform without the need to hire staff or incurring capital expenditures. Since 2010, Windsor has processed more than $4.5 billion in government guaranteed loans and currently services a portfolio for over 100 lenders nationwide.

With more than 150 years of cumulative SBA lending experience, cutting edge technology, rigid controls and consistent processes, Windsor is uniquely qualified to assist any size lender with implementing a thoughtful and profitable government guaranteed lending initiative.

Capital Bank N.A.is headquartered in Maryland and has been serving our communities since 1999. We stand as a publicly traded company (NASDAQ: CBNK) with over $3 billion in assets. We offer commercial and consumer banking services primarily to clients in Maryland, DC, and Northern Virginia, alongside two nation-wide lending brands; Capital Bank Home Loans and OpenSky, a credit card division that offers and services credit cards across all states.

Position Purpose

The Data Architect will plan, lead and coordinate development projects across SQL Server based technologies and work closely with department managers, key project stakeholders, architects and developers. This position will be responsible for automating functions company-wide for all departments. This highly technical role incorporates computer programming, software engineering, data architecture and management. This position will be responsible for supporting the data access and data reporting needs of Windsor and its stakeholders.

Position Responsibilities

• Research and prepare reports; analyze and explain variances.
• Prepare effective presentations, reports, dashboards, and other communications to be leveraged both with stakeholders.
• Gather requirements and specifications from end-users to gain familiarity with specific data management needs.
• Ability to write complex operations, scripts, and triggers to support database access and address software bugs.
• Ensure compliance with data privacy policies and maintain confidentiality of client data.
• Propose and develop new methodologies and institute best practices to further enhance database performance.
• Strong ability to develop automated visualizations that easily and effectively communicate complex analytical results to business partners.
• Most operate within Company’s change management policy, while ensuring quality control measures are achieved and data integrity maintained.
• Lead weekly department Level 10 meeting with cross-departmental stakeholders.
• Effectively communicate with internal and external stakeholders.
• Adhere specifically to all Company policies and procedures, Federal and State regulations, and laws.
• Complete online and other regulatory compliance training by the specified due dates.
• Open cases/tickets with vendors and suppliers as needed.
• Perform other duties as required.
• Bachelor's degree in Math/Statistics, Business, Computer Science or equivalent related work experience
• A minimum of 3-5 years of relevant experience working in business analytics, data management, data architecture, business intelligence or comparable role.
• Must have at least 3+ years of experience in web application development and/or Microsoft SQL database development experience.
• Strong Experience in n-tier application architecture design on the Microsoft platform.

Technical Knowledge and Skills

• Intermediate to expert level SQL knowledge.
• Proven knowledge of principles and methods for managing projects, products and/or software development focused on payment processing and/or financial services.
• Advanced Microsoft Excel skills required (macros, VLOOKUP’s, pivot tables, etc.).
• Must be a self-starter, results-oriented, analytical and have strong problem-solving skills.
• Must possess a structured discipline of coding standards and programming documentation.
• Strong conceptual knowledge in a variety of the field's concepts, practices, and procedures.
• Ability to maintain confidentiality.
• Experience with MS Office User Forms (VBA/Python)
• Proficiency in MS Office Suite.
• 1-2 Years of Experience with MS SQL Server
• Ability to resolve high-priority issues outside of standard business hours.
• Must have at least 1-2 years of experience in web application development and/or Microsoft SQL database development experience.
• Ability to utilize AI resources and validate any outputs in a reliable manner prior to implementation in production.
• Able to assist with training AI to further production and reliability in coding and data architecture.
• Snowflake Data Integration Experience.
• Ability to read & write Python/Pandas.
• REST API Knowledge.
• Knowledge of Banking or Government Guaranteed Lending.
• C# or similar experience.

Compensation

• Base Salary Range: $70,000 - $85,000 annually. Final determination of where you are at in the salary range is based on numerous factors such as geographical location, relevant experience, skill set, education, and ability to meet qualifications within the job description.
• Additional Compensation: This role will include a yearly annual target bonus based on individual performance.
  
  

Working Arrangements

• This is a hybrid role expected to work in our Indianapolis office Monday, Wednesday, and Thursday. You will be able to work remotely on Tuesday and Friday.
  
  

Why Join Us?

• Join a growing company with a culture that fosters an entrepreneurial spirit
• Comprehensive benefits packageincluding Medical, Dental, Vision, Company Paid Life Insurance, Disability Insurance, and more?
• Company Contributions to your 401k - Regardless of your contribution
• Employee Perks:Paid Parental Leave, Employee Recognition Program, Leadership Program, Tuition Reimbursement Program, Employee Bank Checking Account, and much more!
• Generous Paid Time Off and Paid Holidays - Including Paid Charity Hours to support volunteer opportunities

Supporting Businesses. Helping People. Strengthening Communities.
Windsor Advantage LLC is an E-Verify, Affirmative Action and Equal Opportunity Employer.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Preferred First Name

Email *

Phone

Country *

Phone *

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile URL

Are you at least 18 years or older? * Select...

Are you legally authorized to work in the United States now and in the future without employer sponsorship? * Select...

Are you currently subject to a restrictive covenant agreement (e.g., non‑compete, non‑solicitation, or confidentiality agreement)? * Select...

Have you ever applied to Capital Bank or Windsor Advantage before? If yes, when did you apply? *

Are you related to any current Capital Bank or Windsor Advantage employees? If yes, please state their name. *

If hired by Capital Bank or Windsor Advantage, would you continue working for another employer or engage in any outside or self‑employment when you start with us? * Select...

What is your desired salary? *

How did you learn about this opportunity? * Select...

Tracking Application Source

If referred by a current or past employee, please state their name.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Windsor Advantage’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.