Position: Azure Data Analyst
Location: Bellevue, WA (Hybrid)
Duration: Longterm Contract
Interview process: Final round will be In-person
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
