Sr. Business Inteligence consultant

Summary:
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:

• Business Intelligence Expert:
  • Provide business intelligence leadership
  • Provide City of Atlanta KPI measurement support
  • Create data cubes and data marts 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 of data analysis experience
• 10+ years of Excel experience

Nice-to-Have Experience:

• Tableau
• Informatica
• Microsoft Power BI
• Microsoft Power Query
• Domo
• SSRS

Education and/or Experience:

• A minimum of 4 years of college or equivalent combination of education and experience is required.