AI Data Engineer 2

Payrate: $70.00- $75.00 /hr

Top 3 Hard Skills Required + Years of Experience:

• Minimum 2 year experience with Kusto Query Language
• Minimum 2 year experience with Python
• Minimum 2 year experience with Azure Data Explorer
• Minimum 2 year experience with Power BI
• Minimum 2 year experience with Power Apps/Power Platform

Responsibilities:

• 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.

Pay Transparency:
The typical base pay for this role across the U.S. is: $70.00- $75.00/hr. Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education and experience and the benefits package you select. Full-time employees are eligible to select from different benefits packages. Packages may include medical, dental, and vision benefits, 10 paid days off, 401(k) plan participation, commuter benefits and life and disability insurance.

For information about our collection, use, and disclosure of applicant's personal information as well as applicants' rights over their personal information, please see our Privacy Policy (https://www.aditiconsulting.com/privacy-policy).

Aditi Consulting LLC uses AI technology to engage candidates during the sourcing process. AI technology is used to gather data only and does not replace human-based decision making in employment decisions. By applying to this position, you agree to Aditi's use of AI technology including calls from an AI Voice Recruiter.

#AditiConsulting