Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
Pentaho Developer image - Rise Careers
Job details

Pentaho Developer

Company Description

insightsoftware is a global provider of comprehensive solutions for the Office of the CFO. We believe an actionable business strategy begins and ends with accessible financial data. With solutions across financial planning and analysis (FP&A), accounting, and operations, we transform how teams operate, empowering leaders to make timely and informed decisions. With data at the heart of everything we do, insightsoftware enables automated processes, delivers trusted insights, boosts predictability, and increases productivity. Learn more at insightsoftware.com

    Job Description

    The Professional Services Consultant is a customer-facing role that requires a highly professional and experienced technical architect to design, develop, configure and support integrations with insightsoftware’s Agility PIM (Product Information Management) software primarily, but not exclusively, using Hitachi's Pentaho ETL tool. 

    What will you do?

    • Interact with customers to analyze their requirements and create customized solutions
    • Work with client and Agility PIM SME to scope, design and implement novel custom technical solutions that meet client goals
    • Troubleshoot and resolve integration issues, providing actionable solutions and anticipating future challenges
    • Work primarily (but not exclusively) using the Pentaho ETL tool

    Achievements/Goals within first 3-6 months:

    • Complete a comprehensive 2-week training program for Agility PIM including its Steps for Hitachi’s Pentaho ETL
    • Gain expertise in Agility PIM tool by shadowing other consultants on project work during the first 2 months
    • At 3 months, successfully troubleshoot issues with existing integrations created with Hitachi’s Pentaho ETL tool
    • At 4 months, write basic transformations using the Agility PIM Steps for Hitachi’s Pentaho ETL tool
    • At 6 months, independently write complex integration jobs comprised of multiple transformations

    How will you do it?

    • Communication - Communicate effectively with customers and internal cross-functional partners, creating promoters at every touchpoint  
    • Teamwork - Work cross-functionally to achieve team and individual goals  
    • Enthusiasm - Exhibit passion and excitement and embrace a can-do attitude  
    • Perseverance - Demonstrate focus and commitment to solving complex issues through to completion  
    • Drive and Discipline - Operate in a fast-paced, dynamic environment with a focus on generating high-quality results

    Qualifications

    • Strong knowledge of Hitachi Pentaho (6-10 years)
    • Strong knowledge of Microsoft Excel and SQL (6-10 years)
    • Utilization of web services/APIs, consuming JSON/XML data (third party integrations) (6-10 years)
    • Solid foundation in Computer Science, with strong competencies in data structures, algorithms and software design (6-10 years)
    • Exposure and/or experience with PIM, MDM, DAM or other related solutions a plus
    • Experience with Elasticsearch, Adobe InDesign, Javascript, or nodeJS a plus
    • Understanding of data modelling best practices
    • Experience with estimating and project planning preferred
    • Exceptional English written and verbal communication skills
    • Strong analytical and problem-solving skills and attention to detail
    • Methodical approach to troubleshooting
    • Experience working in a multi-client setting highly preferred
    • Demonstrate our core values: Results Orientation, Winning Attitude, Be One Team, Disciplined Execution, and Growth Mindset

    Additional Information

    All your information will be kept confidential according to EEO guidelines.

    ** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

    #LI-Remote

    Learn more about our high-energy, high-performance global team. Work With Us »

    insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

    Background checks are required for employment with insightsoftware, where permitted by country, state/province.

    At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

    ** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

    Learn more about our high-energy, high-performance global team. Work With Us »

    insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)

    Background checks are required for employment with insightsoftware, where permitted by country, state/province.

    At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

    insightsoftware Glassdoor Company Review
    3.4 Glassdoor star iconGlassdoor star iconGlassdoor star icon Glassdoor star icon Glassdoor star icon
    insightsoftware DE&I Review
    3.5 Glassdoor star iconGlassdoor star iconGlassdoor star icon Glassdoor star icon Glassdoor star icon
    CEO of insightsoftware
    insightsoftware CEO photo
    Michael Sullivan
    Approve of CEO

    Average salary estimate

    $115000 / YEARLY (est.)
    min
    max
    $100000K
    $130000K

    If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

    What You Should Know About Pentaho Developer, insightsoftware

    As a Pentaho Developer at insightsoftware, you will play a vital role in enhancing the operational efficiencies of our clients. Our company is renowned for providing tailored solutions for the Office of the CFO, and as part of this mission, your primary responsibility will be to design, develop, and support integrations with Agility PIM using Hitachi's Pentaho ETL tool. Your journey will begin with comprehensive training, where you’ll gain in-depth knowledge about our software and its functionalities. You’ll collaborate closely with clients, analyzing their needs and developing customized solutions that address their specific challenges. The role demands proactive troubleshooting skills, as you will not only resolve integration issues but also anticipate potential future challenges. Your success in this position will rely on strong communication skills, teamwork, and a steadfast commitment to quality results. At insightsoftware, we foster a dynamic environment where enthusiasm and dedication are valued and rewarded. If you have a solid background in data structures, algorithms, and experience with APIs/JSON/XML data, this might be the perfect opportunity for you to grow and make a significant impact in the fast-paced tech landscape. Join us and be part of a team that truly values your contributions and supports your professional development in a friendly and upbeat environment!

    Frequently Asked Questions (FAQs) for Pentaho Developer Role at insightsoftware
    What responsibilities does a Pentaho Developer at insightsoftware have?

    As a Pentaho Developer at insightsoftware, your primary responsibilities include designing, developing, and configuring integrations with Agility PIM using Hitachi's Pentaho ETL tool. You will analyze customer requirements to create tailored solutions, troubleshoot integration issues, and actively participate in the customer engagement process. Effective communication and strong problem-solving skills are crucial in ensuring client satisfaction and project success.

    Join Rise to see the full answer
    What qualifications are needed for the Pentaho Developer position at insightsoftware?

    The ideal candidate for the Pentaho Developer role at insightsoftware should have 6-10 years of experience with Hitachi Pentaho, Microsoft Excel, and SQL. A solid foundation in computer science, along with strong competencies in data structures and software design, is essential. Familiarity with web services/APIs, JSON/XML, and experience in a multi-client setting are also significant assets in meeting the qualifications for this role.

    Join Rise to see the full answer
    How does the training process work for a Pentaho Developer at insightsoftware?

    Once you become a Pentaho Developer at insightsoftware, you will undergo a comprehensive two-week training program focused on Agility PIM and Hitachi Pentaho ETL tool. Throughout your initial months, you will shadow experienced consultants on various projects, enabling you to rapidly gain expertise and become proficient at troubleshooting integration issues and writing basic transformations.

    Join Rise to see the full answer
    What is the work environment like for a Pentaho Developer at insightsoftware?

    As a Pentaho Developer at insightsoftware, you will work in a dynamic, remote environment that promotes collaboration and effective communication. The culture values enthusiasm, teamwork, and a results-oriented mindset, ensuring that you have the support you need to thrive and make a genuine impact on client success while enjoying the flexibility of remote work.

    Join Rise to see the full answer
    What tools and technologies will I work with as a Pentaho Developer at insightsoftware?

    In your role as a Pentaho Developer at insightsoftware, you will primarily work with the Hitachi Pentaho ETL tool, alongside other technologies such as Microsoft Excel and SQL. Familiarity with APIs, JSON/XML data, and potentially tools like Elasticsearch and JavaScript will be beneficial. Continuous learning and adapting to the latest technologies will also be encouraged to enhance your skill set.

    Join Rise to see the full answer
    Common Interview Questions for Pentaho Developer
    Can you describe your experience with the Pentaho ETL tool?

    When answering this question, you can highlight specific projects where you utilized Pentaho ETL for data integration tasks. Discuss the challenges faced and how you overcame them, emphasizing your troubleshooting skills and knowledge of the tool's functionalities.

    Join Rise to see the full answer
    How do you approach gathering requirements from clients?

    Your response should reflect your methodical approach to client interactions. Mention how you listen actively, ask probing questions, and clarify uncertainties to ensure a comprehensive understanding of client needs, which ultimately leads to tailored solutions.

    Join Rise to see the full answer
    Could you give an example of a complex integration issue you resolved?

    Provide a detailed yet concise example demonstrating your problem-solving skills. Outline the issue, your analytical approach, the steps taken for resolution, and the positive results that followed, showcasing your ability to handle complexity effectively.

    Join Rise to see the full answer
    What experience do you have with SQL and how have you used it in past roles?

    Discuss specific instances where you used SQL for data retrieval or manipulation in your projects. Highlight your understanding of database management, querying techniques, and share examples of how your SQL skills contributed to successful outcomes.

    Join Rise to see the full answer
    How do you ensure the quality of your integration solutions?

    Explain your commitment to quality assurance through testing, peer reviews, and following best practices in coding and integration processes. Emphasize the importance of delivering high-quality, reliable solutions to clients.

    Join Rise to see the full answer
    What strategies do you use to troubleshoot integration issues?

    Your answer should illustrate your systematic approach to troubleshooting. Discuss how you analyze logs, isolate variables, test solutions iteratively, and collaborate with team members to identify and resolve issues efficiently.

    Join Rise to see the full answer
    How do you stay current with technology trends in data integration?

    Highlight your proactive learning methods, such as attending workshops, taking online courses, and following relevant industry news. Show your commitment to continuous improvement as a Pentaho Developer by adapting to new technologies and methodologies.

    Join Rise to see the full answer
    Can you explain the role of APIs in integrations?

    Discuss the importance of APIs in enabling different software systems to communicate effectively. Provide examples of how you've utilized APIs in past projects for data exchange and integration, showcasing your understanding of web services.

    Join Rise to see the full answer
    How do you prioritize tasks when working on multiple client projects?

    Share your time management strategies, such as using project management tools, setting clear priorities, and communicating transparently with clients and team members to ensure timely delivery and satisfaction.

    Join Rise to see the full answer
    What excites you about the Pentaho Developer role at insightsoftware?

    Express your enthusiasm for the opportunity to work with innovative technology and impact clients positively. Discuss your eagerness to work in a collaborative environment that values growth and results, aligning your motivations with insightsoftware's mission.

    Join Rise to see the full answer
    Similar Jobs
    Photo of the Rise User
    insightsoftware Remote Remote, Remote, United States
    Posted 3 days ago

    Join insightsoftware as a Senior Account Executive and leverage your expertise in enterprise software sales to accelerate business growth.

    Photo of the Rise User

    Seeking a strategic Global Benefits Manager to lead and manage employee benefit programs at insightsoftware, ensuring compliance and operational excellence.

    Photo of the Rise User

    Join Northwestern Medicine as an Analytics Developer to drive strategic decision-making through data insights in a collaborative environment.

    Photo of the Rise User
    Posted 4 days ago

    Join Lucile Packard Children's Hospital Stanford as the Director of Analytics, where you'll shape the future of data governance and insights in pediatric healthcare.

    Photo of the Rise User

    Become a vital part of UM Capital Region Medical Center as a Trauma Registry Associate, focusing on data management for trauma cases.

    Posted yesterday

    Join Sallie as a Senior Data Engineer and help revolutionize the educational experience for students through innovative data solutions.

    Photo of the Rise User
    CarShield Hybrid St. Peters, Missouri, United States
    Posted 3 days ago

    Join our team as a Database Engineer, where your expertise in SQL Server will help elevate our data handling to the next level.

    Chevron Hybrid RMZ Ecoworld 32
    Posted 6 days ago

    Lead data initiatives and build a world-class data team as Chevron's Data and Analytics Executive.

    Photo of the Rise User

    Lead Visa's regional Merchant Data strategy and drive data management excellence across North America and Latin America.

    Photo of the Rise User

    Join Synchrony as a Data Quality Developer to improve data integrity and contribute to analytics in a dynamic financial services environment.

    We empower organizations with the financial confidence to achieve greatness.

    93 jobs
    MATCH
    Calculating your matching score...
    FUNDING
    DEPARTMENTS
    SENIORITY LEVEL REQUIREMENT
    TEAM SIZE
    EMPLOYMENT TYPE
    Full-time, remote
    DATE POSTED
    April 15, 2025

    Subscribe to Rise newsletter

    Risa star 🔮 Hi, I'm Risa! Your AI
    Career Copilot
    Want to see a list of jobs tailored to
    you, just ask me below!
    LATEST ACTIVITY
    Photo of the Rise User
    Someone from OH, Hamilton just viewed Team Member Travel Coordinator at Allegiant
    Photo of the Rise User
    37 people applied to Data Annotator - Remote at Cortech
    Photo of the Rise User
    Someone from OH, Kent just viewed Senior Director, Program at Teaching Lab
    Photo of the Rise User
    Someone from OH, Toledo just viewed IT Telecom Administrator at Anduril Industries
    Photo of the Rise User
    Someone from OH, Kent just viewed Director, Strategic Partnerships at Teaching Lab
    Photo of the Rise User
    1000+ people applied to Data Entry Clerk Typing at Talentify.io
    G
    Someone from OH, Cincinnati just viewed Operations Lead - AML Refresh Ops (Global Banking) at GHR
    Photo of the Rise User
    Someone from OH, Akron just viewed Data Scientist II at Kaiser Permanente
    Photo of the Rise User
    Someone from OH, Eastlake just viewed Summer Intern at Gooch & Housego
    I
    Someone from OH, Perrysburg just viewed CNC Manufacturing Technician at Innovance
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Senior Lifecycle Marketing Manager at SoFi
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Lifecycle Marketing Manager at Caribou
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Senior Marketing Manager at Ocorian
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Growth Marketing Manager at Credit Genie
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Director of Product Marketing - AAA Campaigns at PrizePicks
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Digital Marketing Analyst, Digital Properties at Darden
    Photo of the Rise User
    Someone from OH, Cincinnati just viewed Growth Lead at io.net