Data Engineer - AI-Driven ELT & Power BI

Carbon Data Solutions; United States; Remote; USD 72,000 - 90,000; Full time

Job summary

insightsoftware is seeking a Data Engineer on the Enterprise Data team to design and maintain scalable data pipelines, build Power BI solutions, and champion AI-assisted workflows that accelerate decisions. You will work at the intersection of engineering precision and business partnership.

The role emphasizes ELT/ETL design, BI reporting, and close collaboration with business partners to translate requirements into analytical deliverables.

Qualifications

• 3+ years of hands-on data engineering or analytics engineering experience in a professional setting.
• Strong SQL skills: complex joins, window functions, query optimization, and data modeling.
• Demonstrated Power BI proficiency, including report development, data modeling, and DAX.
• Experience working with cloud data warehouse platforms (Snowflake, BigQuery, Redshift, or similar).
• Proven, active use of AI tools in daily data work, not just awareness.
• Ability to engage with business stakeholders and translate requirements into data solutions.
• Strong written and verbal communication skills.

Responsibilities

• Design, build, and maintain ELT/ETL pipelines that move data reliably from source systems into a cloud data warehouse environment.
• Write clean, performant, and well-documented SQL to transform raw data into analyst-ready models and reporting layers.
• Partner with the team to define and enforce data modeling standards, naming conventions, and documentation practices.
• Monitor pipeline health, troubleshoot failures, and implement proactive alerting to protect data availability.
• Develop and maintain Power BI dashboards and reports that give business stakeholders clear, trusted views of company performance.
• Apply best practices in data modeling within Power BI (star schemas, DAX measures, performance optimization) to ensure reports are fast and maintainable.
• Work closely with business partners to understand reporting requirements, translating ambiguous asks into structured analytical deliverables.
• Champion self-serve analytics by building reusable semantic layers that reduce ad hoc request volume.
• Actively use AI tools to accelerate development, improve code quality, and generate documentation.
• Identify opportunities to apply AI and automation to repetitive data tasks, from data quality checks to pipeline scaffolding.
• Stay current on emerging AI/data tooling and share practical learnings with the team.
• Apply a critical, evidence-based lens to AI outputs, validating results before production.

Skills

SQL

Power BI

Cloud data warehouse

AI tools

Stakeholder engagement

Communication

Tools

Fivetran

dbt

Job description

insightsoftware is seeking a Data Engineer on the Enterprise Data team to design and maintain scalable data pipelines, build Power BI solutions, and champion AI-assisted workflows that accelerate decisions. You will work at the intersection of engineering precision and business partnership.

The role emphasizes ELT/ETL design, BI reporting, and close collaboration with business partners to translate requirements into analytical deliverables.