The EDW Business Reporting Analyst designs and maintains enterprise dashboards, optimizing SQL queries for data extraction and analysis, while collaborating with stakeholders to drive impactful business decisions through data visualization.
This is a remote position.
KATBOTZ LLC is seeking a EDW Business Reporting Analyst to join our team for a client-side project. Candidates should have a strong background in SQL and Tableau, with a focus on delivering actionable insights through enterprise data warehouse (EDW) reporting solutions. This role requires a blend of technical skills, analytical thinking, and stakeholder management to drive business decisions through effective data visualisation and reporting.
Key Responsibilities
- Design, develop, and maintain enterprise-level dashboards and reports using Tableau to support business decision-making
- Write and optimize complex SQL queries for data extraction, transformation, and analysis from various data sources
- Collaborate with business stakeholders to understand reporting requirements and translate them into technical specifications
- Implement data quality measures and perform regular audits to ensure data accuracy and reliability
- Provide documentation and training for end-users on report usage and data interpretation
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, or related field
- Expertise with 10+ years of experience in Enterprise Data Warehouse (EDW) reporting and analytics using SQL and Tableau
- Strong understanding of data warehouse concepts and dimensional modelling
- Strong background in developing and maintaining complex SQL queries, stored procedures, and ETL processes
- Hands-on experience in creating interactive Tableau dashboards and visualisation
- Experience in data modelling, optimization, and performance tuning
Preferred Skills & Qualifications
- Tableau Desktop Specialist or Tableau Desktop Certified Professional certification
- Experience with SAP HANA and EDW
- Advanced SQL skills including performance tuning and optimization
- Knowledge of data visualisation best practices and user experience design
- Experience in working with large-scale data warehouses
- Strong problem-solving and analytical skills
- Excellent communication and stakeholder management abilities
- Experience in Agile development methodologies
- Knowledge of data governance and security principles
- Proficiency in Microsoft Office suite
Benefits
- Competitive compensation package
- Opportunities for professional development and career advancement.
- Flexible working conditions, with remote options available.
- Dynamic and supportive work environment.
Equal Employment Opportunity
KATBOTZ LLC is an Equal Opportunity Employer. We provide equal employment opportunities to all qualified individuals, regardless of race, religion, gender, gender identity, age, marital status, national origin, sexual orientation, citizenship status, veteran status, disability, or any other legally protected status. As an organization, we are unwavering in our commitment to maintaining a discrimination-free work environment, and fostering a culture of inclusivity, belonging and equal opportunity for all employees and applicants.
Similar Jobs
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
The Customer Care Advocate guides customers through complex insurance-related inquiries, using AI tools to enhance service accuracy and efficiency while ensuring compliance and customer confidence.
Top Skills:
Ai-Powered ToolsCustomer Relationship Management
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Lead development and lifecycle management of supplemental health insurance products (Critical Illness, Cancer, Accident, Hospital Indemnity). Drive market research, competitive analysis, go-to-market plans, and cross-functional launches working with Pricing, Contracts, Operations, Technology, Training, and Sales to deliver product strategy and execution.
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead enterprise AI transformation and architecture engagements, advising C-suite on AI strategy, designing end-to-end AI and data architectures (RAG, knowledge graphs, data catalogs), defining governance and responsible AI frameworks, and driving adoption, enablement, and practice development across ServiceNow implementations.
Top Skills:
Agent-To-Agent (A2A)Agentic WorkflowsAi AgentsAi Control TowerApp EngineCsmFsmGenerative Ai Skill KitHrsdItsmKnowledge GraphsModel Context Protocol (Mcp)Now AssistRdfRetrieval-Augmented Generation (Rag)ServicenowSparql
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
