[Remote] Associate Data Engineer

Note: The job is a remote job and is open to candidates in USA. insightsoftware is a global provider of reporting, analytics, and performance management solutions that empower leaders from over 32,000 organizations to make informed decisions. The company is seeking an Associate Data Engineer to design and maintain scalable data pipelines, build Power BI solutions, and utilize AI tools to enhance data processes and reporting capabilities.ResponsibilitiesDesign, build, and maintain ELT/ETL pipelines that move data reliably from source systems into a cloud data warehouse environmentWrite clean, performant, and well-documented SQL to transform raw data into analyst-ready models and reporting layersPartner with the team to define and enforce data modeling standards, naming conventions, and documentation practicesMonitor pipeline health, troubleshoot failures, and implement proactive alerting to protect data availabilityDevelop and maintain Power BI dashboards and reports that give business stakeholders clear, trusted views of company performanceApply best practices in data modeling within Power BI (star schemas, DAX measures, performance optimization) to ensure reports are fast and maintainableWork closely with business partners to understand reporting requirements, translating ambiguous asks into structured analytical deliverablesChampion self-serve analytics by building reusable semantic layers that reduce ad hoc request volumeActively use AI tools (such as LLM assistants, copilots, and agentic workflows) to accelerate development, improve code quality, and generate documentationIdentify opportunities to apply AI and automation to repetitive data tasks, from data quality checks to pipeline scaffoldingStay current on emerging AI/data tooling and share practical learnings with the teamApply a critical, evidence-based lens to AI outputs, validating results before using them in productionEngage directly with business stakeholders to understand data needs in context, asking smart questions and pushing back constructively when requirements are unclearCommunicate technical concepts and data limitations in plain language, building trust with non-technical partnersContribute to data governance practices, including metadata documentation, lineage tracking, and data quality standardsSkills3+ years of hands-on data engineering or analytics engineering experience in a professional settingStrong SQL skills: complex joins, window functions, query optimization, and data modelingDemonstrated Power BI proficiency, including report development, data modeling, and DAXExperience working with cloud data warehouse platforms (Snowflake, BigQuery, Redshift, or similar)Proven, active use of AI tools in daily data work, not just awarenessAbility to engage with business stakeholders and translate requirements into data solutionsStrong written and verbal communication skillsExperience with ELT/ETL orchestration tools such as Fivetran, dbt, or similarFamiliarity with Salesforce data structures or CRM-adjacent reportingExposure to agentic AI workflows, prompt engineering, or LLM-powered automationBackground in financial or ARR/revenue data domainsExperience with role-based access control and data security practices in cloud platformsBenefitsFor non-sales roles, you may be eligible for a bonus.Background checks are required for employment with insightsoftware, where permitted by country, state/province.Company Overviewinsightsoftware is the most comprehensive provider of solutions for the Office of the CFO. It was founded in 2018, and is headquartered in Raleigh, North Carolina, USA, with a workforce of 1001-5000 employees. Its website is https://www.insightsoftware.com.Company H1B Sponsorshipinsightsoftware has a track record of offering H1B sponsorships, with 1 in 2025, 3 in 2024, 3 in 2023, 4 in 2022. Please note that this does not guarantee sponsorship for this specific role.