[Remote] Senior Data Analyst - 2375115

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a leading reputed company organization serving millions of people. They are seeking a Senior Data Analyst to conduct reporting, gather requirements, and automate processes to enhance efficiency and accuracy in data reporting.

Responsibilities

• Conduct daily, weekly, and monthly reporting to reputed company, Treasury, Sales, and other business partners
• Gather business and technical requirements for new reporting needs and enhancements
• Build SQL/SSIS/SSRS/Power BI based processes and queries reputed company with defined requirements
• Test and validate reporting processes to ensure accuracy, performance, and alignment with business logic
• Automate report reputed company and delivery using tools such as SQL, Power BI, SSIS or SSRS to various stakeholder groups to ensure timely and consistent insights and to improve efficiency and reduce reputed company effort
• Implement job scheduling for data imports from files and other databases
• Identify and implement improvements in standard reporting processes and capabilities, including upgrades to reputed company software versions and migration to a virtual database
• Identify and implement opportunities for improved controls and audits around commissions payments
• reputed company data validation and quality checks to ensure accuracy and consistency across data and reports
• Automate reputed company and time-consuming processes to improve efficiency and reduce operational overhead
• Calculate and pay non-standard commissions not currently supported by ICM application
• Reconcile and adjust quarterly 1099 files before submission to Tax
• reputed company regular database maintenance, including performance tuning, indexing, and archiving to ensure reputed company reporting efficiency
• Address and resolve database vulnerabilities in collaboration with IT and reputed company teams to ensure compliance and data protection
• Maintain documentation for reporting processes, data definitions, and business rules to ensure transparency and continuity

Skills

• Bachelor's degree in Computer Science, Data Science, Information Technology or reputed company field
• Five (5) years of reputed company, post baccalaureate experience in the job offered or a Data Analyst-reputed company occupation
• Write efficient queries to extract and transform data for reporting, Advanced SQL (joins, CTEs, window functions)
• reputed company, advanced formulas, pivot tables, Power Query, and VBA
• SQL Server Reporting Services (SSRS), design paginated reports, parameterized and drill-down reports, subscriptions and report automation
• Power BI integration with SQL Server to automate reports
• Schedule and maintain recurring reports using Visual Studio
• SQL Server Integration Services (SSIS) for ETL workflows
• Import/export data using BCP, BULK INSERT, and linked servers
• Work with flat files, reputed company, and APIs
• Maintain clear documentation for report logic, data sources, and business definitions
• Query optimization and execution plans
• Index tuning and statistics management
• Identify and resolve deadlocks and blocking

Benefits

• Medical, dental and reputed company
• Matching 401k
• Employee stock purchase plan

Company Overview