BI Data Architect/Engineer in Dunwoody, GA at HUNTER Technical Resources

Date Posted: 7/29/2020

Job Snapshot

  • Employee Type:
  • Location:
    Dunwoody, GA
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
  • Job ID:

Job Description

BI Data Architect/Engineer

Atlanta, GA


The BI Data Architect/Engineer will work closely with subject matter experts and business stakeholders to identify, design, and develop data-driven reporting solutions for our Data Warehouse and BI Architecture. Qualified candidates will have demonstrated experience to take concepts from whiteboard to dimensional data and reporting schemas for BI reporting and analytics across sales, finance, and distribution operations.

Role Specifics:
  • Work with multiple, cross-functional teams to understand data and reporting needs. Translate business problems & requirements into data and reporting models
  • Work closely with our data engineers to review designs, manage metadata, and drive data quality, standard calculations, and balancing controls.
  • Apply best practices for data extraction and loading processes to ensure data quality and integrity and instill trust for uses of our enterprise data warehouse
  • Hands on development of logical and physical dimensional data models leveraging Kimball design principles. Experience with building Cloud MPP / columnar reporting models (eg. Azure SQL DW)
  • Must have prior experience in building row level security into data and reporting designs to support internal and external customer access
  • Excellent written and oral communications
  • Familiarity with data visualization and development of reporting schemas to drive reporting and analytics tools (e.g. Tableau or PowerBI)

  • Bachelor’ s Degree in Computer Science, Engineering or equivalent work experience
  • 5+ years of experience in Data warehousing & BI technologies
  • 2+ years of experience as a Data Architect developing dimensional modeling for 10+ TB data warehouse
  • 3+ years of experience as an ETL Data Engineer
  • Strong SQL background with ability to write and/or review complex Microsoft T-SQL, data extracts, and data cleansing processes
  • Prior experience with Microsoft SSIS to review, edit and build new extracts as needed
  • Knowledge /experience with migrating data warehouse from on-prem to cloud is highly beneficial