LexisNexis Risk Solutions

Senior Software Engineer I

LexisNexis Risk Solutions
Apply
4 hours ago
Mumbai, India +2 moreSenior

Responsibilities

  • Design, develop, maintain, and optimize scalable Finance data ingestion and transformation pipelines using Azure Databricks, Azure Data Factory, Python, PySpark, and SQL.
  • Maintain star and snowflake schemas, data lake structures, warehouse structures, and analytics-ready data models for reporting and machine learning use cases.
  • Integrate MBS, Oracle Fusion, Salesforce, legacy Finance platforms, APIs, files, and other enterprise source systems with reliable controls and traceability.
  • Migrate and consolidate legacy Finance data processes into BDAP and reduce technical debt and dependency on aging infrastructure.
  • Implement automated data quality checks, reconciliation frameworks, validation controls, exception handling, lineage, metadata, governance, monitoring, alerting, and operational reporting.
  • Architect high-performance batch and near-real-time pipelines for structured and unstructured data, including partitioning, caching, parallel processing, troubleshooting, and query optimization.
  • Build reusable engineering components and AI-enabled automation using Databricks Genie and Microsoft Copilot under approved governance and security controls.
  • Collaborate with Finance, data, product, and engineering stakeholders to gather requirements, define acceptance criteria, and deliver production solutions.
  • Create architecture, pipeline, support, operational, runbook, and knowledge-transfer documentation.
  • Mentor junior engineers, participate in reviews and engineering standards, promote knowledge sharing, and evaluate improvements to cloud data technologies.

Requirements

  • Experience with Azure Data Factory pipeline orchestration, parameterization, scheduling, monitoring, and integration patterns.
  • Production data engineering experience with Azure Databricks, including notebooks, jobs, cluster and workload optimization, and Delta-based processing.
  • Strong Python and PySpark programming experience for scalable transformations, automation, reusable frameworks, and production support.
  • Advanced SQL query development and optimization, data analysis, and experience with relational platforms such as Oracle, PostgreSQL, or MySQL.
  • Experience implementing automated data quality checks, control totals, source-to-target validation, exception handling, and reconciliation processes.
  • Practical experience integrating APIs, enterprise source systems, file-based ingestion, and complex cross-platform dependencies.
  • Experience with data modeling and architecture, including star and snowflake schemas, data lakes, data warehouses, and analytics-ready datasets.
  • Understanding of data governance concepts including metadata, lineage, access controls, cataloging, and governed data management.
  • Experience with Git, version control, code review, testing, deployment, maintainable design patterns, and reliable cloud solutions in enterprise environments.
  • Finance-domain data engineering experience involving accounting, billing, revenue, cost, reconciliation, or management reporting is strongly preferred.
  • Experience with MBS, Oracle Fusion, Salesforce, or comparable enterprise Finance and CRM platforms is desirable.
  • Experience modernizing or migrating legacy data processes into a strategic cloud platform such as BDAP and supporting month-end or quarter-end operations is strongly preferred.
  • Experience with machine learning workflows, governed model-output pipelines, reusable data engineering accelerators, AI-enabled automation, monitoring, alerting, runbooks, or business-critical data support models is desirable.
  • Experience with Power BI, Synapse, OCI, Essbase, Talend, HPCC/ECL, or similar enterprise analytics and data-integration technologies is desirable.

Benefits

  • Country-specific benefits are available based on the employee's location.
  • The employer provides an accessible hiring process and accommodations for applicants with disabilities or other needs.

Tech Stack

DatabricksGitMySQLPostgreSQLPythonSQLTalend

Categories

Data Engineering
LexisNexis Risk Solutions

About LexisNexis Risk Solutions

10,000+ employees

LexisNexis Risk Solutions builds data and analytics products for businesses and governments to assess risk, prevent fraud, verify identities, and meet compliance. It sells APIs, decisioning platforms, and curated data sets used across insurance, financial services, healthcare, and public safety. Headquartered in Alpharetta, Georgia, it operates as part of RELX, providing industry-specific solutions such as insurance risk scores and digital identity intelligence.

Contact me