Azure Data Analyst

Position: Azure Data Analyst Location: Bellevue, WA (Hybrid) Duration: Longterm Contract About Smart IT Frame: At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together. Job description • Individual with strong technical background in SQL Server BI Data Analysis and strong knowledge of Data Warehousing Concepts • Collect clean and organize data from multiple sources • Mining data from primary and secondary sources then reorganizing said data in a format that can be easily read by either human or machine • Using statistical tools to interpret data sets paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts • Demonstrating the significance of their work in the context of local national and global trends that impact both their organization and industry • Preparing reports for executive leadership that effectively communicate trends patterns and predictions using relevant data • Collaborating with programmers engineers and organizational leaders to identify opportunities for process improvements recommend system modifications and develop policies for data governance • Creating appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary • Proven experience in SQL Server writing complex TSQL queries Performance tuning • Proven experience in Data Analysis dealing with large volume of datasets • Proven experience in Design Implementation of end-to-end data pipelines • Coding skills in languages such as SQL Python Andor R • Analytical and problem-solving skills • Experience with statistical software eg Stata SPSS • Knowledge of data gathering cleaning and transforming techniques • Reporting and data visualization skills using software like Tableau • Understanding of data warehousing and ETL techniques • Proficiency in Microsoft Excel • Ability to set and meet deadlines • Ability to work in high pressure situations • Experience with statistical software • Technical writing skills • Excellent attention to detail • Strong written verbal communication skills • Ability to QA and troubleshoot data • ETL tools like SSIS • b Reporting tools like Power BI • c Analytical tools like SSAS Tabular and multidimensional Cubes and MDX queries • Cosmos and scope scripts • Good to have knowledge of Microsoft Big Data Technologies • Good to have knowledge of Azure Data Factory and C • Excellent communication skills direct communication with Client Apply today or share profiles at priya@smartitframe.com