Job Title: Data Analyst

Job Title: Data Analyst

Job Location: 28055 N. Ashley Circle, Suite 212, Libertyville, IL 60048

Job Duties: We are seeking experienced Data Analysts to design and create dashboards that provide insights to client executives in a variety of marketing areas including sales, customer demographics, revenue forecasting, sales force, direct marketing effectiveness, customer response and industry trends. This position will devise and evaluate methods and procedures for collecting data and transforming the information into usable insight by utilizing custom SAS coding and Tableau reporting.

This role serves as a consultant, researcher, problem solver, advisor, liaison and developer for the implementation of reporting solutions with meaningful and actionable insights.

  • Job responsibilities and duties also include:
  • Create and manipulate datasets to be used for dashboards by writing code in SAS.
  • Analyze claims data, transactional specialty data and financial data.
  • Gain an understanding of key metrics.
  • Generate reports and alerts based on developed business rules and segmentation criteria.
  • Create and maintain weekly, bi-weekly and monthly reports for clients.
  • Transform existing Excel reports to Tableau.
  • Create graphs in Excel and PowerPoint.
  • Maintain, enhance, and problem-solve existing reports, dashboards, and related information delivery solutions.
  • Work with senior executives to plan and design dashboards for existing clients and to bring in future, potential new business.
  • This position does not supervise the work of any other employees.

Minimum requirements: Bachelor’s degree or higher in Business Administration, Business Analytics, Data Analytics, Market Research, Marketing or a related field of study, plus at least three (3) years of experience in the job offered or in any related position(s) involving development of custom reporting tools, data analytics, modeling and forecasting methods.

Qualified applicants must also have demonstrable proficiency, knowledge, skill and experience (through education or employment) with the following:

  1. Creating reporting solutions through the translation of business requirements to technical specifications and development.
  2. Utilizing SAS code to manage complex data sets for recurring, efficient data insights demonstrated by a deep understanding of PROC Import, PROC Export, PROC Freq, PROC Means, Segmentation and Sorting in SAS.
  3. Creating near real-time integrations using Tableau or MS Access.
  4. Creating MS Excel dashboards through pivot tables, vlookup references, sumifs, index match, pick lists and related developer tool box functions
  5. Demonstrated ability to communicate complex analysis to business owners for actionable planning and execution of marketing objectives
  6. Longitudinal analysis using Excel or SAS including ROI projections, forecasting, data modeling, segmentation, cleansing, and statistical monitoring.
  7. Using Excel or SAS to merge and automate reporting for weekly, bi-weekly, and/or daily reporting and insights.

No travel; no telecommuting.

Additional Information:
Job Site: 28055 N. Ashley Circle, Suite 212, Libertyville, IL 60048
Travel requirements, if any: No travel; no telecommuting.
• No phone calls or e-mails.

Salary: $67,645.00 per year.

Mail resumes to: ATTN: Peter Zurawski. 28055 N. Ashley Circle, Suite 212, Libertyville, IL 60048

 

What People Say

    Grand Marketing Solutions is among the very best for creative ideas and insightful marketing strategies to change your business. The team at Grand Marketing Solutions have taken creative marketing and a solutions driven strategy to a new level. They have helped me re-define our firms focus and strategies. The team at Grand Marketing Solutions is among the very best to help small and mid-market companies. Karl Hofmeier and the team at Grand Marketing Solutions are a tremendous resource for companies that are seeking to grow their revenues and increase profits. Simply, an excellent company that delivers value to your business.
    - Berk
    I have called upon Grand Marketing Solutions to provide various web and design based services to several of my clients. In every instance, I have found Grand Marketing Solutions to be client focused, extremely responsive and cost and value conscious. I am happy to recommend Grand Marketing Solutions to my clients as a valuable resource and extension of the strategic services I provide.
    - Dennis
    Grand Marketing Solutions has been very effective for us. They are the right size firm with the right mix of talents. They spruced up our logo, redesigned our web site, printed new literature, and worked smoothly with our people.
    - Bill
    Before starting Business Image Magazine, I met with dozens of graphic designers/printers and worked with a couple before I met Karl Hofmeier of Grand Marketing Solutions. I heard Karl speak at a networking event and was impressed with his expertise. Since then, Grand Marketing Solutions has become my one stop shop for marketing advice, graphic design, printing, website design and maintenance. The service is second to none and I am happy to refer all my clients and prospects to him.
    - Tom
    We are proud to be partners with GMS. As an entrepreneur and small business owner, I value a relationship with a partner who is cut from the same mold. Grand Marketing Solutions understands what it takes to keep our company competitive in a ever changing market. They ask the right questions and treat our business as it was their own. With Grand Marketing Solutions as our partner we can focus on our core business while they execute on our marketing strategy. We've been with a handful of marketing firms over the years. Some were large, some were small, but none of them have had the impact that Grand Marketing Solutions has.
    - Rob
    It has been a pleasure working with GMS. They are knowledgeable, professional and prompt. I will continue to use their services and recommend them to clients, associates and friends.
    - Bryan
    We are proud to be partners with GMS. As an entrepreneur and small business owner, I value a relationship with a partner who is cut from the same mold. Grand Marketing Solutions understands what it takes to keep our company competitive in a ever changing market. They ask the right questions and treat our business as it was their own. With Grand Marketing Solutions as our partner we can focus on our core business while they execute on our marketing strategy. We have been with a handful of marketing firms over the years. Some were large, some were small, but none of them have had the impact that Grand Marketing Solutions has.
    - Rob

Contact Us

We would love to hear from you

By using this form you agree with the storage and handling of your data by this website.

How you can find us

Feel free to connect with us