Data Analyst

American IT Systems

Alpharetta, GA

JOB DETAILS
SALARY
$65–$68
SKILLS
Agile Programming Methodologies, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Apache Hadoop, Apache Spark, Atlassian JIRA, Automation, Big Data, Bug Tracking/Defect Management, Business Intelligence, Business Intelligence Software, Business Support, Cloud Computing, Cloud Storage, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Customer Relations, Data Analysis, Data Lake, Data Management, Data Processing, Data Quality, Data Storage, Database Extract Transform and Load (ETL), Database Programming Languages, DevOps, Ecosystems, GCP (Good Clinical Practices), GitHub, Hewlett-Packard Product Family, Internet of Things, Leadership, Linux Operating System, Looker, Metrics, Microsoft SQL Server, Microsoft Windows Azure, Microsoft Windows Operating System, Multiplatform/Cross-Platform, MySQL, NCR Teradata, Offshoring, Operating Systems, Oracle PL-SQL, Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Python Programming/Scripting Language, Quality Management, Quality Metrics, Quality Monitoring, Query Optimization, Reconciliation, Reporting Dashboards, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Scrum Project Management and Software Development, Source Code/Configuration Management (SCM), Storytelling, Tableau, Technical Writing, Use Cases
LOCATION
Alpharetta, GA
POSTED
1 day ago

Data Analyst

Alpharetta, GA-Equifax

Rate :: 60-67/hr on C2C max

Must have skills.
SQL
Python
Azure AWS
Job Summary

We are seeking a highly skilled Data Analyst with strong expertise in data analytics, business intelligence, and big data platforms to support data-driven decision-making across stakeholders.

The ideal candidate will have hands-on experience with SQL, Python, cloud data platforms, BI tools, data quality practices, and modern data pipelines, working closely with business and technical teams in an Agile offshore-onsite model.

Key Responsibilities

  • Data Analytics & Business Intelligence Design, develop, and maintain Looker dashboards, LookerML models, and KPI frameworks to support business objectives.
  • Perform ad-hoc data analysis and generate insights for stakeholders, leadership, and client teams.
  • Translate business requirements into analytical solutions and clear visual storytelling.
  • Support stakeholder reporting using Looker, Tableau, and Power BI. Data Management & Databases
  • Write complex and optimized queries using SQL, Advanced SQL, PL/SQL, and PySpark for data extraction, transformation, and analysis.
  • Work across multiple database platforms including Google Big Query, SQL Server, Teradata, Azure SQL DB, MySQL, Redshift, and Big Query DB.
  • Perform data validation, reconciliation, and discrepancy analysis across multiple data sources.
  • Optimize query performance using indexes, temp tables, and partitioning techniques.
  • Data Quality & ETL Monitor and maintain data quality metrics, perform root-cause analysis, and drive resolution of data issues.
  • Support and understand ETL/ELT pipelines built using: Azure Data Factory Azure Databricks Delta Lake AWS Glue Azure Data Pipelines Work with Data Lakehouse architectures using Azure Data Lake Storage and cloud-native platforms.
  • Ensure consistency and accuracy of data across ingestion, transformation, and analytics layers.
  • Programming & Automation Use Python for: Data analysis and transformation Data validation and reconciliation Basic automation and scripting Leverage PySpark and Spark frameworks for large-scale data processing.
  • Support streaming and event-driven data use cases using Kafka where applicable. Big Data & Cloud Technologies Work within the Big Data ecosystem including Spark, Hadoop, PySpark, Kafka.
  • Build and analyse data pipelines across Azure, AWS, and GCP, including: Azure Synapse Analytics AWS S3, Redshift Google BigQuery and Google Data Studio Support integrations using Azure Logic Apps, IoT Hub, and related services as needed.
  • Tools, DevOps & Methodologies Track requirements, defects, and enhancements using JIRA and HP ALM.
  • Maintain technical documentation using Confluence.
  • Participate in Agile/Scrum ceremonies, working in a global offshore-onsite model.
  • Use Azure DevOps, GitHub, and CI/CD pipelines for version control and deployment support.
  • Required Skills & Qualification

Programming & Query Languages Strong expertise in SQL (Advanced SQL)
Proficiency in Python and PySpark Analytics & Visualization
Hands-on experience with Looker (LookerML), Power BI, and Tableau Strong understanding of KPI design and business metrics
Data Engineering & Processing Experience with Azure Databricks, Azure Data Factory, Delta Lake Familiarity with Data Lakehouse architectures .
Strong data quality, data reconciliation, and validation skills Big Data & Cloud Platforms Experience with Spark, Hadoop, Kafka
Cloud exposure across: Azure AWS (Glue, S3, Redshift) GCP (BigQuery, Google Data Studio)
Databases Azure SQL DB, SQL Server, MySQL, BigQuery, Teradata, Redshift
Operating Systems Linux and Windows DevOps & Tools Azure DevOps, GitHub, CI/CD pipelines JIRA, Confluence, HP ALM
Preferred Qualifications Experience supporting enterprise or client-facing analytics programs
Strong ability to work with cross-functional technical and business teams Experience in offshore-onsite delivery models
Strong communication and stakeholder management skills

About the Company

A

American IT Systems