Daily data analysis to find the gaps and curate the information in the systems working with teams in Azure to ensure data hygiene is maintained in source systems.
Identify data sources and prepare queries using query languages (Kusto, SQL etc.) for data extraction and prepare reports in Azure Data Explorer or Power BI
Design process, data models, reports to surface insights related to all aspects of change management and various workstreams.
Work with services and various Azure Teams to capture the learnings from incidents and store them at centralized location or model for consistent retrieval.
Propose, plan and expedite "identified" process automations to improve efficiency.
Track and Analyze incidents on day-to-day basis for services for causation and if in scope to understand any association with deployments reviewed/not reviewed and provide the updates to the team.
Provide feedback for any recommended data improvements by services or respective follow-up into the program workstreams.
Plans and creates efficient techniques and operations (e.g., inserting, aggregating, joining) to transform raw data into a form that is compatible with downstream data sources, databases, and formats. Independently uses software, query languages, and computing tools to transform raw data across end-to-end pipelines. Evaluates data to ensure data quality and completeness using queries, data wrangling, and statistical techniques. Merges data into distributed systems, products, or tools for further processing.
Requirements:
Proficient in writing Kusto queries, tuning and improving the performance of existing queries with knowledge of data concepts related to structured and non-structured databases.
Proficient in developing data models (database/tables) to create the reports in Azure Data Explorer or Power BI or relevant BI tool to deliver insightful reports and data.
Proficient to use analytics, which consists of the discovery, interpretation, and communication of meaningful patterns in data (complex and large datasets). This includes applying data patterns towards effective decision making.
Ability to identify rules, principles, trends, patterns and/or relationships that explain facts, data, or other information; and to analyze information, make correct inferences, and draw accurate conclusions.
Proficient in developing Power Apps, Power Automate flows, Lens jobs for data retrieval or storage or other required automations.
Ability to communicate effectively with various Azure teams to closely work on troubleshooting, data analysis and/or reporting.
Required/Preferred Qualifications:
Bachelor's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 5+ years experience in business analytics, data science, software development, data modeling or data engineering work OR Master's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 3+ years of business analytics, data science, software development, data modeling or data engineering work experience OR equivalent experience.