Cloud IT Business Analyst

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

Job summary

A technology services firm in Alpharetta, GA is looking for a Data Engineer to develop data visualization KPIs and design Tableau Dashboards for operational enhancements. Responsibilities include creating Python scripts for automation, managing Airflow DAGs, and collaborating with third-party vendors. A Master's in Information Technology is required, along with expertise in data visualization tools like Tableau, PowerBI, and Informatica. This position is full-time and may require travel to client sites across the U.S.

Qualifications

• Master's Degree in Information Technology and Management or equivalent required.
• Experience in data visualization and reporting tools.
• Familiarity with ETL processes and automation scripts.

Responsibilities

• Develop data visualization KPIs for business operations.
• Create Tableau Dashboards for financial insights.
• Automate processes using Python and monitor Airflow DAGs.

Skills

Data Visualization

Python Automation

ETL Workflows

Data Quality Management

Reporting

Education

Master's Degree in Information Technology and Management

Tools

Tableau

AWS

SQL

PowerBI

Informatica

Job description

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 handle 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, providing 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, PowerBI, 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 the U.S.

Requirements

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

Location

Alpharetta, GA