Fairfield County based client, within Hospitality industry, is looking for a Data Reporting Analyst to join their team on a permanent basis
Provide advanced analytical support for business operations
Pull raw data from Salesforce.com CRM platform and SQL database -- generating reports, automating best practices, and building dashboards through Salesforce.com platform.
Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources, including Sage X3 ERP platform.
Review data to determine operational impacts and needed actions
Model data using MS Excel, Access, SQL, and/or other data ware house analytical tools
Support with data storage architecture, design and deployment
Assist with technical documentation of systems and processes
Required Skills, Knowledge and Abilities:
Working experience in data extraction, manipulation, modeling and reporting,
At least 5 years of working experience with Excel
Must have the ability to query data from a SQL database, working experience with T-SQL
Professional experience generating reports from SQL databases and Excel
Experience creating data models, projections, pivot tables from multiple source data.
Ability to intelligently provide commentary and insight into data; aide departments in decision-making processes based on this analysis.
Ability to analyze and compare data from different datasets to ensure consistency and data integrity
Strong in VBA / Excel
Work independently and assist with multiple projects, priorities and locations
Work under pressure with interruptions and challenging deadlines
Experience working with Sage X3 or similar ERP
Experience working with salesforce.com platform or similar CRM.
Hospitality industry knowledge and experience
For more information please contact me at email@example.com