Job description

Job Description We have an exciting opportunity for an experienced software engineer to shape the next generation of market risk reporting and analytics. As a Lead Software Engineer in the Market Risk Data Visualization Team, you will provide hands-on technical leadership for data products that help risk professionals understand a large, complex, and fast-moving market risk environment. You will design and deliver high-quality analytical datasets, reporting pipelines, and visualization-ready views using PySpark, SQL, and modern cloud data platforms. You will work closely with risk managers, quantitative and data teams, product partners, and other engineers to turn complex business questions into clear, trusted, and useful reporting. The team is advancing AI-enabled engineering practices to improve how it analyzes requirements, develops and tests pipelines, and delivers reporting capabilities. You will help establish effective patterns for this work, including sound engineering controls and human review, while remaining accountable for the quality, security, and correctness of production outcomes. Job Responsibilities • Lead the design and delivery of scalable PySpark and SQL pipelines that transform complex market risk data into trusted, analytics-ready datasets. • Define reusable engineering patterns for reporting data products, including data contracts, semantic definitions, quality checks, lineage, testing, deployment, and operational support. • Build and optimize data models and views that support interactive reporting, visualization, analysis, and business decision-making. • Partner with business stakeholders and risk subject-matter experts to clarify reporting needs, identify the right data, and translate requirements into maintainable technical solutions. • Guide architecture and implementation across batch data processing, lakehouse storage, and visualization or reporting integration. • Drive adoption of enterprise-authorized AI-assisted development practices, setting clear expectations for validating generated code and analysis for correctness, performance, security, and data handling. • Identify opportunities to apply AI and automation to requirements analysis, pipeline development, test generation, data quality investigation, and reporting workflows, with appropriate human oversight. • Develop secure, resilient, production-quality code; lead code reviews; and improve automated testing, CI/CD, observability, and support practices. • Mentor engineers through technical coaching, design reviews, pairing, and constructive feedback; help raise engineering standards across the team. • Identify and resolve performance, scalability, data quality, and operational issues across large data workloads. • Communicate technical options, delivery risks, and recommendations clearly to business partners, engineering peers, and senior leaders. Required qualifications, capabilities, and skills • Bachelor’s or advanced degree in computer science, data science, engineering, applied mathematics, or a related technical discipline, or equivalent practical experience. • Significant experience designing, building, and operating production data-intensive applications, including technical leadership of complex deliveries. • Expert-level Python and PySpark skills, with strong SQL and a solid understanding of distributed data processing and Spark performance. • Hands-on experience with a modern lakehouse or cloud data platform, such as Databricks and Delta Lake, and cloud object storage such as Amazon S3. • Strong understanding of data modeling, analytical data products, data quality, lineage, access controls, and governance in an enterprise environment. • Experience designing data products for reporting, visualization, or analytical use, including translating business definitions into consistent, usable datasets. • Demonstrated ability to lead technical design, make pragmatic architecture decisions, and communicate trade-offs to varied audiences. • Experience with automated testing, CI/CD, code review, production monitoring, and operational support for data pipelines. • Demonstrated experience using approved AI-assisted software development tools effectively, with disciplined validation of AI-generated code and recommendations. • Strong collaboration skills and the ability to work with business partners and technical teams in an agile delivery environment. • Familiarity with financial markets, market risk, or other complex financial data domains, or the ability to learn the domain quickly. Preferred qualifications, capabilities, and skills • Experience with Databricks workflows or pipelines, Unity Catalog, Delta Lake, and cloud-native data services. • Experience with reporting and visualization tools or frameworks, and with designing datasets for interactive dashboards and analytical applications. • Experience with data product or data mesh practices, including discoverability, ownership, reusable interfaces, and governed self-service access. • Experience applying LLMs or agentic techniques to software engineering, requirements analysis, data investigation, or reporting workflows. • Experience building APIs or services that make governed analytical data available to applications and AI-enabled tools. • Knowledge of market risk measures, sensitivities, Value at Risk, stress testing, limits, or related risk reporting. • Experience with infrastructure as code, data observability, and performance or cost optimization at scale. Provide hands-on technical leadership for market risk data products, building and optimizing PySpark/SQL pipelines and data models.

Requirements

Must-haves

We have an exciting opportunity for an experienced software engineer to shape the next generation of market risk reporting and analytics.
Lead the design and delivery of scalable PySpark and SQL pipelines that transform complex market risk data into trusted, analytics-ready datasets.
Define reusable engineering patterns for reporting data products, including data contracts, semantic definitions, quality checks, lineage, testing, deployment, and operational support.
Build and optimize data models and views that support interactive reporting, visualization, analysis, and business decision-making.
Partner with business stakeholders and risk subject-matter experts to clarify reporting needs, identify the right data, and translate requirements into maintainable technical solutions.
Guide architecture and implementation across batch data processing, lakehouse storage, and visualization or reporting integration.
Drive adoption of enterprise-authorized AI-assisted development practices, setting clear expectations for validating generated code and analysis for correctness, performance, security, and data handling.
Identify opportunities to apply AI and automation to requirements analysis, pipeline development, test generation, data quality investigation, and reporting workflows, with appropriate human oversight.
Develop secure, resilient, production-quality code; lead code reviews; and improve automated testing, CI/CD, observability, and support practices.
Mentor engineers through technical coaching, design reviews, pairing, and constructive feedback; help raise engineering standards across the team.
Identify and resolve performance, scalability, data quality, and operational issues across large data workloads.
Communicate technical options, delivery risks, and recommendations clearly to business partners, engineering peers, and senior leaders.
Required qualifications, capabilities, and skills
Bachelor’s or advanced degree in computer science, data science, engineering, applied mathematics, or a related technical discipline, or equivalent practical experience.
Significant experience designing, building, and operating production data-intensive applications, including technical leadership of complex deliveries.
Expert-level Python and PySpark skills, with strong SQL and a solid understanding of distributed data processing and Spark performance.
Hands-on experience with a modern lakehouse or cloud data platform, such as Databricks and Delta Lake, and cloud object storage such as Amazon S3.
Strong understanding of data modeling, analytical data products, data quality, lineage, access controls, and governance in an enterprise environment.
Experience designing data products for reporting, visualization, or analytical use, including translating business definitions into consistent, usable datasets.
Demonstrated ability to lead technical design, make pragmatic architecture decisions, and communicate trade-offs to varied audiences.
Experience with automated testing, CI/CD, code review, production monitoring, and operational support for data pipelines.
Demonstrated experience using approved AI-assisted software development tools effectively, with disciplined validation of AI-generated code and recommendations.
Strong collaboration skills and the ability to work with business partners and technical teams in an agile delivery environment.

Nice-to-haves

Preferred qualifications, capabilities, and skills

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaici/cdpythonagile

Platform: oracle-cloud
Effort: medium