Title : Seasoned Data Analyst(Power BI)

Location : Minneapolis , MN (Only Local to Minneapolis)

Client : Medtronic , MN

Job Duties:

Functional skills

• Subject Matter Expert on master data management, analysis and quality.
• Runs standard and ad-hoc data profiling for domain, facilitating data clean-up, readiness.
• Roots down quality issues in the data domain.
• Proactive analysis of data regarding quality issues (data profiling, deduplication, etc.)
• Develops and provides KPIs for quality issues using data visualization solutions.
• Consults local data stewards regarding data quality of core data and facilitates improvements to data.
• Leverage analytical skills to spot data patterns and trace data quality issues back to root cause.
• Influence and collaborate with other departments like developers and supplier coordinating team, and the ability to understand how those groups operate and use master data.
• Work independently and partner with end-users and business partners to assess and document data quality requirements.

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