Reporting Specialist

Artex Risk Solutions

7 - 12 years

8 - 12 Lacs

bengaluru

Posted:-1 days ago| Platform:

Apply

Skills Required

data analysis sas data modeling workflow oracle microsoft information technology macros python salesforce

Work Mode

Work from Office

Job Type

Full Time

Job Description

Responsibilities : Data Verification: Review and verify data submissions from clients to ensure accuracy and completeness
Identify and resolve any discrepancies or errors in the data
Client Interaction: Communicate effectively with clients to follow up on data submissions, clarify any issues, and ensure timely and accurate data delivery
End-to-End Data Management: Acquire and scrape structured/unstructured data using Python, SQL, and automation tools, ensuring compliance with data policies
Clean and transform datasets using Python (Pandas), SQL, and Excel for analysis readiness
Integrate data from enterprise platforms like Salesforce and EPIC to enable comprehensive reporting
Development and Maintain - VBA macros, worked on large data set
Database Management: Assist in the maintenance and updating of databases to ensure data integrity and accessibility
Write complex SQL queries to extract, transform, and load data from multiple sources
Ensure data integrity and accuracy across reporting platforms
Data Visualization & Reporting: Create interactive dashboards and reports using Power BI and Excel to support data-driven decisions
Automate recurring reports with Python, VBA, and Macros to improve efficiency and reduce manual effort
Stakeholder Collaboration: Partner with cross-functional teams to understand reporting needs and deliver tailored solutions
Present insights and recommendations to senior leadership in a clear, compelling manner
Advanced Analytics & Insights: Analyze complex datasets to uncover trends and insights that inform business strategy
Build dynamic dashboards using Power BI with advanced DAX formulas and MS Excel
Apply statistical modeling and forecasting using Python and SQL to support data-driven decisions across business units
Process Improvement: Identify opportunities to streamline reporting processes and reduce manual effort
Lead initiatives to improve data quality and governance Training and Development: Participate in training sessions to enhance skills in data analytics tools and methodologies
Documentation: Maintain comprehensive documentation of data processes and procedures to ensure consistency and transparency
Tool Integration & Workflow Automation: Integrate data from Salesforce, EPIC, and other enterprise systems
Build scalable solutions for data ingestion and transformation using Python and Excel automation
COMPETENCIES (OPTIONAL) Analytical Thinking : Ability to systematically and logically break down complex data sets to extract actionable insights and inform business decisions
Attention to Detail: Strong focus on accuracy and thoroughness in reviewing data submissions, identifying discrepancies, and maintaining organized records
Communication Skills: Proficient in conveying information clearly and effectively to clients and team members, ensuring mutual understanding and timely data delivery
Technical Proficiency: Expertise in using MS Excel, SQL and Python for data entry, analysis, and database management, with a willingness to learn additional analytics tools
Problem-Solving: Capability to identify issues within data sets and implement effective solutions to resolve discrepancies and improve data processes
Collaboration: Ability to work effectively with team members and departments to achieve common goals and ensure seamless data management
Process Improvement: Aptitude for identifying opportunities to enhance data accuracy and efficiency and implementing innovative solutions
Adaptability: Flexibility to adjust to changing priorities and new challenges in a dynamic work environment
Customer Focus: Commitment to understanding and meeting the needs of clients and stakeholders, ensuring high-quality service delivery
Organizational Skills: Strong ability to manage multiple tasks and priorities, maintaining organized and up-to-date records and documentation
Responsibilities : Data Verification: Review and verify data submissions from clients to ensure accuracy and completeness
Identify and resolve any discrepancies or errors in the data
Client Interaction: Communicate effectively with clients to follow up on data submissions, clarify any issues, and ensure timely and accurate data delivery
End-to-End Data Management: Acquire and scrape structured/unstructured data using Python, SQL, and automation tools, ensuring compliance with data policies
Clean and transform datasets using Python (Pandas), SQL, and Excel for analysis readiness
Integrate data from enterprise platforms like Salesforce and EPIC to enable comprehensive reporting
Development and Maintain - VBA macros, worked on large data set
Database Management: Assist in the maintenance and updating of databases to ensure data integrity and accessibility
Write complex SQL queries to extract, transform, and load data from multiple sources
Ensure data integrity and accuracy across reporting platforms
Data Visualization & Reporting: Create interactive dashboards and reports using Power BI and Excel to support data-driven decisions
Automate recurring reports with Python, VBA, and Macros to improve efficiency and reduce manual effort
Stakeholder Collaboration: Partner with cross-functional teams to understand reporting needs and deliver tailored solutions
Present insights and recommendations to senior leadership in a clear, compelling manner
Advanced Analytics & Insights: Analyze complex datasets to uncover trends and insights that inform business strategy
Build dynamic dashboards using Power BI with advanced DAX formulas and MS Excel
Apply statistical modeling and forecasting using Python and SQL to support data-driven decisions across business units
Process Improvement: Identify opportunities to streamline reporting processes and reduce manual effort
Lead initiatives to improve data quality and governance Training and Development: Participate in training sessions to enhance skills in data analytics tools and methodologies
Documentation: Maintain comprehensive documentation of data processes and procedures to ensure consistency and transparency
Tool Integration & Workflow Automation: Integrate data from Salesforce, EPIC, and other enterprise systems
Build scalable solutions for data ingestion and transformation using Python and Excel automation
COMPETENCIES (OPTIONAL) Analytical Thinking : Ability to systematically and logically break down complex data sets to extract actionable insights and inform business decisions
Attention to Detail: Strong focus on accuracy and thoroughness in reviewing data submissions, identifying discrepancies, and maintaining organized records
Communication Skills: Proficient in conveying information clearly and effectively to clients and team members, ensuring mutual understanding and timely data delivery
Technical Proficiency: Expertise in using MS Excel, SQL and Python for data entry, analysis, and database management, with a willingness to learn additional analytics tools
Problem-Solving: Capability to identify issues within data sets and implement effective solutions to resolve discrepancies and improve data processes
Collaboration: Ability to work effectively with team members and departments to achieve common goals and ensure seamless data management
Process Improvement: Aptitude for identifying opportunities to enhance data accuracy and efficiency and implementing innovative solutions
Adaptability: Flexibility to adjust to changing priorities and new challenges in a dynamic work environment
Customer Focus: Commitment to understanding and meeting the needs of clients and stakeholders, ensuring high-quality service delivery
Organizational Skills: Strong ability to manage multiple tasks and priorities, maintaining organized and up-to-date records and documentation

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.