Google Apps Script Developer Jobs in Philadelphia, PA

About the RoleCanon USA in Melville, NY is currently seeking a Data Analytics Analyst (Analyst, Data Analytics). As a Data Analyst within the Revenue Operations team, you will serve as a vital technical link between product planning, strategic pricing, and sales execution for direct sales. This role is specialized within the RevOps ecosystem: you will focus on internal business unit reporting, program utilization, pricing efficacy, and deep-dive business analytics to drive informed decision-making. Success in this role requires a candidate who understands the B2B sales cycle and how Salesforce.com (SFDC) serves as the backbone of sales reporting. While you will manage essential workflows involving legacy enterprise systems, you will also be a primary architect for our future reporting landscape in Looker Studio, Microsoft Fabric and Power BI. You will play a key role in our department's digital transformation. We value technological agility and look for candidates who leverage modern tools-including Generative AI (GenAI)-to accelerate coding, automate manual processes, and navigate complex data environments.   This position is full time and offers a hybrid work schedule requiring you to be in the office Monday, Tuesday and Wednesday and an option to work from home the remainder of the week (unless a specific business need arises requiring in office attendance on other days).  Note that work schedules and office reporting requirements may change from time to time based on business needs.Your Impact1. Business Strategy & Profitability Analytics - Customer Segmentation: Analyze and define our customer base to identify "Who are our customers?" and categorize them by behavior, size, and loyalty - Profitability Modeling: Perform deep-dive analysis into sales data to identify which customers and accounts yield the highest profit margins - Vertical Performance: Track and report on Gross Profit (GP) by Vertical, identifying trends in specific industries to help leadership pivot strategy - Predictive Insights: Use historical data to forecast which programs or product mixes will drive the most significant ROI for the direct sales force 2. Strategic Pricing & Business Intelligence - Reporting Architecture: Own and evolve the Power BI reporting suite that supports all business units - Financial Modeling: Analyze internal program usage (credit/discount programs) and perform ROI modeling to identify business opportunities - Executive Summaries: Consolidate data from disparate sources to provide "big picture" summaries and storytelling for Product Planning and Strategic Pricing leadership 3. Data Engineering & Workflow Automation - Technical Stack: Use SQL and Python to extract, consolidate, and analyze data from disparate sources - Process Automation: Utilize Google Apps Script and other automation tools to streamline data collection and bridge gaps between Google Workspace and Microsoft-based legacy tools - AI-Augmented Productivity: Leverage Generative AI tools to assist in writing/debugging code (SQL/Python/Apps Script) and documenting complex legacy workflows 4. Sales Ecosystem Integration - CRM & Sales Cycle Alignment: Apply an understanding of the B2B sales cycle and Salesforce.com (SFDC) to ensure that item codes, pricing logic, and reporting structures align with field sales requirements About You: The Skills & Expertise You Bring- Bachelor's degree in a relevant field or equivalent experience required, plus 3 to 5 years of related experience - Technical Proficiency: - Data Tools: Strong proficiency in SQL and Python for data manipulation - Visualization: Experience building advanced reports in Power BI (specifically for GP and Vertical analysis), Looker experience a plus - Modern Ecosystems: Familiarity with Microsoft Fabric and Google Apps Script and bridging Google/Microsoft environments - Systems: Working knowledge of Salesforce.com (SFDC) and legacy ERP environments - Business Acumen: - Strong Financial Literacy, specifically in calculating Gross Profit, ROI, and margin analysis - Solid understanding of B2B sales cycle and customer segmentation strategies - Experience: 3 to 5 years in a highly technical Data or Revenue Operations role. Experience in a product/solutions sales environment is highly preferred - GenAI Literacy: Familiarity with using Generative AI platforms to optimize technical workflows - Detail Orientation: Extreme attention to detail is required   We are providing the anticipated salary range for this role: $69,300 - $103,770 annuallyCompany OverviewAbout our Company - Canon U.S.A., Inc., is a leading provider of consumer, business-to-business, and industrial digital imaging solutions to the United States and to Latin America and the Caribbean markets. With approximately $28.5 billion in global revenue, its parent company, Canon Inc., as of 2024 has ranked in the top-10 for U.S. patents granted for 41 consecutive years. Canon U.S.A. is dedicated to its Kyosei philosophy of social and environmental responsibility. To learn more about Canon, visit us at www.usa.canon.com and connect with us on LinkedIn at https://www.linkedin.com/company/canonusa.

Who We Are

Where Talent Fosters Innovation. Do you want your next professional experience to be filled with purpose and opportunity, world-class team members, and impactful work? Driven by our mission of exceeding customer expectations with our technologies and enriching the lives of our local communities and staff, we are a phenomenal team working collaboratively toward common goals. Our employees have a strong work ethic, creativity, and a cooperative spirit. We believe in integrity, respect, empowerment, and making a difference in the communities we serve. There is a strong sense of pride in what we do individually and together as a team. Join us and discover what it means to work for a global digital imaging leader with an unparalleled reputation for quality and innovation.

What We Offer

You'll be joining a leader in digital imaging and innovation with an immense opportunity to make an impact and create your own rewarding career. We demonstrate commitment to our employees by offering a full range of rewards, including competitive compensation and benefits.

And Even More Perks!

-Employee referral bonus -Employee discounts -"Dress for Your Day" attire program (casual is welcome, based on your job function) -Volunteer opportunities to give back to our local community -Swag! A Canon welcome kit and official merch you can't get anywhere else Based on weekly patent counts issued by United States Patent and Trademark Office. All referenced product names, and other marks, are trademarks of their respective owners. Canon U.S.A., Inc. offers a competitive compensation package including medical, dental, vision, 401(k) Savings Plan, discretionary profit sharing, discretionary success sharing, educational assistance, recognition programs, vacation, and much more. A more comprehensive list of what we have to offer is available at https://www.usa.canon.com/about-us/life-at-canon/benefits-and-compensation We comply with all applicable federal, state and local laws, regulations, orders and mandates, including those we may be required to follow as a federal government contractor/subcontractor. You must be legally authorized to work in the United States. The Company will not pursue or support visa sponsorship. All applicants must reside in the United States at the time of hire. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. If you are not reviewing this job posting on our Careers' site https://www.usa.canon.com/about-us/life-at-canon, we cannot guarantee the validity of this posting. For a list of our current postings, please visit us at https://www.usa.canon.com/about-us/life-at-canon. #CUSA Workstyle DescriptionHybrid - This position is full time and offers a hybrid work schedule requiring you to be in the office three days a week and an option to work from home the remainder of the week (unless a specific business need arises requiring in office attendance on other days). Note that work schedules and office reporting requirements may change from time to time based on business needs.Posting Tags#PM19 #LI-AV1 #LI-HYBRIDQualifications:- Bachelor's degree in a relevant field or equivalent experience required, plus 3 to 5 years of related experience- Technical Proficiency:- Data Tools: Strong proficiency in SQL and Python for data manipulation- Visualization: Experience building advanced reports in Power BI (specifically for GP and Vertical analysis), Looker experience a plus- Modern Ecosystems: Familiarity with Microsoft Fabric and Google Apps Script and bridging Google/Microsoft environments- Systems: Working knowledge of Salesforce.com (SFDC) and legacy ERP environments- Business Acumen:- Strong Financial Literacy, specifically in calculating Gross Profit, ROI, and margin analysis- Solid understanding of B2B sales cycle and customer segmentation strategies- Experience: 3 to 5 years in a highly technical Data or Revenue Operations role. Experience in a product/solutions sales environment is highly preferred- GenAI Literacy: Familiarity with using Generative AI platforms to optimize technical workflows- Detail Orientation: Extreme attention to detail is requiredWe are providing the anticipated salary range for this role: $69,300 - $103,770 annuallyEmployment Type: OTHER