Role: Senior SQL & Reporting Automation Specialist

No of Openings:1

Location: Pune, India

Hours: Full Time

Years of Experience: Minimum 15 years experience in a similar role

Education: B.Tech / B.E. (Computer Science, IT, Data Science) OR BCA (Bachelor of Computer Applications) OR B.Com (with specialization in Business Analytics / Finance)

Work Timings: IST 03.30 PM to 12.30 AM (Next Day) Monday through Friday

We 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.

About AVANA Companies

AVANA Companies (www.avanacompanies.com) is a U.S. based group of credit and finance companies specializing in lending to specific niche industries that we’re highly knowledgeable in, such as hospitality, construction, and traditional Commercial Real Estate (CRE) because it enables us to provide the best possible service for our borrowers and minimize risk for our investors. We focus on helping small business owners and real estate developers across the USA by offering quick, adaptable, and dependable financing.

Based in Glendale, Arizona, our financial services firm stands at the forefront of the industry, embracing innovation and fostering a culture of excellence.

Founded in 2002, we have originated loans in excess of $6.5 Billion and managed $1 Billion assets for our investors.

We have earned multiple awards and recognition like:

• 2024 FinTech Breakthrough Award
• Top Mortgage Lender Award
• Inc 5000 list of America’s fastest growing private companies, 2021
• Banking Tech Awards

AVANA Companies Winning Aspiration

We preserve wealth and generate income for our investors by providing loans with speed and certainty of execution to help entrepreneurs thrive.

AVANA Companies core values

• Put People First
• Do the Right Thing
• Take the Lead
• Make an Impact
• Excellence is a journey

Why join us?

We believe our families are the most important people in our lives. We believe that our work should speak for itself, and we believe that everyone should be given a chance to succeed and grow. We also believe there is no substitute for hard work and that when we falter, we get up and do it again. We come to work with one singular goal and that is to create jobs and provide clean energy in America. We believe in talking less and executing as per our client’s timeline. Do you see yourself thriving in an entrepreneurial culture and spending time with disciplined business warriors? Are you driven by challenge, innovation, and creativity? If so, then we invite you to read on.