Data Analyst

SGS Consulting; Phoenix (AZ); On-site; USD 120,000 - 160,000; Full time

Job summary

SGS Consulting in Phoenix, AZ seeks a data analytics engineer to design, implement and support analytics solutions that provide insights to drive better decisions. You will work with source data teams and product owners to deliver scalable Azure-based data pipelines and reporting capabilities.

You will own parts of the DevOps lifecycle, contribute to CI/CD, data modeling, testing and production support, and mentor others to build multi-functional teams while upholding data privacy and security

Qualifications

• Bachelor's degree required.

Responsibilities

• Work with source data teams and product owners to design, implement and support analytics solutions.
• Implement data migration and data engineering using Azure and traditional data warehouse tools.
• Handle design, cloud engineering, ingestion, modeling, testing, CI/CD, and production support.
• Provide technical leadership and collaborate in a team while also working independently.
• Be part of a DevOps team that owns and supports the product.
• Implement batch and streaming data pipelines using cloud technologies.
• Lead coding standards, best practices, and privacy/security guidelines.
• Mentor others to create multi-functional teams.

Skills

Azure Data Factory

Azure Databricks

Azure DevOps

Azure Blob Storage

Azure Data Lake

Python

SQL

Spark

Unix

Teradata

Cassandra

MongoDB

Oracle

SQL Server

Snowflake

Grafana

Tableau

Power BI

Cognos

Alteryx

Denodo

GitHub

Jenkins

Terraform

Databricks

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Databricks

Azure DevOps

Power BI

Tableau

Cognos

Denodo

Grafana

Teradata

MongoDB

Snowflake

SQL Server

Oracle

Python

Job description

Job Responsibilities:

• Work closely with source data application teams and product owners to design, implement and support analytics solutions that provide insights to make better decisions
• Implement data migration and data engineering solutions using Azure products and services: (Azure Data Lake Storage, Azure Data Factory, Azure Functions, Event Hub, Azure Stream Analytics, Azure Databricks, etc.) and traditional data warehouse tools.
• Perform multiple aspects involved in the development lifecycle - design, cloud engineering (Infrastructure, network, security, and administration), ingestion, preparation, data modeling, testing, CICD pipelines, performance tuning, deployments, consumption, BI, alerting, prod support.
• Provide technical leadership and collaborate within a team environment as well as work independently.
• Be a part of a DevOps team that completely owns and supports their product
• Implement batch and streaming data pipelines using cloud technologies
• Leads development of coding standards, best practices and privacy and security guidelines.
• Mentors others on technical and domain skills to create multi-functional teams.

Skills:

Azure Data Factory, Azure Databricks, Azure DevOps, Azure Blob Storage, Azure Data Lake, Azure Power Apps and Power BIPython, Spark, Unix, SQLTeradata, Cassandra, MongoDB, Oracle, SQL Server, ADLS, Snowflake, Azure Data ExplorerCI/CD: GitHub, Jenkins, Azure DevOps, TerraformBI Analytics Tool Stack - Cognos, Tableau, Power BI, Alteryx, Denodo, and Grafana

Education/Experience:

Bachelor's