Business Data Analyst

hackajob on-demand focuses on matching talented contractors like you with organisations seeking specific skills for their projects. We use our platform to connect you with exciting contract opportunities and discuss projects on behalf of the companies we partner with. Data Business Analyst Location: Hybrid - 3 Days Onsite in New York Required Skills and Qualifications • Proficiency in SQL and proven experience designing and implementing data models and schemas • Strong understanding of data warehousing concepts (dimensional modeling, star/snowflake schemas) • Hands-on experience with Power BI, including dashboard development and UX-focused data visualization • Proven ability to transform and optimize large, raw datasets into structured, analytics-ready formats • ETL experience required; experience using Alteryx is preferred but not required • Excellent communication skills with the ability to effectively engage and present to project stakeholders • Strong analytical thinking and problem-solving abilities with attention to detail Key Responsibilities • Design, develop, and maintain data models and schemas to support business intelligence and analytics initiatives • Leverage SQL to query, transform, and optimize large datasets for reporting and analysis • Build and enhance Power BI dashboards and reports, applying UX and data visualization principles to ensure clarity and usability • Implement and manage ETL processes to ensure data accuracy, consistency, and reliability across systems • Collaborate with business stakeholders to gather requirements, define KPIs, and deliver actionable insights that drive decision-making • Apply data warehousing concepts such as dimensional modeling and star/snowflake schemas to structure data efficiently • Partner with data engineers, analysts, and business teams to ensure seamless data integration and reporting workflows • Troubleshoot data quality issues, identify process improvements, and ensure data governance standards are upheld Preferred Experience • Experience working in cross-functional data environments • Familiarity with other data visualization or ETL tools is a plus • Background in business analysis, data engineering, or analytics consulting