Experience with SQL Server 2014 or 2016, SQL, and extract, transform, and load (ETL) processes.
Strong skills with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and COSMOS.
Knowledge of Power BI.
Strong data analysis skills and the ability to draw business conclusions from data and connect scenarios.
Strong knowledge of Excel, including PivotTables, Power Pivot, and charts.
Understanding of data management and business intelligence concepts, data analysis, analytics, cubes, reporting technologies, and ETL.
Ability to work with ambiguity and in an agile environment.
Hands-on experience with SharePoint.
Strong troubleshooting skills.
Responsibilities
Troubleshoot complex data-related issues escalated from Tier 1.
Resolve data discrepancies and provide business intelligence insights.
Understand data lineage, data quality, and data relationships.
Monitor data extract, transform, and load (ETL) jobs and respond to job failures.
Provide development support for platforms and applications as assigned by the designated manager.
Document knowledge base articles for Tier 1 and Tier 2.
Dedicate 20–25% of time to development efforts, including automating operational activities, performing data quality checks, developing application features and tabular models, fixing bugs, and reporting.
Perform data engineering activities.
Provide support for production issues during off hours.
Desired Qualifications
Prior experience in the Microsoft ecosystem is preferred.
Ability to communicate effectively.
Attention to detail.
Job Description
Troubleshoot complex data related issues escalated from Tier 1
Solving data discrepancies and providing business intelligence insights.
Understand data lineage, data quality and relationships
Monitor data extract, transform, and load (ETL) jobs and respond to any job failures.
Development Support for platforms and applications as assigned by designated manager
Document knowledge base articles for Tier 1 and Tier 2
Dedicate 20-25% of time for Development efforts – Automation of operational activities, data quality checks, application feature development, develop tabular models, bug fixes and reporting
Perform data engineering related activities
Flexibility to support production issues during off hours.
Qualifications
SQL Server 2014/16, Good SQL & ETL skills
Strong on SSAS, SSIS & COSMOS
Good knowledge of PowerBI
Strong data analytical skills
Ability to make business conclusions from data, connect scenarios
Strong knowledge on Excel – Pivots, PowerPivots, Charts
Other Skills:
Understanding Data Management & BI concepts, Data Analysis, Analytics, Cubes, Reporting Technologies, ETL
Prior experience in Microsoft landscape is preferred
Ability to deal with ambiguity and work in agile environment.
Excellent communications skills
Attention to detail
Strong troubleshooting skills
Hands on experience with SharePoint
Additional Information
All your information will be kept confidential according to EEO guidelines.