Magnitude Software Logo

Magnitude Software

Associate Data Engineer

Reposted 2 Months Ago
Remote
Hiring Remotely in USA
72K-90K Annually
Mid level
Remote
Hiring Remotely in USA
72K-90K Annually
Mid level
Design and maintain ELT/ETL pipelines and cloud data warehouse models, build Power BI reports, apply AI tools to accelerate data workflows, and partner with business stakeholders to deliver reliable analytics and data governance.
The summary above was generated by AI

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 and maintain scalable 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 business partnership. 

What You Will Do 

Data Engineering 

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

Business Intelligence & Reporting 

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

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. 

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

 

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 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. 

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. 




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.

Similar Jobs

2 Days Ago
Remote
United States
Entry level
Entry level
Other
Contributes to building and optimizing a large-scale data lake and reliable data pipelines for cybersecurity analytics. Responsibilities include data modeling, distributed processing, workload optimization, monitoring, observability, CI/CD, code reviews, and supporting MLOps. The role collaborates with senior engineers to improve processes and deliver cost-effective cloud data solutions.
Top Skills: SparkCi/CdData LakesData WarehousingDatabricksDistributed ProcessingGraph Data StoresMlopsObject StoresPythonReal-Time Processing
13 Days Ago
Remote
United States
70K-80K Annually
Junior
70K-80K Annually
Junior
Real Estate
Develop and maintain data pipelines, infrastructure, and integrations supporting analytics, data science, and business intelligence. Ensure data quality and integrity, optimize workflows, and collaborate with Operations, IT, Accounting, HR, Property Services, Marketing, and other departments. The role requires SQL Server, programming, shell scripting, cloud, containerization, version control, and data pipeline knowledge, with occasional travel and flexible scheduling as project deadlines require.
Top Skills: Apache AirflowAWSAzureBashC#Ci/CdDockerEmacsExcelGCPGitKubernetesLinuxMarkdownMicrosoft Office SuiteMicrosoft PowershellMicrosoft Sql ServerNotepad++PythonRustT-SqlTerraformVimVisual StudioVisual Studio Code
One Month Ago
Remote or Hybrid
Junior
Junior
Legal Tech • Financial Services • Generative AI
Translates evolving regulations into product specifications, truth sets, regulatory memos, demos, and benchmark criteria. Reviews AI outputs for accuracy, relevance, and completeness; leads root-cause analyses and collaborates with engineering on corrective actions. Engages customers and prospects, explains regulatory challenges, supports industry events, and develops sector-specific demonstrations. Requires strong regulatory analysis, communication, legal or compliance expertise, and the ability to work effectively with complex products in a fast-paced environment.
Top Skills: AI

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account