Business Intelligence Analyst #2309-371100-01

Charlotte’s local government, with more than 7,000 employees and a $2.39 billion budget, works hard to ensure that the community will be a winning city for everyone – a truly remarkable place to live, work, learn and play.

The Center for Digital Government named Charlotte one of the top five digital cities in the nation. The City of Charlotte's Innovation & Technology department (I&T) provides executive-level leadership, delivers technology services to city departments and partnership agencies, and coordinates information technology initiatives across the organization to support, enhance and advance citizen service delivery

The City of Charlotte’s Innovation & Technology Department is hiring for the position of Business Intelligence Analyst

This position is primarily responsible for leveraging/coordinating the use of shared data, reporting and business intelligence services to advance the City’s use of data and analytics, including: 

• Work collaboratively with customers and teammates to provide accessible data and business intelligence solutions that support decision-making, problem-solving, and resident engagement.
• Partner with departments to design/improve business processes related to solving complex business problems.
• Carryout the City's Data Governance Policy ensuring all data, reports, and applications are documented.
• Coordinate projects by organizing/prioritizing work, gathering requirements, and contributing to the completion of the work.
• Design and deliver end-user training and provide regular technical assistance to customers.
• Provide excellent customer service and enthusiasm while partnering with departments to share, access, and publish data/reports that impact the entire organization.
• Engage in various citywide data and technology teams to troubleshoot issues, deliver projects, and promote the innovative use of data across the city.

• Broad knowledge of data/spatial data analysis related to creating business solutions.
• Demonstrated ability to coordinate projects and the division of labor while working projects that reach across multiple teams and divisions. 
• Ability to understand complex business needs, create technical/business requirements, to customize solutions to meet customer needs 
• Technical skills and knowledge of best practices to develop data visualizations with tools such as: SQL Server Reporting Services, GIS Applications, Tableau, and/or PowerBI.  
• Ability to effectively train others, complete documentation, and present on projects and solutions as needed.
• Proficiency in SQL is a plus.
• Fundamental understanding of automation/scripting processes is a plus. 
• Knowledge of Python, SSIS, Dell Boomi, and other ETL technologies is a plus

The City’s Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes, but is not limited to: reference checks, social security verification, education verification, criminal conviction record check, and, if applicable, a credit history check, sex offender registry and motor vehicle records check.

Background checks must be in compliance with all federal and state statutes, such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidate’s written authorization before obtaining a criminal background report, motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports.

Final candidates must pass a pre-employment drug-screening test and physical examination. During the selection process, candidates may be asked to take a skills test, and/or participate in other assessments.

Apply online.

Federal law requires employers to provide reasonable accommodations to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job.

Anyone seeking an accommodation to apply for a job may call (704) 336-2285 for assistance or you may email questions to CityHrJobPostingsNotify@ci.charlotte.nc.us.

The City of Charlotte provides a comprehensive benefits package to all employees. Click here to learn more about the City of Charlotte’s benefits.

The City of Charlotte is a drug and alcohol-free workplace.