Role: Senior SQL & Reporting Automation Specialist No of Openings: 1 Location: Pune, India Hours: Full Time Years of Experience: Minimum 10 years experience in a similar role Education:B.Tech / B.E. (Computer Science, IT, Data Science)ORBCA (Bachelor of Computer Applications)ORB.Com (with specialization in Business Analytics / Finance) Work Timings:IST 03.30 PM to 12.30 AM (Next Day) Monday through FridayWe are a leading financial servicing company providing business loans to medium and large-sized companies across the United States. Our data-driven approach enables us to offer tailored financial solutions to businesses, ensuring their growth and success. We are looking for a Senior SQL and Reporting Automation Specialist to manage our data infrastructure, optimize reporting automation, and ensure smooth data migration processes. This role is based in Pune, India. This is with our Indian subsidiary company Ezdaher India Private Limited. Ezdaher India Private Limited is a KPO based in Pune and provides credit underwriting, technology, marketing, human resources and other functional services to our parent company AVANA Companies, USA.Key Responsibilities- Develop, optimize, and maintain MSSQL databases to support business operations.- Design, build, and maintain cloud database solutions to ensure efficient data storage and retrieval.- Perform data migration between on-premise and cloud databases, ensuring data integrity and security.- Develop and optimize complex SQL queries, stored procedures, functions, and triggers for data analysis and reporting.- Implement reporting automation solutions using BI tools, SQL, and scripting techniques to enhance data-driven decision-making.- Work on data warehousing solutions to store and analyze structured and unstructured business data efficiently.- Ensure data quality, governance, and security by implementing best practices.- Collaborate with business stakeholders to understand data requirements and provide actionable insights.- Work independently under strict deadlines and manage multiple tasks efficiently.Required Skills & Qualifications- 10+ years of experience in SQL development, database management, and data analysis.- Expertise in MSSQL Server development, including query optimization and performance tuning.- Hands-on experience with cloud databases (AWS RDS, Azure SQL, Google Cloud SQL, etc.).- Strong knowledge of data migration strategies and tools.- Experience in designing and implementing automated reporting solutions using SQL and BI tools (Power BI, Tableau, etc.).- Solid understanding of ETL processes and data warehousing concepts.- Ability to analyze large datasets and provide meaningful insights.- Strong problem-solving skills, with attention to detail.- Excellent communication skills and ability to work independently under tight deadlines.Desired Functional and Behavioral Characteristics- Positive and professional attitude.- Self-motivated with a proactive approach to tasks.- Team player with a willingness to collaborate and support colleagues.- Strong commitment to accuracy and attention to detail. What we have to offer- Competitive salary and benefits package.- Work in a fast-growing financial services company with a dynamic work environment.- Opportunity to work on cutting-edge database and reporting automation solutions.- Career growth opportunities and professional development support.

Position: Assistant Manager Finance & AccountsLocation: Pune, IndiaHours: Full TimeWorking Hours: USA East Coast (5.30 pm to 2.30 am IST)Years of Experience: At least 4 yearsEducation: Chartered AccountantStrong Preference for: CA & CS qualificationsTravel: YesRelocation: NoExperienceStrong experience in IND-AS, preparation of IND-AS financials, standalone and consolidated accounts. Experience in IFRS and any previous experience in Saudi Arabia will be an added advantage.Candidates should have good experience in all aspects of Finance (Taxation, Finances, Revenue, Account payable, Banking etc)Experience of preparing MIS and Presentation to Board of Directors and Investors. Preparation of budget/forecast and financial modelling.ResponsibilitiesManage and oversee the daily operations of the finance & accounts department including:month and end-year processregulatory reporting and filings GST, TDS, PF, PTaccounts payable/receivablecash receiptsgeneral ledgerpayroll and utilitiestreasury, budgetingcash forecastingrevenue and expenditure variance analysiscapital assets reconciliationsaccount statement reconciliations,fixed asset activitydebt activityPreparation of financial statements and consolidation of financial statements Financial reporting including MIS reporting.Analysis of financial statements Worked in ERP implementations. Review of financial statement prepared under IND-AS Analysis of product level portfolio and accounting yield, cost of borrowing and NIM. Computation of IND-AS accounting adjustments e.g.: EIR (Ind A109), ECL (Ind AS 109) and EIS (gain of de-recognized financial asset - direct assignment and securitization of pool (PTC). Preparation of Company's annual operating plan and monitor the same with actual numbers. Preparation of annual financial disclosure required under Ind AS framework and RBI norms. Required Education and QualificationChartered Accountant; additional qualification of Company Secretary (CS) will be a plus4-5 years of total experience in finance and accounts in BFSIGreat attention to detailsWorks with minimal supervisionAbility to multi-task and prioritize.Good Organization & Interpersonal skillsKnowledgeable in MS Office /Office 365Hands-on experience with Tally & Oracle / SAP ERP system.Proficient in MS Excel & MS PowerPoint.Ideal candidate should have strong written and verbal skills (in English)Desired SkillsPositive and professional attitudeSelf-motivatedAble to work in multi-nationality and fast paced environment.TrustworthyFlexibleSalary commensurate with experience. All candidates will be required to provide detailed salary history and references.

Requirement #1 Credit Analyst; Role: Credit AnalystLocation: Pune, India Hours: Full TimeYears of Experience: 3+ years in Credit/ Banking/ NBFCsEducation: Degree in Accounting or FinanceStrong Preference for: Chartered Accountant (ICAI member or ACCA member), CPA and/or CFAWork Timings: USA East Coast Time (IST 5.30 PM to 2.30 AM) Monday through FridayWe are currently looking for Credit Analysts to be based in Pune, India. This is with our Indian subsidiary company Ezdaher India Private Limited.Ezdaher India Private Limited is a KPO based in Pune and provides credit underwriting and otherfunctional services to our parent company AVANA Companies, USA.Our credit analysis process plays a key role in evaluating borrowers' ability to repay, valuing the collateral, and managing risk throughout the loan term, ensuring that our investments are protected. The main job of a credit analyst is to give well-informed recommendations on loan requests and present each loan as an investment opportunity to senior management. This is done by creating clear and accurate reports that show both the strengths and risks of each loan.As part of the AVANA team, we will provide you training in U.S. real estate lending and pair you with experienced U.S.-based underwriters to ensure you have the support needed to succeed.We will train you to provide great customer service and build strong client relationships, followingAVANAs core values: Putting People First, Doing the Right Thing, Taking the Lead, Making an Impact, and recognizing that Excellence is a journey.Duties and Responsibilities (Training will be provided):Analyze loan requests thoroughly, focusing on the financials of applicants and collateral valuation, ensuring accuracy and reliability.Collaborate with internal teams to ensure each loan is processed within the set time frames in the service level agreement.Communicate proactively with clients and the sales team to gather the necessary information for making informed credit decisions.Recommend suitable loan structures based on the credit request.Follow AVANAs credit analysis standards as outlined in the loan policy.Prepare and present clear credit analysis memos that accurately assess the borrower's creditworthiness and collateral value, highlighting strengths and risks.Perform periodic risk assessments and monitoring on assigned loans, ensuring correct risk ratings are assigned, identify early warning signs, and recommend appropriate actions to mitigate risks.Administer construction loans, tracking budgets, schedules, third-party reports, and ensuring timely funding.Research and analyze industry trends to spot potential risks in the market.Use U.S.-based resources to assess portfolio risks, including probabilities of default and potential losses.Ensure compliance with legal and management standards across all areas.Be open to travel for training purposes.Take on additional tasks as assigned by the Chief Credit Officer or Management.Required Education and Experience/Skills:Bachelors degree in finance or accounting with a strong academic background.At least 3 years of experience in commercial lending, preferably in commercial real estate, Loan against property and hotel lending.Quick learner, strong problem-solving skills, and ability to think.Excellent analytical skills, able to interpret complex financial data and identify key risks.Excellent knowledge of accounting rules.Knowledge of US GAAP and IFRS will be beneficial.Ability to work independently with minimal supervision.Comfortable in a fast-paced, multinational environment, able to manage multiple priorities.Strong attention to detail, with the ability to spot data discrepancies.Availability to work U.S. hours (IST 5:30 PM to 2:30 AM).Ability to coordinate with internal and external stakeholders.Excellent written and spoken English, able to clearly communicate findings and recommendations.Proficient in Microsoft Excel and Word.Desired Functional and Behavioral Characteristics: Self-motivated with a proactive approach to tasks.Positive and professional attitude.Team player with a willingness to collaborate and support colleagues.Strong commitment to accuracy and attention to detail.What we have to offer Competitive salary and benefits packageAmple opportunities for growth and self-developmentOpportunities for professional development and advancementCollaborative and inclusive work environment with international exposure

Role: Marketing SpecialistLocation: Pune, IndiaHours: Full TimeYears of Experience: 5+ years in running campaigns, content writing and social media optimization.Education: Masters Degree in Marketing from Top Tier B-SchoolWork Timings: USA East Coast Time (IST 5.30 PM to 2.30 AM) Monday through Friday We are currently looking for a Marketing Specialist to be based in our office in Pune, India.The Marketing Specialist will primarily be responsible for assisting in implementing marketing campaigns, content writing, ensuring engagement rate remain high and maintaining a database of all the created content (blogs, graphics, videos, etc.)Duties and Responsibilities Assist in implementing marketing campaigns, encompassing both digital and traditional advertising, email marketing, and social media. Manage and coordinate various marketing activities, ensuring effective communication for asset deliveries. Blog and newsletter writing leveraging internal resources. Oversee social media platforms, which includes content planning, scheduling, and engagement. Gather and evaluate marketing data to measure campaign effectiveness, providing recommendations for enhancement. Aid in event planning and execution, working closely with vendors, managing logistics, and ensuring attendees have a memorable experience. Support market research and competitor analysis to pinpoint trends and business opportunities. Oversee marketing materials and inventory, making certain of their proper organization and storage. Work in tandem with internal departments and external partners to guarantee uniform messaging and branding across all marketing campaigns. Stay informed of industry trends and best practices to continuously enhance marketing strategies.Key Results Operational Efficiency: Reduce the average time from campaign concept to launch by 15% quarterly. This will measure the efficiency and effectiveness of planning and executing marketing campaigns. Content Optimization: Increase the average engagement rate on blogs and newsletters by 7% quarterly without increasing marketing spend. This can be a measure of how effectively content resonates with the target audience and is optimized over time. Content Operations: 1. Maintain a content calendar and ensure 95% or more of the scheduled content is posted on time. This ensures timely and consistent communication with the audience. 2. Increase the response time to customer inquiries and comments on social media platforms by 20%. A faster response rate can improve brand image and customer satisfaction. Content Management System (CMS) Efficiency: 1. Ensure that 98% of all created content (blogs, graphics, videos, etc.) is cataloged and accessible within the company's CMS within 24 hours of creation. 2. Monitor content usage and aim to increase internal access and utilization by 15% quarterly, indicating that teams are effectively leveraging available content assets.Required Education and Experience/Skills: Masters degree in Marketing, Communications, or a related field from Top Tier B School. Strong knowledge of marketing principles, strategies, and techniques. Proficient in using marketing software, CRM platforms, and social media management tools. Excellent verbal and written communication skills. Exceptional organizational and multitasking abilities. Desired Characteristics Attention to detail and the ability to analyze data. Creative thinker with a demonstrable ability to generate innovative ideas. Strong team player with the ability to collaborate effectively with cross-functional teams.What we have to offer Competitive salary and benefits package Ample opportunities for growth and self-development Opportunities for professional development and advancement Collaborative and inclusive work environment with international exposure