• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 1st Nov 2023

The Data Analyst leverages Salesforce, Dynamics, IBM Mainframe, SQL Server, and SharePoint data to drive informed business decisions and optimize operational processes. This position involves analyzing, interpreting, and presenting data insights to support various aspects of the organization's Salesforce implementation.

Mandatory Skills: 

• 2 years of experience in SQL Server, Mainframe database, SharePoint, and Dynamics CRM

• 2 years of experience writing SQL queries

• Strong/Advanced experience in ETL and SSIS (SQL Server Integration Services)

• Familiarity with the Salesforce platform, API, and data model

• Familiarity with Salesforce out-of-the-box functionality

• Strong/Advanced experience in data modeling and documentation

Responsibilities:

1. Data Analysis: Collect, clean, and analyze Legacy System data (Dynamics, IBM Mainframe, SQL Server, and SharePoint) to identify trends, patterns, and opportunities for improvement. 2. Reporting: Develop and maintain custom reports and dashboards within Salesforce to provide stakeholders with real-time insights into the data. 3. Data Integration: Collaborate with the Salesforce data migration team to ensure seamless integration of data from various sources into Salesforce, ensuring data accuracy and consistency. 4. Data Quality Management: Implement data quality best practices to maintain data integrity within Salesforce, including deduplication, data cleansing, and validation rules. 5. User Support: Assist Salesforce users in generating ad-hoc reports and resolving data-related issues, providing training and support as needed. 6. Business Insights: Translate data findings into actionable recommendations, helping customers and the Salesforce project team to improve efficiency, effectiveness, and customer satisfaction. 7. Process Improvement: Work closely with cross-functional teams to identify and implement process improvements and automation opportunities within Salesforce. 8. Compliance and Security: Ensure that data handling and storage within Salesforce comply with data protection regulations and security protocols. 9. Documentation: Maintain documentation of data models, processes, and reporting requirements to facilitate knowledge sharing and data governance.

Qualifications:

• 10+ years of overall IT experience

• Bachelor's degree in a related field (e.g., Data Science, Business Analytics, Information Technology).

• 5+ years of proven experience with Salesforce data analysis and reporting.

• Proficiency in Salesforce reporting tools, such as Salesforce Reports and Dashboards.

• Strong analytical skills with the ability to work with large datasets.

• Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus.

• Knowledge of data management best practices and data governance.

• Excellent communication skills to convey complex data findings to non-technical stakeholders.

• Salesforce certification(s) would be advantageous.

• Attention to detail and a commitment to data accuracy.