kgtiger2 logokgtiger2 logo

Data Warehouse Developer/Analyst

kgtiger2Natick
On-site Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Experience Level

Mid to Senior

Qualifications

The ideal candidate should have exceptional verbal and written communication skills, thrive in a fast-paced and adaptable environment, and possess the initiative to quickly learn new tools. Must Have:Bachelor's degree in Engineering with at least three (3) years of relevant experience, or a Master’s degree in Engineering. In-depth expertise in data warehousing. Expert-level proficiency in ETL development using tools such as Informatica PowerCenter or SAP Data Services. Advanced SQL coding/querying skills in SQL Server and/or MySQL. Experience with Business Intelligence tools including Crystal Reports, Business Objects, Microsoft SSRS, or Oracle OBIEE. Familiarity with Amazon RDS and RedShift, and/or Google BigQuery. Experience in relational database design/modeling with tools like ERstudio or ERwin. Desired:Experience handling unstructured or semi-structured data. Knowledge of data privacy regulations and data governance is a plus.

About the job

The Data Warehouse Developer/Analyst will play a crucial role in enhancing our User Experience data analysis. By developing new Marts that support this analysis, the successful candidate will significantly influence our product features and improvements. This position encompasses the entire Mart lifecycle, including data profiling, design, development, debugging/testing, and ongoing support. Collaboration with the Product Development team and the Data Warehouse team within our IT department will be key.


Responsibilities:

The incumbent will:

  • Profile and comprehend extensive source data, including structured and semi-structured/web activity data.
  • Collaborate with data originators to address data collection gaps and refine source-system data structures for improved analysis and integration.
  • Collect reporting and analysis requirements and translate them into data models for reporting structures, including aggregate tables, pivoted tables, and relational/dimensional (star-schema) marts.
  • Employ data mining techniques for source data analysis to determine optimal reporting structures.
  • Map sources to target designs using tools like Business Objects Data Services/BODI, and create ETL code to load and transform source data from various formats into a SQL database.
  • Conduct performance tuning and troubleshooting for ETL processes, along with capacity estimation.
  • Thoroughly test ETL code changes to ensure high-quality data output.
  • Provide daily support and mentorship to end users engaging with the data.

About kgtiger2

About Us:We are a prominent $800 million company specializing in mathematical computing software, with over 3,000 employees worldwide. Our portfolio includes more than 90 well-recognized products utilized across various sectors such as automotive, aerospace, defense, biotech, and semiconductor industries. Headquartered in Natick, MA, we also have branches in Bangalore, Delhi, and Pune, India. About KGiSL:KGiSL Group of Companies is part of the KG Group, a $500 million premier industrial group in South India, with over 70 years of diversified focus in textile, engineering, healthcare, finance, IT & ITES services, infrastructure, and education. We are a CMM Level-4 company.

Similar jobs

Browse all companies, explore by city & role, or SEO search pages.

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.