Iron Mountain
Location
Bangalore | India
Job description
ABOUT THE OPPORTUNITY... Iron Mountain Data Centers is looking to hire a Data Analyst II to join our global Data Enablement team. You will take shared responsibility for the enablement, maintenance, troubleshooting, and operational support of our data platform. To succeed in this role you will need an eye for detail, ability to think clearly, calmly, and methodically while driving break fix opportunities to incident resolution; the ability to methodically diagnose and perform root-cause-analysis on data, systems, and reports; ability to support critical data warehouse processes, jobs, pipeline, and tools; have a basic understanding of data management framework; and be willing to learn how to consistently deliver data to end users via the data platform toolset.
Responsibilities: ● Drive and coordinate completion of power billing transactional processes as top priority ● Own, execute, and coordinate end-to-end delivery of customer-facing reporting ● Provide break-fix and monitoring support for the data warehouse ● Create T-SQL queries that fulfill ad hoc data delivery service requests ● Administer Tableau and Microsoft SSRS applications; user security, training, release management ● Support end-to-end ETL processes via Microsoft SSIS pipelines from collection to visualization ● Assess and remediate issues with data loads, reports, views, systems and delivery tools ● Leverage business process automation tool (ActiveBatch) for job scheduling and monitoring ● Verify and implement controls that ensure accuracy, completeness, and quality of data loads ● Gather data and produce platform metrics and telemetry on a consistent basis ● Test and validate data solutions, systems, pipelines, and presentation layer offerings ● Own and update production data catalog documentation, metadata, procedures, and artifacts ● Support data integrations across platforms, interfaces, tools, and multiple network domains Key Skills, Requirements and Competencies: ● Strong knowledge and expertise using and supporting the Microsoft BI stack ● Experience maintaining, and delivering data and reporting via various tools and platforms ● 2 years of Microsoft T-SQL scripting experience; must be able to create advanced queries ● 2 years of systems operations experience directly supporting data warehouse initiatives ● 2 years of support or server administration experience with Microsoft SQL Server 2016 or above ● 2 years of experience supporting or administering production Microsoft SSRS report portal ● Experience supporting or administering a production application environment (eg. Tableau) ● Expert troubleshooting ETL processes, SSIS packages, T-SQL queries, and complex SQL joins ● Ability to multitask, pivot, refocus, and thrive in an interrupt-driven production support environment ● Strong communicator, a positive attitude, and a passion for customer-facing delivery ● Knowledge of ITIL v3 framework and service management processes ● Make decisions confidently, independently, and assume level-2 responsibility in critical situations ● Self manage and organize to multiple tasks with rapidly changing priorities and deadlines ● Participation in a 24x5 on-call support rotation ● Professional certification or degree in IT discipline or equivalent DWH hands-on experienceJob tags
Salary
