| USC GC LOCAL TO TEXAS Senior BI Developer at Remote, Remote, USA |
| Email: pankaj.upadhyay@adventatech.com |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1694654&uid= From: pankaj Upadhyay, adventa pankaj.upadhyay@adventatech.com Reply to: pankaj.upadhyay@adventatech.com Job Description - Senior BI Developer local & Hybrid to Austin or Irving TX USC/GC only ( With LinkedIn ) Senior BI Developer (SQL BI / PowerBI) will be responsible for the current / future data warehouse, BI solutions, and data migration strategies. The Senior BI Developer (SQL BI / PowerBI) will design database architectures, data warehouses, data migrations, data marts, BI packages, and implement user reporting solutions. The Senior BI Developer (SQL BI / PowerBI) must possess a strong understanding of database methodology, data analysis, advanced SQL queries, ETL, and business intelligence applications. Implement New BI / Data Warehouse Requirements - SQL / ETL / BI Tools / Database Development / Reporting Interface with Customers / Technical Leaders - Identify Scope / Vet Requirements / Identify Effective Reporting Strategies / Identify Best Data Sources for Reach Report Field / Identify Risks and Constraints / Design Reporting Formats, etc. Lead Internal Business Partner / External Third Party Team Meetings Develop / Implement / Maintain ETL Solutions - Bringing New Data into Data Warehouse Develop Optimized Database Design / Achieving Acceptable Performance - Tuning Views / Indexes for Proper Response Time, etc. Develop New Capabilities / Architectures that Capitalize on Client Portal Development / Ad-Hoc BI Capabilities Collaborate with Business Analysts / Data Engineers - Understand Data Requirements / Design ETL Solutions Respond to Ad-Hoc Query Requests from Product / Vendor and Professional Services / Finance Departments Perform Full Lifecycle Data Warehouse / ETL / Business Intelligence Solution Development / Maintenance Perform Data Analysis - Determine Root Cause of Data Integrity / Quality Issues Identified via QA / Business Report Owners, etc. | Analyzing Data Sets (advanced) Provide Guidance / Recommendations on BI Reporting Packages - Adjusting Systems / Processes to Prevent Issue Reoccurrence, etc. MS SQL BI Stack (expert) - SSRS (Reporting Services) / SSIS (Integrated Service) / SSAS (Analysis Services) Data Warehouse Solution Implementation - Developing SSAS / MDX (hands-on) for Implementations Experience Supporting Month End Financial Reporting Process / Business Processes / Technologies Effectively Communicating / Presenting to All Levels of Business - Explaining Complex Issues / Concepts in Simple / Understandable Language Analyze / Resolve Complex Technical Problems - Data Load Issues / System Response Time / Business Rule Conflicts, etc. Expertise in Identification of Business / Data Requirements - Converting into Conceptual / Logical Data Models JOB REQUIREMENTS Senior BI Developer (SQL BI / PowerBI) (8+ years) - SSIS / SSRS / SSAS (MDX) / PowerBI SQL Server - Complex T-SQL Querying / Stored Procs / Functions / Triggers / Views, etc. T-SQL Querying (hands-on / advanced) - Writing Complex T-SQL / Expertise Optimizing T-SQL for Performance and Efficiency SSIS (Integrated Services) - Design / Develop / Maintain Packages to ETL Data from Various Sources | Optimize Packages for Performance / Scalability | Troubleshoot / Resolve Data Integration Process Issues SSAS (Analysis Services) - Design / Develop Cubes / Data Source Views / Named Queries / Dimensions / Deploying SSAS Projects | Hands-on MDX Query Development to Create / Customize Cubes PowerBI / SSRS (Reporting Services) - PowerBI Development / Data Modeling / DAX Calculations / PowerQuery | Design / Map Data Models to Shift Raw Data into Meaningful Insights | Build Interactive / Visually Appealing PowerBI Dashboards / Reports | Maintain SSRS / PowerBI Reports / Dashboards | Write Data-Driven SSRS Reports | Design / Develop New SSRS Reports | Study / Analyze Understand Business Requirements in Context to Business Intelligence Data Modeling - Logical / Physical / Conceptual Data Modeling (hands-on) | Designing / Mapping Data Models Dimensional Data Modeling / Star / Snowflake Schema Experience Database Design Principles / Performance Tuning / Index Strategies / Query Optimization Backup and Recovery / HA Solutions / Security Measures Keywords: quality analyst business intelligence active directory green card microsoft Texas USC GC LOCAL TO TEXAS Senior BI Developer pankaj.upadhyay@adventatech.com http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1694654&uid= |
| pankaj.upadhyay@adventatech.com View All |
| 12:21 AM 27-Aug-24 |