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
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Serve as strategic HR partner to G&A senior leaders, leading org design and restructures, driving performance calibration, using data and AI tools to surface org health risks, and translating people strategy into measurable outcomes across global, high-growth teams.
Cloud • Fintech • Food • Information Technology • Software • Hospitality
Manage a large portfolio of payroll customers to prevent churn, drive renewals and expansion, resolve technical escalations, deliver adoption trainings, advocate product improvements, and partner cross-functionally to improve payroll and tax workflows and customer outcomes.
Top Skills:
Ai ToolsChilipiperCore PosEmployee CloudGoogle SuiteMS OfficePayroll SoftwarePos SoftwareSalesforce CRMSlack
Big Data • Fintech • Information Technology • Insurance • Software
Lead two engineering groups owning carrier product configuration and enrollment workflows. Set technical vision, ensure scalable event-sourced microservices, drive repeatable implementation patterns, own delivery and incident posture, build automated testing, hire and grow engineering managers, and directly drive AI adoption and cross-team interfaces with Product, Delivery, Underwriting, and Compliance.
Top Skills:
Asynchronous MessagingEvent SourcingGoGoogle Cloud Platform (Gcp)GrpcKubernetesPostgresPythonRestTypescript
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
