Data Analyst

Skills

Works independently and/or with the Database Administrator to create system design documentation related to existing or new database ETL or reporting and / or dashboards Partners/collaborates with internal/external customers on solution development analysis of options and scheduling meetings/demonstrations with vendors and customers Ability to gather data critically evaluate information from multiple sources decompose high-level information into detailed process flow/requirements analyze findings and develop recommendations Prepares technical documentation and prepares reports graphs charts process maps presentations and other illustrative materials Utilizes Microsoft Power BI to build and maintain tabulated reports dashboards and datasets for city departments Assists with purchase of software and professional services including RFPs and RFQs

Description

We are looking for a motivated Data Analyst who will work closely with our Database Architect on assigned projects and tasks. The Data Analyst position is responsible for performing extract, transform and load (ETL) data integration tasks, report generation, data cleansing, query writing, and the creation of data displays (dashboards, charts, graphs) in support of Technology Services and City operations. The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. Strong interpersonal/human relation and presentation skills are a must. If you can check the boxes below for skills and experience, this job could be a perfect match for you!

Responsibilities

• Ability to work independently with limited direction relying on his/her own judgement, requesting supervisory assistance when necessary, and seeking performance feedback periodically
• Has experience designing, building, and deploying Microsoft Power BI dashboards and tabulated reports
• Has experience writing T-SQL statements in a Microsoft SQL environment, and extensive experience using Microsoft Office and M365 suite of products
• Extensive experience using Microsoft Office and M365 suite of products
• Has a customer focused attitude, problem solving abilities, and works with a sense of urgency/enthusiasm.
• Possesses excellent public speaking and presentation skills
• Exhibits strong interpersonal/human relation skills and the ability to support controversial positions or negotiate sensitive issues with customers, residents, and co-workers