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
AdTech • Digital Media • Marketing Tech
The Principal Technical Program Manager leads the strategic planning and execution of complex technical programs, aligning them with business goals and managing cross-functional teams.
Top Skills:
Advertising Technologies
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Develop actionable go-to-market strategies for AI sales and consumption pricing while driving business growth and engagement. Collaborate cross-functionally to influence strategic direction and optimize customer experience.
Top Skills:
AIData VisualizationFinancial AnalysisSaaS
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
The SEO Specialist II enhances clients' online presence through data analysis, local SEO tactics, strategic content implementation, and collaboration with internal teams. They provide performance reports, client support, and ongoing SEO education while managing SEO-related requests and trends.
Top Skills:
CopyscapeDba PlatformGoogle AnalyticsGoogle Search ConsoleLocal FalconMajestic SeoMoz ProSem Rush
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
