We are seeking a detail-oriented Data Warehouse Developer and Analyst with
specialized skills in SQL and Power BI to join our data analytics team. This role is ideal
for a professional with 1-2 years of experience in business analysis, data manipulation,
and report development. You will be responsible for transforming raw data into
actionable insights that drive strategic business decisions while building sophisticated
reports and dashboards for various stakeholders.
Job Responsibilities
Data Analysis & SQL Development
- Write complex SQL queries to extract, manipulate, and analyze data from
multiple databases
Develop and maintain stored procedures, views, and functionsPerform data validation, cleansing, and quality assuranceOptimize SQL queries for performance and efficiencyCreate automated data extraction processes and ETL workflowsCollaborate with database administrators to ensure data integrityPower BI Report Development
Design and develop interactive dashboards and reports using Power BIDesktop
Create and maintain Power BI datasets and data modelsImplement DAX calculations for advanced analyticsPublish reports to Power BI Service and manage workspace permissionsSchedule automated data refreshes and monitor report performanceCreate custom visualizations and implement best practices for dashboarddesign
Business Analysis & Requirements Gathering
Work with stakeholders to understand business requirements and translatethem into technical specifications
Conduct data discovery sessions to identify key metrics and KPIsPerform gap analysis and recommend solutions for business challengesDocument functional requirements and create user storiesFacilitate workshops and requirements gathering sessionsCreate process flow diagrams and business process documentation