BI and AI Automation Engineer Trianz
2 Overland Park, KS Job Details Full-time | Contract 1 hour ago Qualifications Stakeholder management
Full Job Description Role:
Business Intelligence & AI Automation Engineer Location:
[Location(s) / Remote]
- Hybrid
- Overland Park, KS
- 3 days in a week from office
Employment Type:
[Full-time /Contract]•
Contract Duration:
4 months Company Overview Trianz is an applied AI solutions company that accelerates customer business transformation through AI powered "Transformation Services as a Software Model" . With 25+ years of transforming enterprises, we've evolved to a product-led, platform-driven organization serving global enterprises across Financial Services, Insurance, Healthcare, Hi-Tech, Manufacturing, and other industries. With global presence across 4 continents, our platform portfolio under the unified Concierto brand delivers end-to-end transformations including solutions for Migrate, Manage, Maximize, Modernize, Insights & Agentic AI, and SecOps
- delivered through strategic partnerships with leading hyperscalers. We're building the premier innovation-led organization in the digital transformation space through AI-first methodologies and data-driven excellence
- RevolutionAIzing Transformations.
Role Overview We are seeking a skilled Business Intelligence (BI) and AI Automation Engineer with strong expertise in Amazon Quick Suite (including QuickSight) and AWS analytics services to support business teams in building scalable, self-service reporting solutions and intelligent workflow automation. The ideal candidate will partner closely with business stakeholders to understand reporting and automation needs, enable self-service analytics, design reusable reporting frameworks, build AI-powered workflows, and implement agentic AI solutions that reduce manual effort, compute costs, and improve operational efficiency across the organization. This role requires a mix of technical BI development, data modeling, AI agent design, workflow automation, stakeholder collaboration, and cost optimization within AWS. Key Responsibilities 1. Quick Suite Development & AI-Powered Reporting Design, develop, and maintain interactive dashboards, datasets, and visualizations in Amazon QuickSight (now part of Quick Suite). Build and configure Quick Chat agents to enable natural language querying across business data sources. Design Quick Spaces that group data, applications, and AI agents for specific business functions or teams. Build high-performance dashboards optimized for large datasets and fast refresh times. Implement row-level security (RLS) and governance controls for business users and AI agents. Create standardized QuickSight templates and dashboard frameworks that can be reused across teams. Design and maintain semantic layers and curated datasets for reporting and AI consumption. Optimize dashboards to reduce SPICE usage, refresh costs, and compute consumption. 2. AI Workflow Automation & Agent Development Design and implement Quick Flows to automate repetitive business tasks (weekly reports, data summaries, alert notifications). Build Quick Automate workflows for complex, multi-step enterprise processes (onboarding, approvals, data reconciliation). Create custom Chat Agents with tailored system prompts for specific business roles (sales, operations, finance, analytics). Configure Quick Research capabilities to enable deep business intelligence research with cited sources. Integrate Quick Suite with enterprise applications (Salesforce, ServiceNow, Slack, Jira, SharePoint) via 50+ built-in connectors and MCP protocols. Build reusable automation templates and workflow patterns that can be deployed across multiple business units. 3. Self-Service BI & AI Enablement Work directly with business users and analysts to enable self-service reporting and AI automation capabilities. Provide guidance on best practices for dashboard design, data consumption, and AI agent usage . Create reusable data models, templates, reporting accelerators, and workflow automation patterns . Develop training materials and documentation for business teams to build their own dashboards and configure AI agents . Conduct workshops and enablement sessions for business users on Quick Suite usage (QuickSight, Quick Chat, Quick Flows, Quick Automate). 4. Data Modeling & Dataset Engineering Design and maintain optimized datasets and data models for BI reporting and AI agent consumption . Build reusable data flows and data pipelines that serve multiple reporting and automation use cases. Work with engineering teams to integrate data from sources such as: AWS Redshift S3 Athena RDS Glue Data Catalog Enterprise apps via Quick Suite connectors (Salesforce, Snowflake, SharePoint, Google Drive) Ensure datasets follow governance, quality, and consistency standards. 5. Reporting Frameworks & Reusable Components Create reusable reporting templates, dataset templates, and QuickSight themes. Build standardized KPIs, calculated fields, and metric definitions. Design modular AI agents and workflow templates that can be used across multiple business functions. Design modular reporting components that can be used across multiple dashboards. Implement parameterized dashboards and reusable visual components. 6. Performance Optimization & Cost Management Identify opportunities to reduce compute costs associated with reporting and AI automation workloads . Optimize use of SPICE vs direct query based on performance and cost requirements. Monitor and tune query performance across Athena, Redshift, and other data sources. Optimize Quick Suite automation workflows to minimize API calls, data transfers, and compute usage. Implement efficient refresh schedules and dataset management strategies. Provide recommendations for cost-efficient reporting and automation architectures on AWS. 7. Collaboration with Business & Data Teams Partner with product owners, business analysts, and leadership teams to understand reporting and automation requirements . Translate business needs into scalable BI solutions and intelligent automation workflows . Work with data engineering teams to ensure required datasets are available and optimized. Participate in requirements gathering and reporting and automation roadmap planning . 8. Governance, Documentation & Standards Establish BI standards and governance for QuickSight dashboards and Quick Suite AI agents .
Maintain documentation for:
Datasets Metrics Dashboard logic Reporting frameworks AI agent configurations Workflow automation patterns Quick Suite integrations Ensure adherence to data security and access policies for both human users and AI agents . Implement naming conventions and versioning for dashboards, datasets, AI agents, and workflows . Ideal Candidate Profile 8+ years of experience in Business Intelligence, Analytics Engineering, or Data Visualization. Strong hands-on experience with Amazon Quick Suite (including QuickSight). Experience designing AI-powered workflows, automation, or conversational AI agents (preferred but not required if willing to learn). Experience designing interactive dashboards and enterprise reporting solutions. Solid knowledge of SQL and data modeling. Experience working with AWS analytics services such as: Athena Redshift S3 Glue Experience enabling self-service analytics for business users. Strong understanding of data visualization best practices. Experience optimizing reporting performance and cost efficiency. Ability to learn and adopt new AI-powered tools and platforms rapidly . Key Skills Amazon Quick Suite (QuickSight, Quick Chat, Quick Flows, Quick Automate, Quick Research) SQL & Data Modeling AWS Analytics Stack Dashboard Design AI Agent Design & Configuration Workflow Automation & Business Process Optimization BI Architecture Self-Service Analytics Enablement Performance Optimization Cost Optimization API Integration & Enterprise Connectors Stakeholder Communication Preferred Qualifications Hands-on experience with Amazon Quick Suite (Quick Chat, Quick Flows, Quick Automate, Quick Research, Quick Spaces). Experience building conversational AI agents, chatbots, or automation workflows . Experience with API integrations, webhooks, and enterprise application connectors (Salesforce, ServiceNow, Slack, Jira). Experience building QuickSight templates, themes, and reusable datasets. Experience with BI governance and semantic layer design. Familiarity with data pipelines and ETL frameworks. Knowledge of AWS cost optimization strategies. Experience supporting large-scale enterprise reporting environments. Experience with other BI tools such as Tableau, Power BI, or Looker. Experience with low-code/no-code automation platforms (Zapier, Power Automate, Workato). Why choose Trianz?
Personal Growth:
Startup agility with enterprise impact. Experience rapid innovation cycles while working on Fortune 500 transformations.
AI-First Future:
Where humans and AI revolutionize business. Lead the charge in implementing AI-driven transformation at scale.
Global Impact:
Shape transformation across continents. Work with diverse teams and clients spanning Americas, Europe, Asia, and beyond.
Executive Access:
Direct impact on Fortune 500 strategies. Work alongside C-suite leaders and influence major business decisions.
Ownership & Entrepreneurial Spirit:
Your ideas, our platform, global impact. Zero bureaucracy culture with decision-making autonomy and rapid execution. Equal Employment Opportunity Trianz is an Equal Opportunity Employer and does not discriminate based on race, color, creed, national or ethnic origin, gender, religion, disability, age, political affiliation or belief, special needs veteran, veteran of the Vietnam Era, or citizenship status (except in those special circumstances permitted or mandated by law). We comply with all state and federal laws and regulations protecting employees and applicants against illegal discrimination, retaliation, and harassment. Our policy is available upon request. We consider qualified applicants with criminal histories, consistent with applicable federal, state, and local law. Trianz participates in the E-Verify program in certain locations, as required by law. We are committed to providing reasonable accommodation for all qualified individuals with a disability or other reasons protected by applicable laws. If you require assistance or accommodation due to a disability or special needs to search for a job opening or apply, please email with your request and contact information. Trianz Privacy Notice Trianz respects your privacy and wants to ensure we comply with applicable Data Privacy Regulations as per local regulator laws. Please review our privacy policy at https://www.trianz.com/privacy-policy for more.
