Seasoned Data Analyst (Power BI)
Minneapolis, MN (onsite)
Duration: 6 months + extendable

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