Associate Data Engineer

insightsoftware

Data Engineer designing and maintaining scalable ETL pipelines and Power BI solutions at insightsoftware. Engaging with stakeholders and leveraging AI tools for improved performance.

Posted 5/30/2026full-timeRemote • 🇺🇸 United StatesJuniorMid-Level💰 $72,000 - $90,000 per yearWebsite

Tech Stack

Tools & technologies

Amazon RedshiftBigQueryCloudETLSQL

About the role

Key responsibilities & impact

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.
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).
Actively use AI tools (such as LLM assistants, copilots, and agentic workflows) to accelerate development and improve code quality.
Engage directly with business stakeholders to understand data needs in context.

Requirements

What you’ll need

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.

Benefits

Comp & perks

Health insurance
Retirement plans
Paid time off
Flexible work arrangements
Professional development opportunities
Bonus eligibility

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata modelingDAXETLELTquery optimizationcomplex joinswindow functionsPower BIcloud data warehouse

Soft Skills

communicationstakeholder engagementrequirements translation