JCA: BI Engineer, Business Intelligence Group

JCA provides strategic consulting to the world leading nonprofits. BI Engineer will work with JCA Answers, JCA analytics, and other Enterprise BI systems and services.

JCA Company: JCA
Location: New York, NY
Web: www.jcainc.com

Email to jobs@jcainc.com

The goal of JCA's BI Group is to lead and support data-driven, results-based strategic decision making for our clients. We do this by using our BI tool JCA Answers, by providing enterprise-level BI consulting, and through our data mining and predictive analytics offerings. The BI Engineer will be a key resource to help build and deliver our offerings and support all the BI work we do at JCA.

This position will report to the Manager of the BI Group. The Manager will monitor the BI Engineer's professional growth and development, ensuring that this position has challenging and rewarding work.The BI Engineer will work closely with the Senior Technical Analyst to specify, program and implement BI Engineering tasks and projects.

JCA provides strategic consulting to the world's leading nonprofits. Since 1988, we have helped nonprofit organizations work smarter. As the first and largest independent consulting firm dedicated solely to the technical and operational needs of nonprofits, JCA has uncommon insight into the challenges our clients face.

JCA works with our clients and partners to help them leverage information in new ways to increase revenue, reduce costs, and better serve their missions. We strive to help our clients realize transformative change using by leveraging their information value-chain. Our services include:
  • System selection
  • Systems implementation
  • Systems integration
  • Custom software development
  • Business process optimization
  • Website development
  • Business intelligence
  • Analytics

To work at JCA, you must adhere to our core values.
1. We take our work seriously. We hold ourselves personally accountable for our work.
2. We are honest, no matter what.
3. We are fair and respectful to our clients and to each other.
4. Excellence drives us.

The following list describes the type of work the BI Engineer will perform.

1. JCA Answers
  • Install JCA Answers for clients who purchase Quick Start packages
  • Implement JCA Answers product enhancements, as part of product roadmap and client implementations
  • Provide Level 2 product support for JCA Answers
  • Provide technical input and suggestions for future product enhancements

2. JCA Analytics
  • Develop queries/views and create SSIS/ETL needed to build analytics project datasets; help automate the process to build analytics dataset
  • Create reports and data visualizations in support exploratory data analysis (SSRS reports, Excel, Power BI, others)
  • Test/QA custom programming developed by other group resources
  • Create reports and other tools to support deploying analytics projects

3. Enterprise BI
  • Support clients to build BI infrastructure (data warehouses, integration)
  • Produce reports and data visualizations to support enterprise BI efforts
  • Advise on technical approach for enterprise BI projects

4. BI Services
  • Program custom solutions for clients, which may include building data warehouses, ETL, SSIS, SSRS, SSAS, and IIS

5. Professional development
  • Perform independent research and/or attend conferences to build skill set and stay current on industry trends

  1. Experience with Microsoft BI tools:
    1. SQL Query
    2. SQL Server Integration Services (SSIS)
    3. SQL Server Reporting Services (SSRS)
    4. SQL Server Analysis Services (SSAS)
    5. Excel Pivot Tables and Pivot Charts
  2. Expand the capacity of JCA's BI Group through training and research.
  3. Understanding of the nonprofit sector a plus.
  4. Previous consulting experience a plus.

  • Competitive salary range based on experience and performance
  • Paid Vacation, Personal, and Sick time
  • 401(k) Retirement Plan
  • Employee Stock Ownership Plan (ESOP)
  • Health, Dental, and Vision Insurance
  • Life Insurance and Long Term Disability Insurance
  • Flexible Spending Account (FSA)