Data Analyst Power BI & SQL
Location - NYC Hybrid 3 days
Term - 4-6 Months
Start Date - ASAP
Our client, a top-tier management consulting firm, has partnered with a leading Financial Services provider to hire a Data Analyst (Power BI & SQL).
Required Skills and Qualifications
Skills Needed : SQL, Data Warehousing, Data Modeling, Star + Snowflake Schemas, Power BI, ETL, Manipulating large data sets, etc
- 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 initiativesLeverage SQL to query, transform, and optimize large datasets for reporting and analysisBuild and enhance Power BI dashboards and reports, applying UX and data visualization principles to ensure clarity and usabilityImplement and manage ETL processes to ensure data accuracy, consistency, and reliability across systemsCollaborate with business stakeholders to gather requirements, define KPIs, and deliver actionable insights that drive decision-makingApply data warehousing concepts such as dimensional modeling and star / snowflake schemas to structure data efficientlyPartner with data engineers, analysts, and business teams to ensure seamless data integration and reporting workflowsTroubleshoot data quality issues, identify process improvements, and ensure data governance standards are upheldPreferred Experience
Experience working in cross-functional data environmentsFamiliarity with other data visualization or ETL tools is a plusBackground in business analysis, data engineering, or analytics consulting