Department: Information Technology Reports To: Manager, Information Technology FLSA Status: Non-exempt, part-time (up to 20 hours per week); may be reclassified as a full-time, exempt position in the future
ABOUT SHPE The Society of Hispanic Professional Engineers (SHPE) was founded in Los Angeles, California, in 1974 by a group of engineers employed by the city of Los Angeles. Their objective was to form a national organization of professional engineers to serve as role models in the Hispanic community.
The concept of Networking was the key basis for the organization. SHPE quickly established two student chapters to begin the network that would grow to encompass the nation as well as reach countries outside the United States. Today, SHPE enjoys a strong but independent network of professional and student chapters throughout the nation.
Mission: SHPE changes lives by empowering the Hispanic community to realize their fullest potential and impacts the world through STEM awareness, access, support and development. Vision: SHPE's vision is a world where Hispanics are highly valued and influential as the leading innovators, scientists, mathematicians and engineers.
JOB SUMMARY Under the supervision of the IT Manager, this position serves as the primary in-house application specialist and data analyst for SHPE’s new Association Management System (AMS) and other enterprise systems and databases.
This position requires strong technical and organizational skills with an emphasis on translating complex business requirements into solutions. This person will work with staff to get a broader knowledge of the organization, understand how their business requirements can be supported by the AMS, and will begin the process of developing an information lifecycle management strategy.
This position is initially being offered as a part-time, non-exempt position with up to 20 hours per week. After 12 months, or upon the conclusion of the AMS implementation project, this position will be evaluated and may be reclassified as full-time, exempt position.
ESSENTIAL DUTIES AND RESPONSIBILITES
- Be the lead internal subject matter expert on SHPE’s new association management system
- Identify, analyze, create, and maintain reports and queries for staff using Crystal Reports, and/or SQL Enterprise Manager
- Work with internal stakeholders to identify and manage new functionality request and process changes
- Analyze functionality requests and align current and new database initiatives and data with SHPE’s business objectives and goals
- Work with solution providers to design enhancements or database modifications to meet new business needs
- Work with the solution providers to determine frequency, timing, and planning for AMS upgrades
- Coordinate with staff to write and/or maintain standard operating procedures that outline SHPE’sspecific use of all major systems
- Support internal stakeholders in using the AMS and other enterprise applications by developing and leading end-user training for departments or individual users
- Proactively monitor for data integrity of the production and the test AMS databases and create/maintain processes to support data integrity
- Perform system functionality testing and quality assurance – ongoing as needed and during system upgrades
- Lead integration efforts with third-party partners such as Constant Contact, CRI, and EventMobi
- Perform database administration and maintenance on core business applications, including but not limited to developing, running and monitoring nightly stored procedures, scripts, and triggers
- Conduct timely analysis, diagnosis, and resolution of complex database issues
- Verify the security and integrity of all database systems
- Analyze external data sources for potential import or comparison as needed to support SHPE business objectives
- Provide end user support on help desk requests related to key business applications
- Assist in managing open issues list on system functionality bugs and work with vendors and internal stakeholders as needed to resolve
- Establish SHPE data entry standards, train staff on procedures, and monitor compliance
QUALIFICATIONS
- Bachelor degree or equivalent is required
- 3+ years in an association setting (trade or professional) is strongly preferred
- 3+ years managing enterprise-level AMS or CRM systems is strongly preferred
- 3-5 years or more experience usingMicrosoft SQL Server 2008 or 2005 database administration including: SQL security; backup and recovery procedures; utilities and tools; experience writing complex queries, database views, stored procedures, and triggers is strongly preferred
- Demonstrable experience writing complex reports using Crystal Reports Designer, SQL Reporting Services or other reporting tools
- Demonstrated project management skills and the ability to manage multiple, changing priorities
- Proficiency with MS Office applications; advanced Excel knowledge and experience with MS Project is a plus
- Ability to quickly learn new systems, technology, and methods
- Microsoft Certified Database Administrator (MCDBA) certification is a plus
- Experience with data mining techniques, data warehouses, and dashboard tools is a plus
- ASP and .NET knowledge is a plus
- Understanding of content management systems, email marketing solutions, and QuickBooks (accounting software) are a plus
WORK ENVIRONMENT
Primarily, work will be conducted in a normal office environment in the SHPE headquarters office located in City of Industry, Calif. Periodic remote/telework options may also be available.
CONTACT INFORMATION
Please send all resume submissions and inquiries to
This e-mail address is being protected from spambots. You need JavaScript enabled to view it.
.
|