Skip to main content


In-Demand IT Careers

Community Investment Systems and Data Analyst

Pittsburgh, PA | Work from home flexibility

Posted: 06/18/2024 Job Category: Business Analyst Job Number: 6960

Job Description

OpenArc - Empowering Your Career. As a leading IT staffing firm, we are dedicated to connecting talented professionals with your ideal opportunities. We are currently seeking a qualified Community Investment Systems and Data Analyst to join our client’s organization and contribute to their ongoing success. 


Job summary

The Community Investment Systems and Data Analyst will manage the data and reporting functions of the Community Investment department and play a key role in the development, implementation and maintenance of new applications that support the grant and loan programs.


  • Acts as key business representative on the multi-year community investment product automation project to develop new systems that support grant and loan programs.

    • Collaborate with product managers and Information Technology to evaluate reporting and process improvements

    • Supports new product implementation and testing, focusing on integration and adoption of new data and reporting capabilities

  • In conjunction with Community Investment management, prepare and submit required reporting to external constituents (Federal Housing Finance Agency, Office of Diversity, Equity and Inclusion, Affordable Housing Advisory Council, Board of Directors, Corporate Social Responsibility, etc.).

  • Manage departmental analytics including identification and delivery of key information and tools that enhance decision-making, improve efficiency and measure impact. Includes monitoring of market intelligence, peer analysis and business trends.

  • Independently identify, develop, and implement new reports and enhancements for existing reports to further department priorities and goals.

  • Leads departmental Tableau content management. Includes design, development, maintenance and enhancements to existing Tableau reporting. Common functions include:

    • Goal tracking including product use, volume and product readiness

    • Product activity, volume and community impact

    • Member engagement initiatives, including events and call tracking

    • Activities with strategic partnerships

    • Market and/or peer analytics

  • Partners with Information Technology to ensure highest level of data standards are achieved to provide accurate and timely information to the department, Senior Management and stakeholders. Manages external data sources that supplement core system data and facilitates corresponding analytics. Translates business requirements to enhance or develop new data sources.

  • Ensures compliance with applicable policies, procedures and regulations to ensure safe and sound business practices.


  • Experience with an emphasis on project and product management in financial services.

  • Tableau experience required, advanced Tableau developer capabilities preferred; SaaS or Python experience a plus.

  • Experience with system development and automation of a business process or product strongly preferred.

  • Must be highly proficient with Microsoft Office products (e.g., Access, Excel, Word, PowerPoint).

  • Working knowledge of Information Technology and experience in community and economic development, financial services and/or real estate development.

  • Proven track record and skills to deeply understand service capabilities, assess risks, and formulate partnerships for consistent delivery of high-quality products and services.

  • Highly attentive to detail; ability to routinely manage large data sets.

  • Strong interpersonal skills - effective listening and teaming, self-motivated, demonstrated a bias for action.

  • Strong customer service, analytical, organizational and problem resolution capabilities.

  • Strong time management skills and the ability to multi-task.

  • Excellent written, oral, and presentation skills.

At OpenArc, we prioritize your career success and strive to build exceptional technical teams for our clients. By understanding your experience and aspirations, we ensure to present you with rewarding and fulfilling opportunities. 


As an employee of OpenArc and our clients, you will be eligible to participate in a comprehensive benefits package.


OpenArc is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Pittsburgh, PA

Unlock your next career adventure in Pittsburgh, Pennsylvania! Nestled between the three rivers, this vibrant city boasts a rich history, thriving arts scene, world-class universities, and a robust job market. From catching a Steelers game at Heinz Field to exploring the Andy Warhol Museum or indulging in a Primanti Bros sandwich, Pittsburgh offers a unique blend of cultural experiences and professional opportunities. Embrace the charm of this dynamic city and discover your dream job among our diverse listings. Join us in the Steel City and elevate your career to new heights!

Take the Next Step