Beyondsoft

BI Analyst

Beyondsoft

full-time

Posted on:

Location Type: Remote

Location: Remote • Washington • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Salary

💰 $42 - $46 per hour

Job Level

Mid-LevelSenior

Tech Stack

ETLSQL

About the role

  • Develop, maintain, and enhance Power BI dashboards and reports that extract and visualize data from ActiveX Data Objects (ADO) data sources.
  • Build and maintain robust data connections between Power BI and legacy systems using ADO, ensuring efficient and secure data access.
  • Design and implement ETL processes to import, transform, and clean data for reporting and analytics.
  • Collaborate with business analysts, project managers, and technical teams to understand reporting requirements and translate them into actionable insights.
  • Optimize data retrieval and query performance through ADO and Power BI modeling best practices.
  • Ensure data accuracy, consistency, and integrity across all BI reports and underlying databases.
  • Automate repetitive reporting tasks and maintain scheduled data refreshes within Power BI Service or on-prem environments.
  • Support data governance by adhering to Microsoft standards and implementing proper documentation and version control of BI assets.
  • Troubleshoot connection, performance, or data inconsistency issues between Power BI and ADO data sources.

Requirements

  • Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field.
  • 3–6 years of experience in Power BI development with strong knowledge of ActiveX Data Objects (ADO) for data access.
  • Proficiency in DAX, Power Query (M), and Data Modeling within Power BI.
  • Experience working with ADO-based data connections (e.g., connecting to SQL Server, Access, or legacy COM-based data layers).
  • Strong understanding of SQL queries, relational databases, and connection string management.
  • Excellent analytical, troubleshooting, and communication skills.
  • Ability to manage multiple BI deliverables and meet deadlines effectively.
  • Experience working in Microsoft technology environments or with enterprise clients is a strong plus.
Benefits
  • 15 days per year of Paid Time Off (PTO).
  • 8 paid holidays + 1 personal floating holiday
  • 401(k) retirement plan with company match.
  • Medical, dental, and vision insurance, health savings account (HSA), short-term and long-term disability, employee assistance plan (EAP), and basic life and AD&D insurance.
  • Health care flexible spending account, dependent care flexible spending account, commuter benefits, voluntary accident & critical injury coverage, voluntary long-term care coverage, and voluntary life and AD&D insurance.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
Power BIActiveX Data Objects (ADO)ETL processesDAXPower Query (M)Data ModelingSQLrelational databasesdata retrieval optimizationdata governance
Soft skills
analytical skillstroubleshooting skillscommunication skillstime managementcollaborationproblem-solvingattention to detailadaptabilityorganizational skillsdeadline management
Certifications
Bachelor’s degree in Computer ScienceBachelor’s degree in Information SystemsBachelor’s degree in Engineeringrelated technical field degree