Job Description:
Responsible for collecting, analyzing and displaying data so that City of Atlanta groups and teams can use data to achieve city goals. Also responsible for evaluating data to identify system gaps, process inefficiencies, and company risks.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following and other duties as assigned:
- Business Intelligence Expert
- Provide business intelligence leadership
- Provide City of Atlanta KPI measurement support
- Create data cubes and data mart to support Executive leaders’ information needs
- Data Architecture
- Lead the strategic data analysis direction at the City of Atlanta
- Groom and remediate data gaps
- Lead charge to implement Master Data Modeling in the Data Warehouse and operating source systems
- Data Governance Leadership
- Analyze report requests
- Chair Data Stewardship Committee
SKILLS AND EXPERIENCE
Required Experience:
- 5+ years of overall development experience
- 5+ years of ETL development experience
- 5+ years of SQL development experience
- 5+ years of Data warehouse development and maintenance experience
- 5+ years if data analysis experience
- 10+ years Excel
Nice-to-Have Experience:
- Tableau
- Informatica
- Microsoft Power BI
- Microsoft Power Query
- Domo
- SSRS
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION and/or EXPERIENCE
A minimum of 4 years of college or equivalent combination of education and experience is required.
OTHER SKILLS, ABILITIES, QUALIFICATIONS
A strong proficiency in CRM, Microsoft Word, and Excel a must. Must be able to manage multiple projects simultaneously along with strong organizational skills, and attention to detail. Use of simple copiers and office machines necessary. Typing skills required at no less than 55 words per minute.
Job Types: Full-time, Contract
Pay: $50.00 - $65.00 per hour
Expected hours: 40 per week
Schedule:
Application Question(s):
- Please share your email address and prefer time to reach you
Experience:
- SQL: 5 years (Required)
- ETL: 5 years (Required)
- Microsoft Excel: 10 years (Required)
- Data analysis: 5 years (Required)
Work Location: In person