Home

Siddharth - Data Analyst & Power Bi Developer

[email protected]

Location: Beltsville, Maryland, USA

Relocation: Yes

Visa: H1B

Goal-oriented Software Consultant with 12 years of experience in planning and managing the implementation of software data models for Healthcare, banking, and e-commerce clients. Design and build dimensional data models in Power BI Desktop, optimizing performance and scalability. Develop complex data transformations using Power Query M language, handling various data sources and formats. Implement advanced modeling techniques like calculated columns, measures, and hierarchies. Create and manage relationships between tables to ensure data consistency and accuracy. Data Visualization and Reporting: Design impactful and informative dashboards and reports using Power BI visuals and formatting options. Implement advanced visualization techniques like custom visuals, drilldowns, and storyboards. Apply best practices for data storytelling and user experience optimization. Develop dynamic reports with interactive filters, slicers, and other user controls. Power BI Administration and Governance: Manage Power BI Service workspaces and user access controls. Configure gateways and data refresh schedules for automated data updates. Monitor and troubleshoot performance issues in Power BI reports and dashboards. Implement version control for Power BI artifacts using tools like git. Conduct user training and provide ongoing support for Power BI adoption within the organization. Data Integration and Connectivity: Connect to various data sources like relational databases, cloud platforms, flat files, and APIs. Develop and maintain data pipelines using Power BI Desktop and other integration tools. Perform data mapping and transformation to ensure data consistency across disparate sources. Troubleshoot connectivity issues and optimize data refresh performance. Leverage knowledge of star and snowflake schemas to optimize data models for efficient querying and analysis. Utilize proficiency in SQL queries, SQL Agent jobs, and stored procedures for data extraction, manipulation, and automation. Integrate Power BI with other tools like Power Automate, SharePoint, ServiceNow reports, and AMDB for comprehensive data analysis and reporting workflows. Understand REST APIs and authentication methods and apply data security principles for secure data access and governance. Skills Client Relationship Management Software Development Power BI Business Objects (BOBJ) SQL Data Querying Data Validation Performance Testing Data Visualization Data Modeling - Data Analysis Oracle DB Snowflake DB Agile and JIRA Strategic Project Planning Row level Security Software Configuration Workflow Optimization Data Modeling Business Requirements Gathering Python ServiceNow Software Design Tech Support Software Testing Database Management Compiling Data Linux Operating System Continuous Process Improvement Database Analysis Microsoft SQL Data Testing Data Conversion and Migration Database Development Keywords: business intelligence database