Data Analyst

Job Description: We are looking for a motivated Data Analyst who will work closely with our Database Architect and System Analyst 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 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!

Essential Functions:
• Works independently and/or with the Database Administrator and System Analyst 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

Skills:
• 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
• 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
• Ability to work independently with limited direction relying on his/her own judgement, requesting supervisory assistance when necessary, and seeking performance feedback periodically

Preferences:
• Experience with Safe Software’s FME or other ETL products

Minimum Qualifications:
• Bachelor's degree in Computer Science, CIS, MIS, or similar field of study and 2-5 years of experience working as a Business or Data Analyst in a Microsoft SQL database environment and Microsoft Power BI dashboards and reports
OR
• 5-10 years working in a Microsoft SQL database environment in combination of related education, experience, certifications, and licenses that will result in a candidate successfully performing the essential functions of the job