Job Description :
Hello ,
Matrix Technology Group is a highly recognized provider of professional IT Consulting services in the US. Founded in 1998, Matrix Technology Group is an ERP, BI and Application Development consulting services provider
Job Position : MSBI Analyst
Location : Dayton OH
Duration : 6+ Months
Job Description:
Support marketing and sales analytics by developing datamarts, reports (ad-hoc and regular), and dashboards; as well as develop insights to support understanding marketing/sales effectiveness to increase demand, revenue and profitability.
Accountabilities:
1.Extract, combine and aggregate transaction-level data sets from disparate sources and formats (both relational databases and flat files) into data cubes optimized for rapid access to key measures & metrics allowing for on demand deep-dive views of the business.
2.Develop & build fit-for-purpose custom data pipelines to support the cross-functional needs of Forecasting, Performance Assessment & Advanced Analytics initiatives extending to Marketing & Sales teams.
3.Perform ad-hoc data investigation & queries to address an immediate business question and report data via cross-tabs, pivot tables, charts, distributions & correlations. Also, automate reports if certain ad-hoc requests are needed on a regular basis.
4.Support the development, distribution and maintenance of standard set of Sales & Marketing Performance Reports and Dashboards using appropriate reporting, visualization and data automation tools.
5.Own regular evaluation of all data sources being leveraged to ensure integrity and quality of the data.
6.Actively participate and influence continuous improvements to Company''s Data Warehousing and Business Intelligence solutions with a strong motive for eliminating redundant manual data extraction and processing.
Qualifications:
1.Bachelor''s Degree required; preferably in Computer Science, Business Analytics, Statistics, Engineering or relevant Quantitative field
2.1+ years of practical experience in a data-rich environment using SQL for data extraction, processing, manipulation, query & reporting with a demonstrated practical knowledge of building analytical databases and managing data.
3.Previous experience in Marketing or Sales organization preferred; experience with CRM (i.e. Siebel, Salesforce.com), Marketing Automation Platform (i.e. Marketing Cloud, Marketo) and/or Web Analytics (i.e. Google Analytics) helpful.
4.Experience in data modeling and developing dashboards/reports in Tableau (or other similar BI Tools) would be an asset.
5.Experience with data warehousing (e.g. storage methods/formats, database design) would be an asset.
6.Excellent verbal and written communications with ability to both communicate with and partner with Marketing and/or Sales
Mukesh Kathad
Matrix Technology Group
"Certified Minority Business Enterprise (MBE)"