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.
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 (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
Skills
- 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
- 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
Benefits
- For 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 Overview
insightsoftware 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 Sponsorship
insightsoftware 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.