Report Automation Analyst


Chicago, IL

30+ days ago | Requisition ID: 1063

Only Technomic delivers a 360 view of the food industry. We drive growth and profitability for our clients by providing the most reliable, consumer-grounded, channel-relevant data, with forward-looking, strategic insights. Our services range from major research studies and management consulting solutions to online databases and simple fact-finding assignments. Our clients include food manufacturers and distributors, restaurants and retailers, other foodservice organizations, and various institutions aligned with the food industry.

The Automation Analyst's primary responsibility is to build automated research reporting processes that improve project efficiency across the R&I research portfolio. The ability to translate the data vision of principal investigators (i.e. Advisors, Research Directors, Program Managers, etc.) into impactful automated reporting tools is crucial. Success in this role will not only enhance the process efficiency of the research functions at Technomic, it will also enhance the speed to market with dynamic research reporting.

Position Responsibilities:

  • Collect, organize and prepare data from different environments (SPSS, IGNITE’s Data Engine, ESRI etc.) for reporting purposes in syndicated & proprietary services. 
  • Automate processes and models in order to improve time on task and data accuracy for research report authors 
  • Implement data engineering practices e.g. setup databases from flat files etc. 
  • Work cross-functionally between R&I and products team to automate repeatable reporting tasks 
  • Independently conduct tests and debugging on existing report automation code to assure high quality work 
  • Build DIY tools for the research team to generate research reports with minimal efforts. 
  • Systematically document existing and new code 
  • Individual continued improvement by developing programming abilities and expanding team’s capabilities. 
  • Other duties as assigned 

Knowledge, Skills & Abilities:

  • Familiarity with reporting and dashboarding tools a plus (PowerPoint, Tableau, PowerBI, Shiny etc.) 
  • 1 to 2 years in Python programming, database development, data querying and data-mining environments 
  • Proficient in Python a must 
  • Ability to generate and maintain custom code based on project requirements 
  • Ability to focus on the larger goal and develop automation solutions 
  • Familiarity with reporting and dashboarding tools a plus (PowerPoint, Tableau, PowerBI, Shiny etc.) 
  • Familiarity with Bitbucket, Git, R, Java, HTML or similar software a plus 
  • Proficient in building automation processes 
  • Must have strong attention to detail, as well as strong analytical and problem solving skills 
  • Proven ability to manage multiple tasks and meet deadlines 
  • Independently learn new programming languages and tools with minimal guidance 

Technomic is an Equal Opportunity Employer. Technomic does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit and business needs. 

Apply Now

Let’s keep in touch! Sign up for the latest from our brands.