Business Intelligence Technical Consultant (BI Developer) with Big Squid



Posted Under: Atlanta, Georgia jobs in IT / Software / Systems; IT / Software / Systems jobs in zipcode 30301
Posted On: 2017-09-25 00:00:00

The position listed below is not with Georgia Interviews but with Big Squid

Georgia Interviews is a private organization that works in collaboration with government agencies to promote emerging careers. Our goal is to connect you with supportive resources to supplement your skills in order to attain your dream career.

Job Description
BUSINESS INTELLIGENCE ARCHITECT JOB DESCRIPTION

Working as a member of Big Squid consulting team, the BI Architect will be focused on the deployment of fault tolerant, highly scalable BI solutions. The successful candidate will have a minimum of 2 years working hands on with data. This individual will join an enthusiastic, fast-paced and dynamic team working directly with customers on Business Intelligence and Predictive Analytics solutions. A successful candidate will have demonstrated sustained exceptional performance, innovation, creativity, insight, and good judgment.

Key Responsibilities:

* Works with customers, end-users, technical analyst, and application designers to define the data requirements and structure for Business Intelligence (BI) applications
* Designs models for the data warehouse or data mart (data structure, storage, and integration)
* Works with our team to aggregate large data sets for use within BI solutions
* Develops, designs, and optimizes complex SQL queries
* Leads the database analysis, design, and build effort
* Designs maps of source system data to data warehouse models

Required Qualifications:

* 3+ years experience supporting business intelligence systems in a BI, ETL Developer or Report Developer role
* Proficiency in developing complex SQL queries
* Expertise with at least one of the following database technologies and familiarity with the others: relational, columnar and NoSQL (i.e. MySQL, Oracle, MSSQL, Vertica, mongodb, Redshift, Snowflake, Google Big Query)
* Understanding of data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3rd normal form as well as dimensional modeling, such as star and snowflake)
* Experience dealing with large data sets
* Advanced Excel skills, including pivot tables and VBA (Visual Basic for Applications)
* Goal oriented with strong attention to detail
* Proven experience in effectively partnering with business teams to deliver their goals and outcomes
* Bachelors Degree in in Information Systems, Statistics, Computer Science or related field preferred OR equivalent professional experience

* Nice to Have

* Experience with Hadoop, Hive
* Experience with Amazon RedShift
* Experience with Snowflake
* Experience with Google Big Query

Company DescriptionOur vision is simple. Big Squid is bringing the power of sophisticated predictive analytics--yeah, real math and stats--to the executive and business user. Our software enables the data scientist to scale by empowering business users to not only participate in conversations, but drive conversations related to data sciences. Its pretty awesome.
Associated topics: business, business analysis, business analyst, business systems analyst, crm, market, marketing, sales, sap, senior consultant