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 ExpertiseExtensive 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 SkillsAbility to work with large datasets, spot trends, and create actionable insights.Proven track record of producing clear, meaningful reports and dashboards.Problem-SolvingExceptional analytical, critical thinking, and troubleshooting skills.Tool-Specific Competencies
Required : SQL, data warehousing experience, ETL (Extract Transformer Load), SQL Server administrationPreferred : Python, Powershell, Analysis experience, SQL Development Certification