Associate Data Engineer

insightsoftware, LLC; Texas; Hybrid; USD 72,000 - 90,000; Full time

Benefits offered by this job

Bonus eligibility for non-sales roles

Job summary

insightsoftware, LLC is seeking a Data Engineer to design and maintain scalable data pipelines and build PowerBI solutions that drive business decisions. The ideal candidate will have strong SQL skills, experience with cloud data warehouses, and proficiency in AI tooling to optimize workflows.

With a salary range of $72,000 to $90,000, this position is ideal for those with 3+ years of relevant experience in data engineering or analytics.

Qualifications

• 3+ years of hands-on data engineering or analytics engineering experience.
• Strong SQL skills including complex joins and query optimization.
• Demonstrated PowerBI proficiency with report development.

Responsibilities

• Design and maintain ELT/ETL pipelines for data movement.
• Monitor pipeline health and implement proactive alerting.
• Develop and maintain PowerBI dashboards for stakeholders.

Skills

SQL

PowerBI

Data Engineering

AI Tools

Communication

Tools

Snowflake

Fivetran

dbt

Job description

About the Role

Insightsoftware is looking for a data professional who brings strong technical fundamentals, a genuine curiosity for AI, and the ability to translate business needs into data solutions. As a Data Engineer on the Enterprise Data team, you will design and maintain scalable data pipelines, build PowerBI solutions that drive decisions, and champion AI-assisted workflows that make the team faster and smarter.

What You Will Do

• 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 PowerBI dashboards and reports that give business stakeholders clear, trusted views of company performance.
• Apply best practices in data modeling within PowerBI (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 (such as LLM assistants, copilots, and agentic workflows) 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 using them in production.
• Engage directly with business stakeholders to understand data needs in context, asking smart questions and pushing back constructively when requirements are unclear.
• Communicate technical concepts and data limitations in plain language, building trust with non‑technical partners.
• Contribute to data governance practices, including metadata documentation, lineage tracking, and data quality standards.

What You Bring

• 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 PowerBI 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.
• Preferred experience with ELT/ETL orchestration tools such as Fivetran, dbt, or similar.
• Familiarity with Salesforce data structures or CRM‑adjacent reporting.
• Exposure to agentic AI workflows, prompt engineering, or LLM‑powered automation.
• Background in financial or ARR/revenue data domains.
• Experience with role‑based access control and data security practices in cloud platforms.

Salary

The salary range in United States of America for this position is $72,000.00 to $90,000.00 USD annually. For non‑sales roles, you may be eligible for a bonus. For sales roles, this range includes a commission target. We are committed to pay transparency and fair compensation practices.

Equal Employment Opportunity

All your information will be kept confidential according to EEO guidelines. We are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are a proud equal‑opportunity workplace.