Data Engineer - Bangalore/Hyderabad, India - Info Origin Inc

Description

Position Title :
Financial Analytics Data Engineer.


Location :
Hyderabad/Bangalore, KA, Onsite.


Position Type :
Full-Time.


Position Duration :
Permanent.


Job Description :

The Corporate Solutions Technical Accounting team is looking for financial analytics engineer to design and develop workflows and create analytics to digitally transform the current NA Accident and Health reporting and business decision processes.

years of experience with strong IT technical skills, low to medium level regarding Accounting/Financial Reporting & Insurance knowledge.

Specifically, the role will be responsible for :

Building data pipelines that produce data assets in the accounting workflow to :

• Reconcile cash to accounting ledgers.
• Create financial reporting for reinsurance partners (e.g. excess layer / quota share).
• Support reporting for captive partners.
• Settlement reporting.
• Detail premium and claims reporting.
• Create pipeline adjustments to source system data to reflect correct values and assist in system programming bug fixes.
• Manage exception reporting for crossfunctional workflows (e.g. collaborative work with policy issue teams).
• Build data health and process control reports.
• Develop and report on key business operational and KPI performance metrics.
• Provide reporting for downstream corporate processes (e.g. captive reporting for CRAS, reinsurance platform).

Work with downstream data teams on reconciliation, integration and data flow alignment.

• Building data assets as the foundation for analysis performed by other business functions.
• Data to segment profitability and trend analysis for Pricing Actuarial.
• Data to support financial projections and analysis team (FP&A).
• Data to support Reserving Actuarial process.
• Data to support Actuarial Control analysis.
• Data to support yearend Accounting audit.
• Data to support internal audit requests.
• Data to support statutory regulatory reporting.
• Data to support LoB management steering.
• Data to support Underwriting performance metrics.
• Data to support Sales team producer partner analysis.
• Based on experience and interest, this role may evolve to include extraction of external data for internal analysis, development of portfolio analytics, and application of data science techniques to improve estimates.

About the Team :

• The Client's Technical Accounting team executing compensation settlements and providing support to the Financial Accounting process.
• The team also produces the data assets that enable detailed analysis and reporting for other functions within the Client value chain as well as to external business partners and regulatory entities.
• Key responsibilities include the design, development and production of reporting and analysis that supports key accounting and financial reporting processes and the production of data assets that enable analysis for other functional teams.
• To achieve these goals, the team seeks to implement a data first perspective to innovate and improve the traditional accounting processes and to leverage data as an asset.
• The role will report directly to the Senior Product Owner for the ESL. NET platform.

About You :

• Experience with SQL, Visual Studio, UC4, SSIS, and SSRS (Microsoft Azure framework).
• Experience with Python, Spark, Data Lake.

Bachelor's Degree in Computer Science.

• Strong work ethic and selfstarter who can deliver results quickly.
• Good communication skills and the ability to translate technical concepts.
• Knowledge of insurance concepts preferred but not required.
• Knowledge of accounting principles preferred but not required)