Sr. Data Engineer

The Senior Data Engineer will design, build, implement, and maintain data processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources. The role will develop robust and scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable end-users to consume and analyze data faster and easier. Additionally, the Senior Data Engineer will serve as the principal person responsible for Informatica data ingress (import) and egress (export) and monitoring to ensure data is accurately and securely transferred in and out of systems.

Expected Duties:

• Senior Data Engineers will design, build, implement, and maintain data processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of data sources

• Informatica ingress and egress creation and monitoring acting as principal point of contact

• Expected to lead the writing of complex SQL queries to support analytics needs

• Responsible for developing technical tools and programming that leverage artificial intelligence, machine learning, and big-data techniques to cleanse, organize and transform data and to maintain, defend and update data structures and integrity on an automated basis

• Senior Data Engineers will evaluate and recommend tools and technologies for data infrastructure and processing. Collaborate with engineers, data scientists, data analysts, product teams, and other stakeholders to translate business requirements to technical specifications and coded data pipelines

• The role will work with tools, languages, data processing frameworks, and databases such as R, Python, SQL, Databricks, Informatica, Sigma, Spark, Delta, APIs. Work with structured and unstructured data from a variety of data stores, such as data lakes, relational database management systems, and/or data warehouses

Qualifications: Knowledge, Skills, and Abilities:

The role will include work on problems of diverse scopes where analysis of information requires evaluation of identifiable factors. Work is expected to be done independently through independent judgment.

• Ability to assess unusual circumstances and use sophisticated analytical and problem-solving techniques to identify the cause

• Working with people, processes facing Enterprise a plus, improvement of processes/reduction of costs in the enterprise processes leveraging data is preferable.

• Ability to enhance relationships and networks with senior internal partners who are not familiar with the subject often requires persuasion

• Architect and scale our modern data platform to support real-time and batch processing for financial forecasting, risk analytics, and customer insights

• Enforce high standards for data governance, quality, lineage, and compliance

• Partner with stakeholders across engineering, finance, sales, and compliance to translate business requirements into reliable data models and workflows.

• Evaluate emerging technologies and lead POCs that shape the future of our data stack.

• Champion a culture of security, automation, and continuous delivery in all data workflows

Technical Qualifications:

• Deep expertise in Python, SQL, Informatica, Sigma and distributed processing frameworks like Apache Spark, Databricks, Snowflake, Redshift, BigQuery.

• Proven experience with cloud-based data platforms (preferably AWS or Azure).

• Hands-on experience with data orchestration tools (e.g., Airflow, dbt) and data warehouses (e.g., Databricks, Snowflake, Redshift, BigQuery).

• Strong understanding of data security, privacy, and compliance within a financial services context.

• Experience working with structured and semi-structured data (e.g., Delta, JSON, Parquet, Avro) at scale.

• Familiarity with modelling datasets in Salesforce, Netsuite and Anaplan to solve business use cases required.

• Previous experience Democratizing data at scale for the enterprise a huge plus.

Educational Qualifications and Work experience

• Bachelor's or master's degree in computer science, Engineering, or a related field.

• 6-8 years of experience in data engineering, with a strong focus on financial systems on SaaS platforms.