Business Analyst III

Business Systems Analyst III Remote Summary Business Analyst with 6-7 years of experience in SQL, data modeling, pipeline development, and operational analytics, who can own and improve the data systems supporting all Enterprise Support pillars rather than only maintain them. Day to day this covers building and maintaining data pipelines, Hive tables, SQL queries, and dashboards. Beyond that, the role is expected to bring its own judgment: proposing better data models, applying AI and LLM tooling to accelerate data work and extract signal from unstructured support data, improving documentation and governance standards, and identifying reporting gaps. Priorities and direction are set with the manager, but the contractor owns how the work gets done and is expected to identify and recommend improvements. Responsibilities Own the day to day health of the Enterprise Support data layer: pipelines, Hive tables, SQL, and dashboards Design and build data models for new reporting needs, proposing the approach rather than receiving a specification Maintain a documented source of truth for Enterprise Support metrics: definitions, ownership, and freshness Apply AI and LLM tooling to accelerate data work and to extract signal from unstructured support data such as ticket notes and resolution summaries Improve pipeline reliability and reduce manual effort over time through automation Monitor pipeline health, resolve failures and data quality issues, and run backfills Deliver recurring reporting (weekly, monthly, quarterly) and ad hoc analysis Apply and maintain standards for naming, documentation, and schema change management Proactively surface data quality, governance, and coverage gaps Compliance Must follow data handling and privacy standards, including appropriate data classification, least privilege access to sensitive datasets, and no storage of confidential or personally identifiable data outside approved internal systems. Must apply sound judgment about the appropriate use of AI and LLM tooling on internal data. Experience working within enterprise data governance and access control processes is required. Requirements 6-7 years of experience in data analytics, business analytics, or analytics engineering Advanced SQL skills, including experience with large scale distributed query engines such as Presto and Hive Demonstrated ownership of production data pipelines and data models, including design decisions rather than only maintenance Practical experience applying AI or LLM tooling within data workflows Experience with data modeling and dashboard development Ability to work independently and communicate status, recommendations, and blockers clearly in writingAdvanced SQL, ideally with Presto and Hive against large datasets Building and maintaining production data pipelines: scheduling, dependency management, backfills, and monitoring Data modeling and warehouse design: schema design, grain, partitioning, and documentation Practical use of AI and LLM tooling in data work, and judgment about where it is and is not appropriate Data governance practice: documented metric definitions, clear table ownership, schema change management, and retiring stale datasets Python or similar scripting for data transformation and automation Dashboarding and data visualization Prior experience supporting an IT, enterprise support, or operations organization Self-directed: able to take a loosely defined problem, propose an approach, and execute it Bachelor's degree in a quantitative, analytics, computer science, or information systems field, or equivalent practical experience Preferred qualifications Data governance experience: metric catalogs, lineage, table ownership, and schema change management Experience supporting an IT, enterprise support, or technical operations organization Python or similar scripting experience for data automation Experience maintaining operational metrics and SLA reporting Pay and Benefits Pay range is $64 - $69 per hour with full benefits available, including paid time off, medical/dental/vision/life insurance, 401K, parental leave, and more. Our compensation reflects the cost of labor across several US geographic markets. Pay is based on several factors including market location and may vary depending on job-related knowledge, skills, and experience. THE PROMISES WE MAKE: At Crystal Equation, we empower people and advance technology initiatives by building trust. For more information regarding our Privacy Policy, please visit crystalequation.com/privacy. #J-18808-Ljbffr Crystal Equation Corporation