DATA WAREHOUSE DEVELOPER/ANALYST

The Data Warehouse Developer-Analyst will be supporting a new area of analysis involving User Experience data with our products. Through the new Marts supporting analysis of this data, the incumbent would be responsible for making important contributions to the company’s product features and refinement. This role performs the complete Mart lifecycle, including data profiling, design and development, debugging/testing, and support and enhancements, and will work closely with our Product Development team and with the rest of the Data Warehouse team within the company’s IT 

Responsibilities:     

 He or She will:

• Profile and understand the large amounts of source data available, including structured and semi-structured/web activity data

• Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data

• Gather reporting and analysis requirements and translate into reporting structures data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts

• Use data mining techniques to analyze the source data and determine the best reporting structures to build

• Map sources to the target design using a variety of tools, including Business Objects Data Services/BODI. Design and develop ETL code to load and transform the source data from various formats (including key-value pair and variable-structure data) into a SQL database.

• Conduct ETL performance tuning, troubleshooting, support, and capacity estimation

• Conduct thorough testing of ETL code changes to ensure quality of data produced

• Provide day-to-day support and mentoring to end users who are interacting with the data

Qualifications

 The incumbent should possess excellent verbal and written communication along with the ability to work in a fast-paced, flexible environment, and take the initiative to learn new tools quickly

 Must Have:

1. Bachelor's degree in Engineering with three (3) years of professional work experience, or a Master's degree in Engineering 

2. Expertise with data warehouse

3. Expert-level ETL development using tools such as Informatica PowerCenter or SAP Data Services

4. Expert-level SQL coding/querying skills in SQL Server and/or MySQL

5. Experience with Business Intelligence tools such as Crystal, Business Objects, Microsoft SSRS, or Oracle OBIEE

6. Exposure to Amazon RDS and RedShift, and/or Google BigQuery

7. Experience with relational database design/modeling using tools such as ERstudio or ERwin 

 **Desired**

1. Exposure to dealing with unstructured or semi-structured data

2. Exposure to dealing with the challenges of large relational data sets, including load performance, query performance, archiving, etc.

3. Experience with big-data technologies such as Hadoop/Hive, MongoDb, or other NoSQL-based data stores

4. Exposure to one or more of these tools: MATLAB, Python, SAS, SPSS

Additional Information

Interested candidates may submit resume to sean.s at kggroup.com (or) Call 888-738-5815 (x1375)