Cloud Data Engineer II (Power BI)

About AAIS
Since 1936, American Association of Insurance Services (“AAIS”) has served the property and casualty insurance industry as the only national not-for-profit advisory organization governed by its member companies. We are committed to evolving with changes in the insurance industry, adding value to our members, regulators, and the industry with responsive products and insights.

Purpose
The Cloud Data Engineer II independently designs, builds, and supports AAIS's cloud-based data platform. This role owns complete features and work packages within the data engineering environment while contributing across related capabilities. The primary focus is on delivering high-quality dashboards, visualizations, reports, and datasets that support business and technology stakeholders.
The ideal candidate combines hands-on technical proficiency with dependable delivery. They work effectively across functions, apply engineering standards independently, identify risks early, and help improve how the team builds, delivers, and supports solutions.

Responsibilities
Solution Delivery

- Independently deliver data features, integrations, pipelines, dashboards, reports, and datasets from design through production support.

- Translate business and technical requirements into practical designs, implementation tasks, test plans, and support documentation.

- Estimate work, manage dependencies, communicate progress, and deliver within sprint and release commitments.
Quality, Security & Operations

- Apply coding, architecture, security, data protection, change management, and operational standards.

- Build automated tests, monitoring, alerting, deployment controls, and support procedures appropriate to the solution.

- Investigate incidents and defects, identify root causes, and implement corrective actions to reduce recurring issues.
Engineering Collaboration & Delivery

- Coordinate with engineers, business partners, vendors, and platform owners to deliver data solutions and reporting capabilities.

- Participate in design reviews and peer code reviews, providing constructive technical feedback.

- Contribute to Agile sprint planning, estimation, and technical documentation, with code maintained in GitHub and work tracked in Azure DevOps.

- Develop and maintain dashboards, visualizations, reports, and datasets that support business and technology stakeholders.

- Contribute reusable patterns, best practices, and continuous improvements to engineering and delivery processes.

- Perform additional duties as assigned or requested.

Knowledge, Skills, and Abilities

- Demonstrated experience delivering data and analytics solutions as a Data Engineer in a cloud-native environment, with Python as a primary development language.

- Recent hands-on experience developing with AWS-native capabilities, MongoDB Atlas, Databricks, and Power BI.

- Strong information delivery skills leveraging Power BI and MongoDB Atlas to develop dashboards, visualizations, reports, and datasets that support business and technology stakeholders.

- Familiarity with API integration, CI/CD pipelines, observability, data pipelines, automation, and cloud security.

- Ability to operate independently while collaborating effectively across technical and business teams.

- Strong written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences.

- Strong critical-thinking and problem-solving skills, with the ability to manage multiple priorities and meet deadlines.

- Must demonstrate a high degree of integrity, ethics, discretion, and dedication to the mission of the organization.

- Ability to work effectively both independently and in a team environment.

- Ability to communicate effectively across multiple channels and asynchronously in a remote-first working environment.

Requirements
- Bachelor's degree in Computer Science, Information Systems, Engineering, Data Management, Cybersecurity, or a related discipline, or equivalent practical experience.

- 3+ years of engineering experience delivering production technology solutions.

- Demonstrated experience independently delivering complete features or work packages.

- Experience in property and casualty insurance or other regulated industries is a plus.

- The successful candidate will be required to complete an in-person leadership interview.

- Minimum travel is required for annual all-company gatherings or team design sessions (up to 5% of the time)

Minimum starting base of $80,000, with upward flexibility based on skills and experience + 10% annual bonus.

Salary Description
Min $80k base; see full pay details in job post.