NO THIRD PARTY /CORP TO CORP CAMDIDATES WILL BE CONSIDERED

Systems Architect, BI

REPORTS TO:

Manager, Applications and Development (150)

SUMMARY:

Develop BI reports using Power BI, SSRS, or other reporting tools. Use ad-hoc reporting to present technical business information, analyze data to provide business solutions such as increasing productivity or cutting costs, evaluate and enhance current ETL processes, and provide database support by scripting or modifying SQL queries. Prepare systems for deployment, configure, monitor, administer, and troubleshoot commercial off-the-shelf information systems. Coordinate and manage projects as assigned and work with users to develop requirements and specifications for configuration changes to off-the-shelf information systems. Write, test, and maintain custom reports using standard business intelligence and report writing tools. Develop training materials and train users in the use of off-the-shelf information systems.

DUTIES AND RESPONSIBILITIES:

• Develop BI reports using Power BI, SSRS, or other reporting tools.
• Use ad-hoc reporting to present technical business information.
• Analyze data to provide business solutions, such as increasing productivity or cutting costs.
• Evaluate and enhance current ETL processes.
• Provide database support by scripting or modifying SQL queries.
• Prepare systems for deployment.
• Configure, monitor, administer, and troubleshoot commercial off-the-shelf information systems.
• Coordinate network and other computer-related work with other staff members.
• Develop project plans, time and cost estimates, implementation schedules, and project timelines.
• Participate in the design and implementation (with developers) of integrations between city information systems.
• Write, test, and maintain custom reports using standard business intelligence and report writing tools and methods.
• Conduct research; evaluate software, applications, tools, and hardware; and develop recommendations relating to software, hardware, applications, tools, and systems.
• Develop training materials and train users in the use of application software.
• Work closely with outside agencies in the support of hosted applications and systems.
• Complete scripting and minor customization assignments as necessary to support end-user needs of assigned systems.
• Troubleshoot and handle hardware and software issues, consulting on the most difficult and complex system or application problems.
• Participate in on-call rotation and be responsible for receiving after-hours calls.
• Perform other duties as assigned.
• Be available (especially during regular business hours or shifts) to communicate with peers, subordinates, supervisors, customers, vendors, and any other persons or organizations required to accomplish work and employer goals.
• Be punctual and timely in meeting all requirements of performance, including attendance standards and work deadlines; beginning and ending assignments on time; and scheduled work breaks, where applicable.

GENERAL QUALIFICATIONS:

Education & Special License(s)/Certifications:

• Bachelor's degree in computer science or a related field, or an equivalent combination of formal education and work experience.

REQUIRED Experience:

• Seven to ten years of experience in data warehouse modeling or BI data management.
• Five years of experience with SQL database queries.

Skills:

• Proficient in the configuration and administration of specifically assigned information systems or identical experience with different systems in the same domain.
• Extensive understanding of relational database management system (RDBMS) concepts and usage as well as proficiency in writing SQL. Experience with one or more of the following: Microsoft SQL Server, Oracle, or MySQL.
• Writes, tests, and maintains custom reports using standard business intelligence and report writing tools and methods. Proficient in one or more of the following: Crystal Reports (BI), SQL Server Reporting Services (SSRS).
• Proficient in leading business process/workflow mapping exercises.
• Proficient in leading requirements gathering and documentation for system configuration decisions.
• Computer hardware, network, and software skills.
• Strong analytical and research skills.
• Scripting skills.
• Problem-solving.
• Basic math concepts.
• Good oral and written communication skills and the ability to communicate and work effectively with managers, supervisors, vendors, and the various users supported by Information Technology.