SQL/Python System Designer II

Location: Columbia MD, (Hybrid)
In this position, you'll be based in the Columbia office for a minimum of three days a week, with the flexibility to work from home for some of your working week. Find out more about our flexible work culture at computershare.com/flex.
We give you a world of potential
Computershare Corporate Trust (CCT) is a division within Computershare responsible for providing trustee and sophisticated agency services for private and public companies, investment bankers, asset managers, government agencies and other financial institutions.The Analytic Consultant II provides moderate to complex technical support as the primary point of contact for systems, tools, and applications used by the business unit. The analyst is required to work independently and collaborate with a multitude of internal and external partners to resolve issues in a timely manner and implement risk-compliant solutions.
A role you will love
We are seeking a detail-oriented and technically proficient Business Rules Author / SQL-Python Developer to serve as a key liaison between Business Operations and Technology teams supporting residential onboarding and transaction processing. This role is responsible for translating business requirements into scalable system configurations, business rules, calculations, reporting, and workflow processes that support operational and client servicing objectives.
The ideal candidate combines strong technical expertise in SQL and Python with a solid understanding of data architecture, business process design, and operational controls. This individual will work closely with Operations, Product Management, Technology, Business Development, and other stakeholders to design, build, test, and maintain business rules and transaction configurations that support Residential Corporate Trust products and services.
As a Business Rules Author, you will play a critical role in onboarding new business by gathering requirements, defining transaction structures, configuring processing logic, and implementing rules that satisfy contractual obligations and client-specific requirements. You will support the development of calculations, waterfalls, eligibility criteria, classifications, reporting, and data quality controls while ensuring solutions are scalable, auditable, and compliant with internal policies and governance standards.
In addition, this role will contribute to data architecture and solution design efforts, maintain ownership of the business rules catalog, and support Agile development initiatives by creating high-quality, testable, and documented solutions that drive operational efficiency and business growth.
Key Responsibilities

• Author and maintain SQL rules (Oracle SQL/PLSQL/Python) for validations, transformations, calculations, and workflow decisions across Corporate Trust processes.
• Serve as the primary liaison between Business Operations and Technology, translating client, contractual, and operational requirements into scalable, configurable technology solutions that support residential transaction onboarding and servicing.
• Design, develop, and maintain SQL, PL/SQL, and Python business rules supporting transaction setup, validations, eligibility determinations, classifications, calculations, reporting, data transformations, and workflow decisioning processes.
• Configure and implement new residential transactions and processing structures, including payment waterfalls, allocation methodologies, calculation logic, reporting requirements, and client-specific business rules.
• Partner with Operations, Product Owners, Business Development, Risk, and Technology teams to gather requirements, evaluate impacts, and convert business objectives into deterministic, testable, and auditable rule logic.
• Establish and maintain business rule development standards, including naming conventions, version control, dependency management, testing methodologies, documentation requirements, and change governance practices.
• Lead methodology modernization initiatives, including the migration and transformation of legacy business logic into scalable Oracle SQL and Python-based solutions.
• Own and govern the enterprise business rules catalog, ensuring comprehensive documentation of rule purpose, business justification, inputs, outputs, data lineage, thresholds, exception handling, approvals, and change history.
• Treat rule frameworks, schemas, and reporting catalogs as strategic products, ensuring they remain reliable, scalable, well-documented, and continuously improved to meet evolving business needs.
• Develop and execute comprehensive testing strategies, including unit testing, regression testing, expected-results validation, automated controls, and user acceptance testing support.
• Collaborate with Quality Assurance and business stakeholders to define acceptance criteria, validate requirements, and ensure solution readiness prior to deployment.
• Design solutions for performance, scalability, and operational efficiency, optimizing processing across large datasets through effective query design, partitioning strategies, and incremental processing techniques.
• Ensure compliance with data governance, risk management, and internal control standards, maintaining traceable, explainable, and audit-ready business rules and processes.
• Implement and support governance controls, including approval workflows, role-based security, segregation of duties, and least-privilege access models.
• Support data architecture and data modeling efforts, ensuring business rules align with enterprise data standards and long-term technology strategy.
• Maintain detailed technical and business documentation, including rule logic, dependencies, data dictionaries, process flows, testing artifacts, and audit records.
• Monitor, troubleshoot, and resolve production issues related to business rules, transaction processing, calculations, and reporting, conducting root-cause analysis and implementing sustainable corrective actions.
• Participate in Agile development processes, including requirements refinement, sprint planning, solution design, testing, deployment, and continuous improvement activities.
• Identify opportunities to automate manual processes, improve operational controls, and enhance processing efficiency through innovative use of SQL, Python, and data-driven solutions.

What will you bring to the role?
Bachelor's degree in quantitative discipline (e.g., statistics, mathematics, finance, economics, computer science) OR equivalent experience with 3+ years in analytics/reporting.
Rewards designed for you
Paid parental leave, flexible working and a caring and inclusive culture
Health and wellbeing rewards that can be tailored to support you and your family, including paid time off, observed holidays, medical, dental and vision plans
Invest in your future with 401k matching, setting aside salary to purchase shares in our company and tax-advantaged flexible spending plans, including healthcare, dependent care and commuter
Income protection. Our package includes short and long-term disability benefits, life insurance and supplemental life insurance
And more. Ours is a welcoming and close-knit community, with experienced colleagues ready to help you grow. Our careers hub will help you find out more about our rewards and life at Computershare, visit computershare.com/careershub
Compensation. The typical base pay range for this role is $72K - $90K USD. This base pay range is specific to the Columbia location and may not be applicable to other locations.
#LI-Hybrid
About Us
A company to be proud of
We're a global leader in financial administration with over 11,000 employees across more than 22 different countries. At Computershare, it's more than just a job, our open and inclusive culture means that we will help you to grow, to move forward and make the most of our world of opportunities.
Fairness and culture
We want to provide you with the opportunity to succeed on your own merits, starting from the application process and continuing throughout your career with us. Our goal is to create an environment where everyone feels valued, to remove barriers and obstacles and ensure equal opportunities for all. For support with accommodations or adjustments during our recruitment process please visit computershare.com/access for further information.
About the Team
We're a market leader with decades of experience as a provider of trustee and sophisticated agency services for private and public companies, investment bankers, asset managers, and governments and institutions. Our organisation offers a broad range of services with a best-in-class reputation built on our high-touch approach to client service. We're looking for people to join us and be a part of our exciting future as one of the top corporate trust firms in North America.