| Urgent Position :: Business Intelligence Developer :: Remote ::: GC or US Citizen or EAD Only at Remote, Remote, USA |
| Email: [email protected] |
| From: Vinita Singh, Tek Inspirations [email protected] Reply to: [email protected] Job Description - Client: Kinetic Role : Business Intelligence Developer Location : Remote Visa : Only GC/US Citizen or EAD Must: Migrating exp of PowerBI Reports from one environment to another. Azure Datalake, Datawarehouse, Azure Synapse Skills: Kinetic is looking for a Business Intelligence Developer / Cloud DBA resource to help with migrating their PowerBI reports from one environment to another. Versed in PowerBI and SQL. Ideally, they will have worked in Azure Data Lake/Data Warehouse environments. Experience with Azure Synapse Please check below Sample Resume. BUSINESS INTELLIGENCE DEVELOPER, DATA ENGINEER AND ANALYTICS EXPERT 7+ years of BI and Data Warehousing Experience: Expert in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) along with extensive Data Warehousing knowledge. 7+ years of Database Programming Experience: Expert in writing T-SQL stored Procedures, Triggers, Constraints and Indexes using various DDL and DML commands. Experience in Power BI Desktop and Power BI report server. Proficient in designing and developing MS-Access database, and RDBMS with SQL, Extensive experience on REST Web Service API for remotely interacting with RDBMS databases. Developed Python Functions and Arguments and worked with Python Modules and packages. Strong track record of building data engineering pipelines using Python,SQL, and Spark on cloud platforms such as Azure and Databricks, and building data lakes and data warehousing using technologies like Azure Data Lake Storage, ADF Data Flow, ADF Pipeline, and Azure Synapse. DB Migration Experience to Microsoft Azure: Developed tools to deploy, manage, monitor and troubleshoot database systems on-premises or in public cloud. Migrated databases to Azure and worked with strategic customers as an advisory architect and developer addressing significant scale/volume/complexity. Mentored team members on Cloud Technologies. Business Development and Client Relationship: Significant experience in Client Relationship and business development for small businesses and customer support for various organizations including a bank. Earned Customer Relation Experience for customer leadership program. Problem Solving and Project Management: Excellent trouble shooting abilities and have the capabilities to solve problems correctly and effectively. Managed multiple technical projects through phases from inception to completion. WORK EXPERIENCE Data loss Prevention Data Analytics and Report Developer, Microsoft, September 2023- Present Perform data analysis and Generating Insights as per the Business Requirements Develop Dashboards and Reports to deliver actionable insights from business data. Build advanced custom queries and dashboards using PBI, Azure SQL, on prem SQL, and KQL (via LogicApps), including: PBI M-Code, DAX -- measures & calculated columns Advance Data Analytic with SQL Server Development / Query writing Azure Log Analytics workspace services using Kusto Query Language and parsing of JSON data to columns using KQL Develop logic by doing deep analysis to increase data accuracy by 95% instantly. Designed, Built and Analyzed data solutions using Azure Services like Azure Data Factory, Azure Synapse and Azure Databricks services Azure Dev Ops for logging bugs with product teams Data loss prevention rule configuration support Enterprise Data Engineer and Analytics, Envision, June 2022- August 2023 Datawarehouse and SQL Developer: Support development and maintenance of SQL Server Analysis Services data cubes. Evaluate and improve existing BI systems. Design, Build and deploy BI solutions. Develop SQL views and stored procedures as requested by business users. Writing DAX queries and MDX queries Data Analysis and Solution: perform root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement. Regularly audit data to ensure accuracy and identify discrepancies between sources. Conduct unit testing and troubleshooting. Translate business needs to technical specifications. Develop and update technical documentation and Users guides using Confluence. Power BI/SSRS Report Developer: Create, maintain, and administer reporting dashboards using Power BI/SSRS. Maintain users roles and security to provide access for different ad groups. Collibra Application: Work with business and technical teams to implement Collibra Data Governance and Data Quality in enterprise level. Created Rules, Alerts and Schedules for DQ jobs. Support cross functional company initiatives ADF/Synapse/ Databricks: Azure Data Factory integration with Azure Databricks - Accessing a Databricks Notebook with Input and Output Parameters.Read and write data from SQL database table in data bricks. Reading and writing snowflake data from Azure Databricks. Reading and Writing AWS S3 data from Azure data bricks using mount point. Copied data from on premise SQL Server to Data Lake Storage Gen2. Loaded data from on premise File system to ADLS Gen2. Data Engineer and Analytics, The Leading Hotel of the World, November 2021- May 2022 (6 months Contract) Analyzed /Processed and developed business logics working in Amazon, Redshift Environment / Used DBeaver SQL Client Software App and My SQL Relational Database Management System (RDMS) to process data. Improve quality of data to achieve revenue accounting accuracy for all business segments. Develop logic by doing deep analysis to increase data accuracy by 50% instantly. Generated Tableau dashboards using parameters, calculated fields, groups, sets and hierarchies etc. that allowed to track business for accurate revenue calculation by 12% within a month. Improved business decision making by optimizing data warehouse. Remove data warehouse redundancy by 80% Sr Developer/Architect, SQL Server/Business Intelligence, Archdiocese of New York, 2013 2020 SSRS : Designed, developed and maintained companys business intelligence solution using SSRS reports, dashboards, analytics and charts for internal customers. Interacted with staffs, vendors, and partners to determine business needs, and support decision making. Created and maintained SSRS reports that align data from multiple data sources to meet business requirements. Configured and maintained Report Manager and Report Server for SSRS SSIS : Designed and Implemented data Loading (ETL) and publishing processes within the DW/BI environment. Extensively involved in designing the SSIS packages to export data of multiple sources to SQL Server database. Worked on all types of reports like Parameterized, Matrix, Charts, Sub Quires, Drill Down, Drill Through, Gauge Control and more. Involved in creating SSIS jobs to automate the reports generation, cube refresh packages. SSAS : Designed and implemented multi-dimensional models, including the construction of Data View, Dimensions, and Cube. Expert in writing MDX quires with extensive experience in creating and customizing Cubes using SQL Server Analysis Services 2017/2019 T-SQL : Created and maintained databases, tables, views, indexes, check constraints, and business rules using T-SQL. Involved in Migration of databases of SQL Server 2000 to SQL Server 2017. Wrote stored procedures, views, and functions. Addressed potential blocking and deadlocking situations. Power BI : Designed and developed Power BI solutions with Dashboards/Reports & Power Bi Visualizations writing Data Analysis Expressions (DAX). Prepared interactive Dashboards with fully dynamic charts using calculations, parameters which delivers deep insights on the data. Imported data to Power BI from other services using REST APIs and automate Power BI dashboard by scheduling a refresh data. Connected and fetched JSON data to Power BI using REST API, Used Rest API for custom applications to automate some configurations for a Power BI service solution and extend the solution to another level. Azure : Manage Azure AD objects and role-based access control (RBAC). Automate deployment and configuration of VMs. Read and write data from data lake storage Gen2. Manage data in Azure Storage, Loaded data from different Rest API ' to ADLS Gen 2 with For Each loop. Developed function to read and write to Synapse DW from data bricks using polybase. Data Warehouse Developer, SETFOCUS, 2012 2013 Translated business requirements into technical design specifications using Visio to design ERD schema. Normalized data fields to meet the business requirements and specifications to build a data mart for various departments into a metadata. Improved data quality by up to ninety five-percent on most measures as defined by Business Reporting unit. Designed and Implemented cubes. Analyzed multidimensional cube data through MDX Scripting in SSAS. Developer, Databases/Applications, NYU Langone Medical Center, 2011 2012 Database Developer: Developed a New Grant Database system which automated day-to-day processes, reduced administration costs, increased user productivity and accuracy. Handled database tables, queries and reports, store-procedures, functions, triggers, and other SQL database objects that assist in the implementation of business logic. Applications Development: Created, administered, and analyzed custom applications, forms and electronic surveys that saved countless administrative hours and designers/developers cost. Documented all maintenance actions, process changes, configurations, and troubleshooting procedures. Custom Reporting: Designed, developed, and supported standardized and customized reports that are easy to use, scalable and manageable across the organization. Increased accuracy of the report by 50% compared to previous SPA Report System and saved millions of dollars instantly IT Support and Maintenance: Supported internal and external clients. Managed IT maintenance, software updates and system integrity. Identified, analyzed, and implemented process improvement measures. Administered third party application, users, groups and security. Communicated to executives and customers. Database Admin, Special Funds Conservation Committee, 2009 2011 Administered Oracle based Star system, managed users, role-based security and access policies. Managed system design and functions required by various team members. Created new technical documentations and helped improve companys process and operational efficiency and achieve its corporate objectives. Improved productivity of end users by conducting technical trainings in 4 locations on database system, advanced Excel/PowerPoint/Outlook Designed and created custom reports using SQL based on business and clients needs. Downloaded daily exceptions, handled encryptions, uploaded information in the databases. E: [email protected] Thanks and Regards, Keywords: business intelligence sthree database active directory information technology green card microsoft Urgent Position :: Business Intelligence Developer :: Remote ::: GC or US Citizen or EAD Only [email protected] |
| [email protected] View all |
| Wed Sep 18 18:53:00 UTC 2024 |