Senior Data Analyst

Job Description

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

• Experience in writing optimized MSSQL, Snowflake 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 of ‘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 experience with 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.

• Minimum of 4 years of relevant experience in Data Analysis and Data Mapping.
• Proficiency in writing SQL queries.
• Proficiency in understanding the relationships with the tables.
• Excellent interpersonal skills with at least 2 years of experience in client communication and collaboration with stakeholders and cross-functional teams.