Duluth, GA, 30155
icrunchdata Network
Reporting to the Manager of BI you’ll be working with the BI team in building and supporting prescriptive and predictive reporting needs for AGS. AGS currently have custom portal built on C#, MVC platform and Power BI service for its reporting needs. Current system includes MSSQL warehouse with SSAS Tabular and Cloudera DataLake. While our reporting audience is growing in volume and expectations we like to bring in new candidates with innovative knowledge and ideas for designing and building reports for prescriptive, predictive and reactive analysis. Thorough knowledge of Data Warehousing, ETL tools, SQL Server database, SSAS Tabular and experience in C# is a must. This position requires excellent rapid problem solving and analytical skills. You will be in a team using agile software development life cycle and DevOps methodology working closely with other groups including Systems, product management, accounting other gaming teams. Responsibilities Design, develop, enhance and maintain SSAS Tabular warehouse marts and cubes Design, develop and enhance new and existing SSIS ETLs Implement monitoring and alert system for warehouse components Implement dashboards for data exceptions and anomalies Implement and enhance marts for the growing business needs. Collaborate with Hadoop big data DataLake. Identify and recommend performance enhancements and implement best practices. Research and suggest new tools and process. Perform code reviews and performance profiling. Work with AGS Development and product management and marketing groups to deliver best possible solution from start to end in Dev cycle. Bachelor’s degree in Computer Science, or similar 7 Work experience in data warehousing with multiple years with SSAS Tabular DB. Multiple years of experience ETL tools including SSIS is a must have. Experience in DAX query language or other formula languages. Multiple years of work experience and strong skills in SQL Server. Rapid development analytical skills and experience managing huge volume of data Gaming or any high traffic transactional industry experience preferred Fluency in coding and systems design and a desire to tackle the complex problems Note: All offers are contingent upon successful completion of a background check •Posted positions are not open to third party recruiters and unsolicited resume submissions will be considered free referrals. AGS is an equal opportunity employer. [...]