Senior BI Analyst

R00206007

• Strong SQL
• Power BI DAX, Develop and maintain data models and ETL processes using Power BI tools such as Power Query and Power Pivot,
• Expertise in Power BI Desktop, Power Query, Power Pivot, DAX, and other Power BI tools and features
• Able to Create Dynamic Partition process for SSAS Tubular Cube.
• SSIS and its variables and expression to create dynamic partition process.
• In SSIS having knowledge on annotating package, grouping task, precedence constraints, connection manager, send mail task, ftp task, data profiling task, lookup transformation , event handlers.
• Created it in multiple data sources in MS SQL.
• Created SSRS Report
• Creating or updating SSIS Packages, MS SQL Queries, procedure, dynamic query, DW Database, SSAS Tabular, Power BI Reports.
• Data ingestion through creating / modified SSIS packages for daily runs by using checkpoints, if it failed triggered an email to developer team and rectified by using log and reverse engineering.
• ETL ingestion divided into 3 parts: Source to stagging tables, stagging table to DW (Fact & Dim Tables), DW to SSAS services (incremental refresh or default refresh)
• create / modified SSIS catalogue, Jobs Scheduling, optimizing SSIS packages.
• create / modified ETL, Jobs Scheduling through corn tab, optimizing packages.
• Write complex SQL queries/ procedure by using recursive cte, inner queries, joins and optimized it
• Create / modified SSAS tables, data source, relationship between tables, refresh, dynamic partition creation and processing it.

AAS & ADF good to have at least have basic knowledge and understand or went through training on these Skills:

• Develop and maintain Azure Analysis Services and Azure Data Factory solutions.
• Design and implement ETL processes to move data from various sources to Azure Analysis Services.
• Design and implement multidimensional and tabular data models using Azure Analysis Services.
• Develop and implement Azure Data Factory pipelines for data movement and transformation.
• Troubleshoot and resolve issues related to Azure Analysis Services and Azure Data Factory.
• Work closely with business users to understand their requirements and translate them into technical solutions.
• Provide technical guidance and support to team members and stakeholders.

Stay up to date with the latest Azure technologies and industry trends.Our Commitment to Diversity and InclusionAt Ecolab, we believe the best teams are diverse and inclusive, and we are on a journey to create a workplace where every associate can grow and achieve their best. We are committed to fair and equal treatment of associates and applicants. We recruit, hire, promote, transfer and provide opportunities for advancement on the basis of individual qualifications and job performance. In all matters affecting employment, compensation, benefits, working conditions, and opportunities for advancement, we will not discriminate against any associate or applicant for employment because of race, religion, color, creed, national origin, citizenship status, sex, sexual orientation, gender identity and expressions, genetic information, marital status, age, disability, or status as a covered veteran.In addition, we are committed to furthering the principles of Equal Employment Opportunity (EEO) through Affirmative Action (AA). Our goal is to fully utilize minority, female, disabled and covered veteran individuals at all levels of the workforce. Ecolab is a place where you can grow your career, own your future and impact what matters.