Database/Web Administrator

Role: Database/Web Administrator

Location: Phoenix AZ

Duration: Long term contract

Skills: Data Analytics, ETL - Big Data/Data Warehouse, MS SQL, Python, SQL

This role needs to oversee a data lake utilizing a Microsoft SQL Server. They will be responsible for creating queries to integrate a multitude of data sources on a regular basis, working with large amounts of data and optimizing that data for efficient consumption.

Key Responsibilities

• Oversee data governance, transformation, analysis and administration of data
• Normalize redundant data within legacy systems to improve tracking capabilities and enable reporting through measurable performance metrics
• Design and execute complex SQL Queries across multiple databases to perform data validation and ensure data integrity
• Collaborate with cross-functional stakeholders and business/product teams to define requirements, manage change requests and support implementation.

Skills & Attributes

• Technical Expertise
• Extensive experience with SQL, preferably in the context of interfacing with a Microsoft SQL Server.
• ETL (Extract Transformer Load) familiarity in a working environment.
• Hands-on experience with data warehouses.
• Analytical Skills
• Ability to work with large datasets, spot trends, and create actionable insights.
• Proven track record of producing clear, meaningful reports and dashboards.
• Problem-Solving
• Exceptional analytical, critical thinking, and troubleshooting skills.

Tool-Specific Competencies

• Required: SQL, data warehousing experience, ETL (Extract Transformer Load), SQL Server administration
• Preferred: Python, Powershell, Analysis experience, SQL Development Certification