Job Description
Required Experience: 5 - 10 Years
Skills : Salesforce Analytics, reporting, data science
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 analysing, interpreting, and presenting data insights to support various aspects of the organization's Salesforce implementation.
Responsibilities:
1. Data Analysis: Collect, clean, and analyse 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.
Mandatory Skills:
2 years of experience in SQL Server, Mainframe database, SharePoint, and Dynamics CRM2 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 modelling and documentation work
Job Type: Contract
Pay: Up to $50.00 per hour
Experience level:
- 5 years
Schedule:
- 8 hour shift
Ability to commute/relocate:
- New York, NY 10001: Reliably commute or planning to relocate before starting work (Required)
Application Question(s):
- This is a hybrid role and we are looking for candidates who are local to New York, NY . Please confirm your current location with Zip Code.
Experience:
- Salesforce Data Analyst: 5 years (Preferred)
- Salesforce Analytics: 3 years (Preferred)
- Reporting: 3 years (Preferred)
- Data science: 3 years (Preferred)
Work Location: In person