Logo
First Mile Consulting Private Limited

Data Analyst/Power BI Developer

First Mile Consulting Private Limited, Saint Paul, Minnesota, United States, 55130


Sr. Data Analyst(Power BI) Do you have the right skills and experience for this role Read on to find out, and make your application. Location : Minneapolis , MN (Only Local to Minneapolis) 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 Job Type: Contract Pay: $55.00 - $60.00 per hour Expected hours: 40 per week Benefits: 401(k) Dental insurance Flexible schedule Health insurance Life insurance Paid time off Vision insurance Schedule: 8 hour shift Day shift Monday to Friday Education: Bachelor's (Required) Ability to Commute: Minneapolis, MN (Required) Ability to Relocate: Minneapolis, MN: Relocate before starting work (Required) Work Location: In person