Cloud Data Engineer II; Power BI

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.

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.

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.

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

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

• 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 Git Hub and work tracked in Azure Dev Ops.
• 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.

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