Associate Data Engineer

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

About Us:

insightsoftware is a global provider of reporting, analytics, and performance management solutions that unlock the potential of business data and transform the way finance and data teams operate. We empower leaders from over 32,000 organizations to make timely and intelligent decisions. Our comprehensive solutions span Financial Planning and Analysis (FP&A), Controllership, and Data and Analytics. We deliver finance teams the insights required to navigate any economic climate and drive greater financial intelligence, while increasing productivity, visibility, accuracy, and compliance. Learn more at insightsoftware.com.

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 andmaintainscalable data pipelines, build Power BI solutions that drive decisions, and champion AI-assisted workflows that make the team faster and smarter. This role sits at the intersection of engineering precision and businesspartnership.

What You Will Do

Data Engineering

• Design, build, andmaintainELT/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.

Business Intelligence & Reporting

• Develop andmaintainPower 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 ambiguousasksinto structured analytical deliverables.

• Champion self-serve analytics by building reusable semantic layers that reduce ad hoc request volume.

AI-First Ways of Working

• Actively use AI tools (such as LLM assistants, copilots, and agentic workflows) to accelerate development, improve code quality, and generate documentation.

• Identifyopportunities 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,validatingresults before using them in production.

Business Partnership

• 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

Required

• 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 BIproficiency, 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 asFivetran,dbt, or similar.

• Familiarity with Salesforce data structures or CRM-adjacent reporting.

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

The salary range in United States of America for this position is 72,000.00 to 90,000.00 USD Annual.

Your specific offer within this range will be determined by your skills, experience, and qualifications. 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. If you have questions about our compensation approach, please don't hesitate to ask during the interview process.

Additional Information

All your information will be kept confidential according to EEO guidelines.

Learn more about our high-energy, high-performance global team: Work With Us

insightsoftware About Us: Hear From Our Team

Background checks are required for employment with insightsoftware, where permitted by country, state/province.

At insightsoftware, 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 proud to be an equal opportunity workplace.