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
.png)
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Lead and grow an Infrastructure Security team securing cloud infrastructure, edge networks, and application delivery. Drive cloud security architecture, WAF/SASE/zero-trust implementations, PAM and secrets management, incident management and on-call response, KPIs/OKRs, cross-team partnerships, and continuous security process and tooling improvements.
Top Skills:
AnsibleAWSAws Wafv2AzureAzure WafBeyondtrustCloudflareCyberarkDdosGCPGcp Cloud ArmorHashicorp VaultKeeperSaseTerraformZero-Trust
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Lead product analytics for a B2B SaaS product: define metrics and measurement frameworks, analyze user behavior and product performance, build self-service dashboards, partner cross-functionally to link usage to business outcomes, and translate data into strategic recommendations for product roadmap and GTM decisions.
Top Skills:
Ai ToolsBigQueryExcelGCPPendoSnowflakeSQLTableau
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Lead design and delivery of AI-enabled, cloud-native solutions (primarily GCP) including multi-agent systems, orchestration pipelines, MCP integrations, and scalable APIs. Act as senior advisor in pre-sales, run technical discovery workshops, translate business problems into AI architectures and POCs, and mentor development teams and architects.
Top Skills:
Agent FrameworksAPIsContainersDistributed SystemsEvent-Driven ArchitecturesGCPGraphQLKubernetesLlm-Based ApplicationsMcp ServersMicroservicesOrchestration FrameworksRestWorkflow Engines
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
