SQL/Python System Designer III
About The Position
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. At this level, the role assumes increased responsibility for complex analytics initiatives, working directly with business partners across multiple functional areas. The position plays a critical role in translating business needs into advanced analytical solutions and driving insights that support strategic and operational decision-making. The role requires cross-functional collaboration, engagement with senior stakeholders, and the ability to manage competing priorities across initiatives. The work often spans multiple systems, datasets, and business processes, with heightened accountability for accuracy, timeliness, and regulatory compliance.
Requirements
- Bachelor’s degree in quantitative discipline (e.g., statistics, mathematics, finance, economics, computer science) OR equivalent experience with 5+ years in analytics/reporting.
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.
Benefits
- Paid parental leave
- flexible working
- a caring and inclusive culture
- Health and wellbeing rewards
- medical, dental and vision
- 401k matching
- tax-advantaged flexible spending plans, including healthcare, dependent care and commuter
- short and long-term disability benefits
- life insurance
- supplemental life insurance
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
