James Benson

Data & Analytics Engineer @ Sensiba LLP | Data Engineering, Self-Service Solutions

Salt Lake City Metropolitan Area

About

Data & AI Engineer with expertise in data platforms, advanced analytics, and BI modernization. Currently leading the transformation of self-service analytics at Sensiba, a global accounting firm supporting $97M Net Revenue. I specialize in building AI/Analytics-ready data environments using Microsoft Fabric, Python, SQL, HEX, Fivetran, and Power BI, enabling scalable pipelines, automation, and interactive dashboards. My work has reduced manual reporting by 95% and reshaped fiscal planning across Finance, Sales, and RAS departments. 🛠️ Technical Highlights Data Engineering: Microsoft Fabric, Python (pandas, scikit-learn, TensorFlow, PyTorch), SQL, DBT, Snowflake, Fivetran Analytics & BI: HEX, Power BI, metrics frameworks, governance, executive dashboards Machine Learning: NLP regression modeling, predictive analytics, statistical testing 📊 Business Impact Designed metrics models that deliver real-time financial insights and transparency for leadership Built Python-driven pipelines connecting Salesforce, Iris, and other systems for automated ingestion and live refresh Partnered directly with executives to translate analytics into fiscally responsible strategies company-wide 🌏 Global & Cross-Cultural Perspective Having lived and worked across Asia (including Hong Kong and Japan), I bring cross-cultural awareness and adaptability. 🇯🇵 Japan Focus Currently studying Japanese and committed to building a long-term career in Japan. センシバでデータエンジニアリングとセルフサービスBIを担当し、Net Revenue $97Mをサポート

Experience

  • Data & Analytics Engineer at Sensiba LLP
    Apr 2024 - Present · 2 yrs 3 mos

    Reporting to the Director of Operations with direct collaboration with C-suite executives (CTO, CFO) on enterprise analytics strategy. • Modernized the firm's self-service reporting environment using Microsoft Fabric, SQL, Python, HEX, Fivetran, and Power BI, supporting $97M Net Revenue across departments. • Engineered complex financial reporting systems including partner compensation tracking (PAR), employee incentive calculations, AR aging analysis, and cash receipt allocation validation. • Reduced manual reporting effort by 95% through automated data pipelines and governance processes. Accelerated monthly report delivery from 7 days to on-demand. • Established enterprise analytics governance framework—standardized DAX documentation, KPI definitions, and debugging protocols—reducing analyst onboarding time by 75% across 57+ executive reports and dashboards. • Architected reusable component library in HEX for Sales Performance and Executive Report dashboards, reducing query duplication by 57%. • Developed systematic debugging methodology for Power BI semantic models, reducing issue resolution time from 3 days to 4 hours. Key Projects: Partner Achievement Report (PAR) • Renewals & Retention Analytics • Employee Incentive System • AR/WIP Financial Tracking

  • Analytics Engineer at Billtrust
    May 2022 - Mar 2024 · 1 yr 11 mos

    Developed and executed data query processes, creating 10+ visualized reports in PowerBI for senior management to track key performance indicators (KPIs) and make informed business decisions ▪ Collaborated with cross-functional teams to implement a robust data pipeline system, enabling real-time connections to live data sources and reducing report generation time by over 75% ▪ Created visually compelling dashboards and reports to effectively communicate data-driven insights and over $16.3 M ARR to stakeholders, resulting in a 30% increase in stakeholder engagement and understanding ▪ Utilized advanced data visualization techniques to present complex analytical findings in clear and concise formats, enabling stakeholders to make informed decisions in 20% less time ▪ Led projects to automate script deployments that update database tables by coordinating efforts and communicating technical challenges with domain experts while using critical thinking to develop creative solutions, reducing manual data maintenance tasks by 80% for reports without a live data connection ▪ Spearheaded growth of custom report products to external customers by maintaining successful Rundeck job delivery uptime by 95+% and reducing new or product update turnaround time by 20% of the SLA timeframe ▪ Developed a team of 4 interns by engaging them in impactful strategic goal projects, supporting their career development goals, and improving their technical skills through exercises and feedback

  • General Manager at Praiseworthy Studios
    Sep 2013 - Jun 2021 · 7 yrs 10 mos

    Implemented targeted marketing campaigns that resulted in a customer base growth of over 150% within the first year of use, surpassing both previous projections and prior campaign metrics ▪ Utilized data-driven insights to optimize customer acquisition strategies, resulting in a 65% increase in conversion rates and generating an increase of over 300% in annual revenue ▪ Managed and coordinated the successful execution of projects across 6 different teams, meeting tight deadlines and exceeding customer satisfaction targets by 30% ▪ Improved the company's online presence and collaboration with clients by creating a website and social media pages where clients could interact with the teams, follow the project progress, and provide real-time feedback Developed and trained a Natural Language Processing model using logistic regression, achieving an accuracy rate of 85% in sentiment prediction for articles • Collaborated with a team of researchers to collect and annotate a dataset of 132,307 articles for training the NLP model, ensuring comprehensive coverage across various domains and sentiments