DATA WAREHOUSE DEVELOPER/ANALYST

KG Tiger; Natick (MA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading software development company in Natick, MA, is seeking a Data Warehouse Developer-Analyst to handle User Experience data and contribute to product features. Candidates should have a Bachelor's degree in Engineering and 3+ years of experience, with strong skills in ETL development and SQL. Responsibilities include profiling source data, gathering reporting requirements, and troubleshooting ETL processes. Interested applicants can send their resume to sean.s at kggroup.com.

Qualifications

• Three years of professional work experience in a relevant role.
• Familiarity with business intelligence tools and big-data technologies.
• Ability to work in a flexible environment.

Responsibilities

• Profile and analyze large amounts of source data.
• Gather reporting requirements and translate them into data models.
• Design and develop ETL code for data transformation.
• Conduct ETL performance tuning and troubleshooting.
• Support end users interacting with the data.

Skills

Excellent verbal and written communication

Fast-paced learning ability

Expert SQL coding skills

Expert-level ETL development

Data warehouse expertise

Education

Bachelor's degree in Engineering

Master's degree in Engineering

Tools

Informatica PowerCenter

SAP Data Services

SQL Server

MySQL

Business Objects

Microsoft SSRS

Oracle OBIEE

Hadoop

Python

MATLAB

Job description

It is an $800 million Company and the leading developer of mathematical computing software. They have over 3000 employees in the world. They has over 90 products well known in the market and these are primarily used in various industries like automotive, aerospace and defense, biotech, semiconductor, etc. It is a US based company headquartered in Natick, MA. In India they have branches in Bangalore, Delhi and Pune.

ABOUT KGiSL:

KGiSL Group of Companies is a part of KG group, which is a 500 million USD premier industrial group in South India, with 70+ years of multi-vertical focus on textile, engineering, healthcare, finance, IT & ITES services, infrastructure and education. It is a CMM Level-4 company.

Job Description

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

• 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.

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.
8. Exposure to dealing with unstructured or semi-structured data.
9. Exposure to dealing with the challenges of large relational data sets, including load performance, query performance, archiving, etc.
10. Experience with big-data technologies such as Hadoop/Hive, MongoDb, or other NoSQL-based data stores.
11. 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).