AI Data Engineer 3

Aditi Consulting; Redmond (WA); On-site; USD 109,000 - 117,000; Full time

Job summary

Aditi Consulting is hiring a data analytics professional in the United States to analyze data, build Kusto/SQL queries, and create reports in Azure Data Explorer or Power BI. You will collaborate with Azure teams to ensure data quality and drive automation.

The role focuses on designing data models, transforming raw data, and delivering insights across multiple workstreams. A bachelor's degree and 5+ years of analytics or data engineering experience are preferred.

Qualifications

• Proficient in writing Kusto queries and tuning performance of existing queries.
• Experience developing data models to create reports in Azure Data Explorer or Power BI.
• Ability to analyze large datasets and communicate patterns for decision making.
• Proficient in developing Power Apps and Power Automate flows for data retrieval or automation.

Responsibilities

• Daily data analysis to identify gaps and curate data with Azure teams.
• Identify data sources and prepare queries for data extraction and reporting.
• Design data models and reports to surface insights across change management and workstreams.
• Collaborate with Azure teams to capture learnings from incidents and centralize them.
• Propose and implement process automations to improve efficiency.
• Track incidents and analyze causation related to deployments and services.
• Provide feedback for data improvements and follow-up in programs.
• Transform raw data into compatible formats for downstream systems and perform quality checks.

Skills

Kusto Query Language

Python

Azure Data Explorer

Power BI

Power Apps/Power Platform

Education

Bachelor's Degree in CS / Math / Software Engineering / Computer Engineering

Tools

Power Apps/Power Platform

Job description

This range is provided by Aditi Consulting. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$79.00/hr - $85.00/hr

Payrate: $79.00- $85.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.

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.

Pay Transparency:

The typical base pay for this role across the U.S. is: $79.00- $85.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.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

IT Services and IT Consulting