Technical skills:

• Experience in writing optimized MSSQL, Snowflakes queries.
• Able to connect with different data sources or raw text files and preparing complex queries with multiple databases.
• Able to work with large chemical and components datasets and skilled in mapping data from diverse source CMAP locations to SSMS.
• Import data to SQL Server Management Studio (SSMS) for further analysis and manipulation. Also, should create test databases and reference tables for lookups.
• Strong knowledge in writing SQL queries and python
• Strong understanding on 'SPSS Modeler' ETL tool and snowflake data warehouse.
• Designing and implementing data models within Snowflake, including defining tables, relationships, and schemas.
• Able to Transform complex datasets into valuable insights through deep data analysis and data transformations.
• Able to utilize excel functions and power queries to handle and manipulate data effectively.
• Should have hands-on MS Power Bi tools to visualize complex data and create interactive charts and dashboards.
• Collaborate with cross functional teams to implement scalable and efficient data solutions.

Must Have:

• Minimum of 4 years of relevant experience in Data Analysis and Data Mapping
• Should be proficient in writing SQL queries.
• Should be proficient in understanding the relationships with the tables.
• Excellent interpersonal skill with At least 2 years of experience in client communication and collaboration with stakeholders and cross functional teams

Pi-square technologies is a Michigan (USA) Headquartered Automotive Embedded Engineering Services company, Synergy Partner for major OEMs and Tier 1s and their implementation partners in Automotive Embedded Product Development, Projects, Requirements Analysis, Software Design, Software Implementation, Efficient Build, Release Process, and turnkey software V & V Services. We have more than 20+ years of industry expertise with specialization in the latest cutting-edge automotive technologies such as Infotainment, connected vehicles, Cyber security, OTA, and Advanced Safety/ Body electronics.