Web Based Mapping - Program Manager for the Community Information System Project (Ottawa)

[Tracey P. Lauriault]

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  [phone]

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Gerry Tychon-2]

Just to be a contrarian, why do people think they always need a relational database?

... ggt

On 12/03/2013 10:13 AM, Tracey P. Lauriault wrote:

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  [phone]

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Karl Dubost]

Le 12 mars 2013 à 12:44, Gerry Tychon a écrit :
> Just to be a contrarian, why do people think they always need a relational database?

Because many *people* are just… people like all of us. We just share what we know and what constitute our world. We are unaware of the rest. The interesting part is more what we want to achieve and if there is a room to go with other solutions *if* necessary. :)

drifting, philosophy, fish and chips, and burger. I'm just hungry ;)

--
Karl Dubost
http://www.la-grange.net/karl/

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Ted Strauss]

I think also because most CMS's are backed by relational databases, and haven't caught up with the NoSQL wave.

But it's just a matter of time before user requirements and data scales outstrip the conventional powers of RDBMS.

On Tue, Mar 12, 2013 at 12:44 PM, Gerry Tychon <[hidden email]> wrote:

Just to be a contrarian, why do people think they always need a relational database?

... ggt

On 12/03/2013 10:13 AM, Tracey P. Lauriault wrote:

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  <a href="tel:[phone]" value="[phone]" target="_blank">613-236-7060

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
<a href="tel:[phone]" value="[phone]" target="_blank">613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Glen Newton]

For 97% of CMS use cases, a relational database will scale just fine. Today and going forward.

-Glen

On Tue, Mar 12, 2013 at 12:58 PM, Ted Strauss <[hidden email]> wrote:

I think also because most CMS's are backed by relational databases, and haven't caught up with the NoSQL wave.

But it's just a matter of time before user requirements and data scales outstrip the conventional powers of RDBMS.

On Tue, Mar 12, 2013 at 12:44 PM, Gerry Tychon <[hidden email]> wrote:

Just to be a contrarian, why do people think they always need a relational database?

... ggt

On 12/03/2013 10:13 AM, Tracey P. Lauriault wrote:

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  <a href="tel:[phone]" value="[phone]" target="_blank">613-236-7060

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
<a href="tel:[phone]" value="[phone]" target="_blank">613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--
-
http://zzzoot.blogspot.com/
-

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Ted Strauss]

If by CMS you mean Wordpress, then sure, upper 90s.

But for increasingly multi-platform, multi-gigabyte-scale, realtime web applications, relational databases will not scale.

Most CMS's already using non-relational search engines to handle search-related tasks.

Of course not all DBs are created equal.

MySQL has been the most popular for years. but since it has been acquired by Oracle (from Sun) it's becoming 

clear to the open  source community that Oracle intends to hinder development of mysql to favour its own paid services. 

This has long term implications for open source CMS developers (wordpress, drupal) who have bet heavily

on mysql. The obvious open-source alternative is Postgresql (a relational DB). At the same time, the NoSQL paradigm 

(non-relational) is emerging as a viable alternative to RDBMS's for many applications, especially high performance ones.

The point is that there are new ways to build web sites and apps, and organizations need to stay up to date with these 

changes.

Is that what you meant Gerry? ;)

On Tue, Mar 12, 2013 at 1:03 PM, Glen Newton <[hidden email]> wrote:

For 97% of CMS use cases, a relational database will scale just fine. Today and going forward.

-Glen

On Tue, Mar 12, 2013 at 12:58 PM, Ted Strauss <[hidden email]> wrote:

I think also because most CMS's are backed by relational databases, and haven't caught up with the NoSQL wave.

But it's just a matter of time before user requirements and data scales outstrip the conventional powers of RDBMS.

On Tue, Mar 12, 2013 at 12:44 PM, Gerry Tychon <[hidden email]> wrote:

Just to be a contrarian, why do people think they always need a relational database?

... ggt

On 12/03/2013 10:13 AM, Tracey P. Lauriault wrote:

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  <a href="tel:[phone]" value="[phone]" target="_blank">613-236-7060

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
<a href="tel:[phone]" value="[phone]" target="_blank">613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

-
http://zzzoot.blogspot.com/
-

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Gerry Tychon]

(I will resend since I seem to have gotten some email server error)

Yes, Ted, you have pretty much summarized much of my thinking. And I also would like to see more use of semantic databases although it may be difficult for some to think outside the "table" paradigm.

... ggt

On Tue, Mar 12, 2013 at 2:09 PM, Ted Strauss <[hidden email]> wrote:

If by CMS you mean Wordpress, then sure, upper 90s.

But for increasingly multi-platform, multi-gigabyte-scale, realtime web applications, relational databases will not scale.

Most CMS's already using non-relational search engines to handle search-related tasks.

Of course not all DBs are created equal.

MySQL has been the most popular for years. but since it has been acquired by Oracle (from Sun) it's becoming 

clear to the open  source community that Oracle intends to hinder development of mysql to favour its own paid services. 

This has long term implications for open source CMS developers (wordpress, drupal) who have bet heavily

on mysql. The obvious open-source alternative is Postgresql (a relational DB). At the same time, the NoSQL paradigm 

(non-relational) is emerging as a viable alternative to RDBMS's for many applications, especially high performance ones.

The point is that there are new ways to build web sites and apps, and organizations need to stay up to date with these 

changes.

Is that what you meant Gerry? ;)

On Tue, Mar 12, 2013 at 1:03 PM, Glen Newton <[hidden email]> wrote:

For 97% of CMS use cases, a relational database will scale just fine. Today and going forward.

-Glen

On Tue, Mar 12, 2013 at 12:58 PM, Ted Strauss <[hidden email]> wrote:

I think also because most CMS's are backed by relational databases, and haven't caught up with the NoSQL wave.

But it's just a matter of time before user requirements and data scales outstrip the conventional powers of RDBMS.

On Tue, Mar 12, 2013 at 12:44 PM, Gerry Tychon <[hidden email]> wrote:

Just to be a contrarian, why do people think they always need a relational database?

... ggt

On 12/03/2013 10:13 AM, Tracey P. Lauriault wrote:

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  <a href="tel:[phone]" value="[phone]" target="_blank">613-236-7060

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
<a href="tel:[phone]" value="[phone]" target="_blank">613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

-
http://zzzoot.blogspot.com/
-

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

[Gerry Tychon-2]

(I will resend since I seem to have gotten some email server error)

Yes, Ted, you have pretty much summarized much of my thinking. And I also would like to see more use of semantic databases although it may be difficult for some to think outside the "table" paradigm.

... ggt

On Tue, Mar 12, 2013 at 2:09 PM, Ted Strauss <[hidden email]> wrote:

If by CMS you mean Wordpress, then sure, upper 90s.

But for increasingly multi-platform, multi-gigabyte-scale, realtime web applications, relational databases will not scale.

Most CMS's already using non-relational search engines to handle search-related tasks.

Of course not all DBs are created equal.

MySQL has been the most popular for years. but since it has been acquired by Oracle (from Sun) it's becoming 

clear to the open  source community that Oracle intends to hinder development of mysql to favour its own paid services. 

This has long term implications for open source CMS developers (wordpress, drupal) who have bet heavily

on mysql. The obvious open-source alternative is Postgresql (a relational DB). At the same time, the NoSQL paradigm 

(non-relational) is emerging as a viable alternative to RDBMS's for many applications, especially high performance ones.

The point is that there are new ways to build web sites and apps, and organizations need to stay up to date with these 

changes.

Is that what you meant Gerry? ;)

On Tue, Mar 12, 2013 at 1:03 PM, Glen Newton <[hidden email]> wrote:

For 97% of CMS use cases, a relational database will scale just fine. Today and going forward.

-Glen

On Tue, Mar 12, 2013 at 12:58 PM, Ted Strauss <[hidden email]> wrote:

I think also because most CMS's are backed by relational databases, and haven't caught up with the NoSQL wave.

But it's just a matter of time before user requirements and data scales outstrip the conventional powers of RDBMS.

On Tue, Mar 12, 2013 at 12:44 PM, Gerry Tychon <[hidden email]> wrote:

Just to be a contrarian, why do people think they always need a relational database?

... ggt

On 12/03/2013 10:13 AM, Tracey P. Lauriault wrote:

JOB POSTING

 

Position: Program Manager for the Community Information System Project

 

Conditions:

• 4 month contract, with possibility of extension
• 35 hours per week at $50,000 per annum pro-rated 

 

Description of the Position:

 

The Project Manager is responsible to implement new components of a web-based community information system which supports voluntary sector organizations in doing their own evaluation, program monitoring and research.

 

The community information system is a web infrastructure that facilitates voluntary sector agencies collecting and using agency and government data in planning and evaluation for their various initiatives.  The infrastructure provides tools to collect, report, visualize, share and communicate various kinds of data including community data from community projects and institutional/government data related to community services and social and economic issues.  The infrastructure includes:

1.     An on-line data portal which agencies use to document and report on some of their services through a relational database with various output options;

2.     Techonology enabled supports in line with the goal and standards of other open data initiatives, to help agencies find, use, and share community data in combination with government or administrative data;

3.     GIS supports to assist agencies to access and visualize relevant data;

4.     Training and capacity building supports;

5.     Partnership development to increase access to relevant data and the ability to use the information in a meaningful way.

Together these components allow community groups to combine their own data with other information relevant to them to support their evaluation and community-based research and to communicate efficiently on their needs and success to the public and funders.

 

The Program Manager will play a leadership role in implementing enhancements to the technology supports.  The main areas of responsibility are: 

a)              To work with community partners and the technology consultants to modify the on-line data management system supporting the Ottawa Neighbourhoods Social Capital Forum

b)             To implement on-line tools for finding, sharing, publishing and using community level and administrative data to support evaluation and program planning in the voluntary sector

c)              To implement a new process for providing GIS support to users infrastructure

d)             To develop and manage the related websites  (www.onscf.ca and www.cims-scic.ca)

e)              To implement the community information system in a manner that meets the needs of end users and supports the objectives of other Social Planning Council of Ottawa programs, most notably our sponsorship of the Ottawa consortium within the Community Data Program of CCSD

f)              To design and implement training and supports related to the infrastructure

 

This position demands excellent knowledge of website development, web-based databases, and collaborative community based data projects or collaborative community based research projects. 

 

Requirements:

• High level of computer literacy including database management, social statistics software (e.g., PCensus, and Beyond 20/20), communication tools and mapping software (Quantum GIS or ArcGIS);
• Excellent knowledge of Content Management Systems (CMS) with experience with at least one of the following platform Drupal, Django, Joomla
• Experience (intermediate level) with HTML, JavaScript and either PHP or Python
• Provision of IT support
• Familiarity with open data concepts and tools
• Website development experience
• Experience in project management to achieve expected results on time and within available resources;
• Masters degree in Computer Science, Geography, Urban Planning, Social Work, Public Policy, Population Health, Environmental Studies or related field, or three years related experience;
• Ability to work independently as well as collaboratively in a team approach;
• Ability to supervise and coordinate the work of consultants, student placements, and volunteers.

 

Experience in any of the following are assets:

• Bilingual (French / English)
• Experience negotiating data sharing agreements and protocols
• Familiarity with geomatics and mapping
• Good knowledge of the voluntary and health sectors in Eastern Ontario
• Knowledge of research and evaluation methodologies, frameworks and ethics relevant to the voluntary and health sectors
• Knowledge of a non-official language
• Experience in quantitative data analysis

 

Please submit your curriculum vitae to:

Hiring Committee

Social Planning Council of Ottawa

790 Bronson Avenue

Ottawa, Ontario

K1S 4G4

E-mail:  [hidden email]

Fax:  <a href="tel:[phone]" value="[phone]" target="_blank">613-236-7060

 

Closing Date:  Wednesday, March 20, 2013 at 5:00 p.m.

 

We regret that no phone calls can be taken with respect to this position and only those offered an interview will be contacted.

 

The SPCO is an equal opportunity employer.

 

Note:  There is a possibility that this position may be extended, depending on funding and the qualifications of the candidate.  If the position were to be extended, the work would focus less on the implementation of the technology solutions and more on working with community organizations and members to use the tools effectively.  The SPC reserves the right to re-post / re-hire for any continuation of the work beyond this four month contract.

--

Tracey P. Lauriault

Post Doctoral Fellow

Geomatics and Cartographic Research Centre

https://gcrc.carleton.ca/confluence/display/GCRCWEB/Lauriault

http://datalibre.ca/
<a href="tel:[phone]" value="[phone]" target="_blank">613-234-2805
 

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

-
http://zzzoot.blogspot.com/
-

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss

--

Ted Strauss

Co-founder of Trudat.co

I'm organizing Open Data Exchange in Montreal, April 6, 2013

_______________________________________________
CivicAccess-discuss mailing list
[hidden email]
http://lists.pwd.ca/mailman/listinfo/civicaccess-discuss