IT Business Analyst

S2 IT Group; Alpharetta (GA); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Employee referral program

Job summary

S2 IT Group in Alpharetta, GA, seeks a data visualization and data engineering professional to build KPI dashboards across sales, finance, and marketing, validate DWH tables in TA Data Lake and AWS Postgres, and maintain data pipelines.

You will develop dashboards in Tableau and Power BI, automate validations with Python, and design Airflow DAGs for dimensional data and reporting. Collaboration with vendors and internal teams is essential.

Qualifications

• Master's Degree in Information Technology and Management or equivalent.
• Experience with data warehousing, ETL, and analytics.
• Strong SQL and data integration knowledge.

Responsibilities

• Develop data visualization KPI dashboards across sales, finance, and marketing.
• Validate DWH tables in TA Data Lake (AWS Postgres and Hadoop).
• Build Tableau dashboards for monthly and quarterly revenue insights.
• Create Python automation scripts for DWH validation.
• Develop Airflow DAGs for data dimensions and reporting.
• Monitor Airflow DAGs in Dev/Test/Model environments.
• Coordinate with third-party vendors and internal teams; support CRP/FAT/UAT.

Skills

Data visualization

Python scripting

ETL processes

Airflow orchestration

Data quality

DWH validation

Stakeholder coordination

Education

Master's degree in Information Technology and Management

Tools

Tableau

Power BI

SQL

Airflow

Informatica

Pentaho

SSIS

Spark

Hive

Snowflake

Teradata

Job description

Develop data visualization KPI’s for business enhancement operations across sales, finance, and marketing departments. Perform validation of DWH Tables in TA Data Lake- AWS Postgres and HadoopCluster. Operate and maintain Glance TV to track payment count, (confirmed, approved) visits, and other business metrics to track Sonic Order Ahead business. Build periodical Tableau Dashboard which provides insights about monthly and quarterly revenue. Assist Marketing team in constructing ETL workflows and Customer loyalty models. Create Python automation scripts to validate DWH definitions. Develop data flows in Airflow DAG for dimensions data, dashboard reporting, and data science research. Monitor and test Airflow DAGs in Dev/Test/Model Environment during the process of loading DWH Tables to DATA LAKE. Implement best suitable practices for data (movement, quality, cleansing), and other ETL activities. Discuss resolution process and responsible for defect turnaround within SLA. Work with third party vendor development, project management teams and test data moved from Legacy Systems. Coordinate with Oracle Corporation core support team on various issues, provided bug logs and custom code details. Execute CRP’s/FAT and UAT by business users. Log, view, access, follow up and close Service Requests (SRs) online. Required tools and technologies: Oracle EBS, Infor, UltiPro, Informatica, Pentaho, SSIS, Power BI, SSRS, AWS, SQL, Athena, Spark, Braze, Hive, Snowflake, Teradata, XML Eclipse, Putty, Oracle (OAF, SOA).

Other: Full Time. Travel involved to unanticipated client locations within US.

Requirements: Master's Degree in Information Technology and Management or Equivalent. Any suitable combination of education, training or experience accepted.

This position is eligible for our employee referral program