About Us

A ton of companies boast their unlimited PTO and dog-friendly offices, or maybe these days, discounted streaming sweat sessions. We get that and we love that. But at C.A. Fortune, we’re so much more than just cool perks. We’re committed to investing in our people because ultimately, they are who define us. We welcome diversity, value curiosity, and love uniqueness. We strive to provide a space for individuals to become a better version of themselves each day, not only for themselves, but for their teammates, their clients, and their customers.

At C.A. Fortune, we aspire to maintain our position as the nation’s leading consumer brands agency. We realize how fortunate we are (yes, pun intended?), to offer a comprehensive solution to our clients from sales management, to marketing, all the way down to insights, and e-comm. The beauty of that is not only in our breadth of services to our clients, but what that provides us. And that’s the opportunity for individuals (aka future employees, aka you) to find a perfect fit within our org. If you’re a go-getter, willing to roll-up-your-sleeves, are a creative(ish) thinker, you don’t mind parent jokes, and appreciate feedback loops, then we’re probably, ok certainly, the company you’re looking for.

C.A. E-COMM is a business unit of C.A. Fortune who ensures consumers can find our clients products anywhere and everywhere, including from the comfort of their couch. E-COMM is a national e-commerce solution team that specializes in selling and marketing consumer products via online platforms. Through robust reporting and analytics along with detailed forecasting techniques, we give each client a customized e-commerce sales solution.

Position Summary:

The Programming Analyst will champion the development and maintenance of reporting software designed to support, track, and grow core and new product initiatives for all E-COMM retailers and channels. This position will have the privilege of working on our E-COMM clients, including KIND, Shurtech, Speck, Tootsie Roll and more. They will develop and maintain value-added and actionable category management and sales tools with a heavy focus on Amazon Vendor and Seller Central. This position will work closely with the CA Fortune teams as a trusted advisor to our E-COMM clients.

Responsibilities:

• Develop and manage software that creatively automates the extraction of data from websites including Amazon’s Vendor Central and Seller Central, Kroger, Walmart and other E-Commerce sites.
• Generate multi-tab excel reports (Hourly, Daily, Weekly and on demand) from data stored in MYSQL that are provided to sales managers and CA Fortune clients.
• Scope of Automated Report generations includes but is not limited to:
• Monthly and Weekly sales reporting
• Reviews and Content analysis and reporting
• ‘Buy Box’ reporting
• Third Party Seller reporting
• Work closely with our data partners to ensure a fluid process from data intake, visualization, testing visuals to production.
• Provide automated monthly reporting for CA Fortune’s Amazon through Vendor and Seller Central sites to generate invoices for finance.

Essential Job Functions

• MUST HAVE: Prior experience using vendor-side data from Amazon.com (Vendor and Seller Central), Walmart.com or other E-Comm platforms.
• MUST HAVE: Proficiency in Microsoft Office & Windows (Excel, PowerPoint, Word, Mail Merge, Task
• Scheduler)
• Advanced Excel Functionality (Pivot Tables, data queries, Power Query)
• Advanced knowledge of creating and managing SQL Database Structures, Queries, Administration and Views
• Programming & Platform Skills: SQL, MySQL Workbench, C#, Visual Basic, HTML, Java, Selenium Web Driver, XPATH, CSS Selector, AutoIT, SciTE
• Strong understanding on structure, management, and utilization of Cloud Services, including Amazon Web Services (AWS - ECS and RDS), Sharepoint & OneDrive
• Experience in data visualization platforms (e.g., Tableau, PowerBI) with the ability to understand the data and proof resulting visualizations from raw data reports.
• Advanced experience linking external APIs with in-house data visualization tools(s) and databases.
• Advanced communications skills, ability to clearly articulate complex concepts in a concise manner.
• Demonstrated competency in multi-tasking and problem-solving with focus on meeting deadlines in a fast-paced environment.
• Extremely organized and detail oriented.
• Bachelor’s Degree plus 3-5 years Amazon experience.

Travel Requirements: Minimal

Reporting Structure: Reports to Sr. Manager, Business Intelligence

Location: Remote, Chicago or Minnesota Preferred

 Compensation:

• Salary commensurate with level of experience and current market landscape
• Benefits package available: medical, dental, life insurance, 401k
• Additional Options: vision, short term & long-term disability
• Company provided computer