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
Artificial Intelligence • Productivity • Sales • Software
Serve as a technical Customer Success Manager advising B2B clients on AI-led transformation using monday.com's platform. Drive adoption, design scalable automated solutions, lead technical workshops, use product usage data to identify expansion opportunities, and represent customer needs to Product and Engineering.
Top Skills:
APIsGenerative AiMonday.Com
Fintech • Mobile • Payments • Software • Financial Services
Provide multi-channel technical support for enterprise API partners, diagnose and debug REST APIs, interpret logs and query databases, respond to high-severity incidents, collaborate with engineering and product teams, and capture partner issue trends to improve the platform.
Top Skills:
DatabasesJavaScriptPythonRest ApisSwift
Automotive • Edtech • Kids + Family • Mobile • Social Impact • Transportation
Lead a pod of 5-6 BDMs and CarePartner Specialists to manage onboarding, integration, and performance of professional WAV and Livery fleets. Drive supply-side performance, standardize operational SOPs, manage high-complexity partnerships, escalate operational issues, coach and develop team members, and align supply acquisition with district demand and operational capacity.
Top Skills:
Ai ToolsData ToolsLlmsWorkflow Automation
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
