Note: The job is a remote job and is open to candidates in USA. Confidential is seeking a Business Systems Analyst IV to own and improve the data systems supporting Enterprise Support. The role will develop and maintain data pipelines, models, dashboards, reporting, governance, automation, and data quality processes, while applying AI and LLM tooling to analyze support data and help leadership make operational decisions.
Responsibilities
- Own the day-to-day health and reliability of the **Enterprise Support data layer**, including pipelines, Hive tables, SQL queries, and dashboards
- Design and build **data models and warehouse structures** for new reporting and analytical requirements
- Make technical and modeling decisions independently rather than relying solely on predefined specifications
- Build, maintain, and improve **production ETL/ELT pipelines**, including scheduling, dependency management, monitoring, failure resolution, and backfills
- Maintain a documented **source of truth for Enterprise Support metrics**, including metric definitions, data ownership, and freshness
- Apply **AI and LLM tooling** appropriately to accelerate data analysis and identify signals within unstructured support information such as ticket notes and resolution summaries
- Identify opportunities to automate manual processes and improve pipeline reliability and operational efficiency
- Monitor data quality and pipeline performance, investigate discrepancies, and resolve data issues
- Deliver recurring **weekly, monthly, and quarterly reporting**, as well as ad hoc analyses for business stakeholders
- Develop and maintain dashboards and operational reporting used by Enterprise Support leadership
- Establish and maintain standards for **data naming, documentation, schema changes, and dataset lifecycle management**
- Proactively identify gaps in data quality, governance, reporting coverage, and metric definitions
- Communicate project status, recommendations, risks, and blockers clearly and proactively in writing
- Partner with the manager and relevant stakeholders to translate business needs into scalable data solutions
Skills
- 6–7 years of experience in data analytics, business analytics, analytics engineering, or a related field
- Advanced SQL skills with hands-on experience working with large-scale datasets
- Experience using distributed query engines such as Presto and Hive
- Demonstrated experience building and maintaining production data pipelines, including scheduling, dependency management, backfills, monitoring, and failure resolution
- Strong understanding of data modeling and warehouse design, including schema design, data grain, partitioning, and documentation
- Experience making data architecture or modeling decisions rather than solely maintaining existing solutions
- Practical experience applying AI or LLM tooling within data or analytical workflows
- Experience developing dashboards and operational reporting
- Ability to work independently in an environment where requirements may be loosely defined
- Strong written communication skills, including the ability to clearly document technical work, recommendations, status, and blockers
- Bachelor's degree in Computer Science, Information Systems, Analytics, a quantitative discipline, or equivalent practical experience
- Experience with data governance, including metric catalogs, lineage, table ownership, schema change management, and dataset lifecycle management
- Experience supporting an IT, enterprise support, or technical operations organization
- Experience with Python or similar scripting languages for data transformation and automation
- Experience maintaining operational metrics, SLA reporting, and service-performance dashboards
- Experience working with large-scale enterprise datasets and distributed data platforms
- Experience identifying and resolving data quality and reporting coverage gaps
- Experience using AI/LLM technologies to analyze unstructured operational or support data
Benefits
- Health
- Dental
- Vision
- 401K
- PTO
- Remote work
Company Overview