×

Are you sure?

This cannot be undone.
Employment

Report Developer (SQL Server/SSRS/Microsoft Dynamics)

Lehigh University

https://www1.lehigh.edu/

Responsible for providing information support for operational and project-based needs for Development and Alumni Relations operations at the University. The Lehigh community takes seriously our commitment to antiracism and The Principles of our Equitable Community.

1. Provide front line support for the information utilized in Development and Alumni Relations (DAR) operations at the University

  • Manage incoming tickets in the customer support system
  • Respond to requests in a timely manner
  • Collect information about user problems
  • Effectively guide non-technical users through the issue resolution process
  • Provide excellent communication to non-technical users through written, graphical, verbal and in person communications
  • Refer issues to other areas (e.g. other DAR Operations teams, Library and Technology Services, etc.) as appropriate
  • Create and maintain documentation relevant to team responsibilities

2. Utilize, support and promote the use of the DAR’s primary information system, Customer Relationship Management (CRM) Advance, related information systems, reporting tools and analytic tools

  • Assist and advise DAR users on the best practices for utilizing CRM Advance to achieve their goals
  • Utilize Microsoft SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT) and T-SQL at an intermediate to advanced level to create and maintain reports, dashboards and CRM Advance UI
  • Create new reports, dashboards and CRM Advance UI which are easily understood, modified and maintained by other team members and adhere to organization and team processes and standards
  • Collect requirements from non-technical users
  • Translate requests into needs focusing on end goals, not just user requests
  • Create reports, dashboards and CRM Advance UI with an emphasis on end user ease of use
  • Ensure reports, dashboards and CRM Advance UI provide accurate, complete and timely information
  • Maintain existing reports, dashboards and CRM Advance UI
  • Modify reports, dashboards and CRM Advance UI in response to feature requests, changes in CRM Advance, change in organization, team processes and standards and to resolve issues
  • Provide information analysis (trends, correlations, relationships, etc.) to support organizational decisions
  • Participate in the testing of System upgrades
  • Provide CRM Advance subject matter expertise to the Training and Project Management team as needed

3. Effectively manage a mix of project and operational work

  • Appropriately prioritize a large volume of multiple requests, projects, issues, etc.
  • Adapt to changing priorities based on a fast-moving dynamic environment
  • Independently manage projects as determined by DAR Operations management
  • Collect the needs of stakeholders at various levels and positions within the organization
  • Effectively communicate project status and issues to management
  • Meet project deadlines

4. Support and collaborate with a diverse University community

  • Maintain excellent relations between DAR Operations, DAR and the Lehigh Community
  • Serve as the liaison for information between DAR and other Lehigh Stems, colleges, offices, departments, etc.
  • Maintain excellent intra-team relationships
  • Collaborate with team members as necessary with a focus on maximizing available time and resources
  • Serve as a backup to Systems Specialists for day to day operations
  • Occasionally volunteer to support other teams in DAR

5. Maintain proficiency in the systems and technologies used by DAR

  • Monitor relevant publications, websites, listservs, etc. to keep up to date on systems, technology, fundraising trends and other professional development topics relevant to the team
  • Attend conferences and professional groups to keep up to date on systems, technology, fundraising trends, and other professional development topics relevant to the team.
  • Attend training, including training offered internally at Lehigh and by DAR, to keep up to date on systems, technology, fundraising trends, and other professional development topics relevant to the team.
  • Proactively maintain knowledge and expertise in the latest CRM Advance features, data architecture of CRM Advance and auxiliary system used as data sources and Microsoft SSRS, SSDT, T-SQL and relational database concepts

Grade: 9 – 40

Position Number: S85900

Special Considerations

This position is expected to partially work remote while the campus remains in a limited capacity due to COVID-19; in the future it is expected that this position will be staffed on campus where they can be fully accessible to the Lehigh community

Will often be required to stand, sit, walk, use hands to reach, touch, handle or feel, stoop, kneel, crouch or crawl and lift up to 10 pounds

Qualifications

  • Associates Degree in Computer Science, Information Systems, Information Technology or related field or equivalent combination of education and experience; Bachelor’s Degree preferred
  • Three to five years related work experience
  • Excellent computer skills with experience using word processing, spreadsheet and database software
  • Proven ability to manage multiple tasks simultaneously and a high degree of initiative for bringing tasks to completion
  • Excellent communication, interpersonal skills and a high level of customer service
  • Ability to complete projects on time and report on status and progress
  • Solid analytical and decision-making skills
  • Ability to build, foster and maintain positive professional relationships
  • Successful completion of standard background checks including but not limited to: social security verification, education verification, national criminal background checks, motor vehicle checks, PATCH, FBI fingerprinting, Child Abuse Clearance and credit history based upon the requirements of the position

Because of increasing COVID case counts in the region and new information about the characteristics of the Delta variant, all Lehigh faculty and staff will be required to be fully vaccinated unless they receive an approved medical or religious exemption from the requirement.

Only complete applications will be considered therefore please complete the application in its entirety.  Once the posting is removed from the website applications may no longer be allowed to be completed.

Details

Type:
Full-Time
State(s):
Pennsylvania
Location(s):
Bethlehem, PA
Function:
Information Technology
Industry:
Education/Research
Salary:
$51,760 to $62,990
Posted on:
September 13, 2021

How to Apply

To view a full position description, and to apply, please visit our online posting:

https://careers.pageuppeople.com/865/cw/en-us/job/499638/report-developer-sql-serverssrsmicrosoft-dynamics