Lead Data Analytics Engineer

AGM Tech Solutions - A Woman and Latina-owned IT Staffing Firm-an Inc. 5000 company; Strongsville (OH); On-site; USD 75,000 - 95,000; Full time

Job summary

AGM Tech Solutions is seeking a qualified professional based in Strongsville, OH or Pittsburgh, PA. The ideal candidate will have experience with Business Intelligence tools such as Tableau Desktop and Power BI, and a strong background in data warehouse concepts.

You will be responsible for developing advanced dashboards and analytical reports and working with complex SQL queries. A Bachelor's degree or equivalent experience is preferred.

Experience in banking data applications is a plus, alongside knowledge of ETL processes and Python programming.

Qualifications

• 7+ years of experience in Data Warehouse and BI tools.
• Expertise in crafting complex SQL queries.
• Experience with banking-related data applications.

Responsibilities

• Develop and maintain dashboards using Tableau and Power BI.
• Implement and manage ETL processes from various data sources.
• Collaborate with stakeholders to optimize data flows and inform data strategy.

Skills

Business Intelligence Tools

Advanced SQL Proficiency

Data Warehouse Concepts

ETL Processes

Tableau

Banking Experience

Education

Bachelor's degree or equivalent experience (8+ years)

Tools

Tableau Desktop

Microsoft Power BI

Oracle

Teradata

SQL Server

Python

Job description

W2 only, cannot accept Corp to Corp on this role.

Open to Pittsburgh, PA & Strongsville, OH

Roles/Responsibilities

• Proficiency in Business Intelligence Tools: Hands‑on experience with Tableau Desktop, Tableau Prep, and other BI platforms such as Microsoft Power BI for developing advanced dashboards and analytical reports.
• Data Warehouse Expertise: Strong understanding of data warehouse concepts, data modeling techniques, and end‑to‑end ETL processes.
• Advanced SQL Proficiency: Ability to write, optimize, and troubleshoot complex SQL queries for data manipulation and analysis, with experience with very large data sets in Oracle.
• Experience with Multiple Databases: Practical experience working with major relational database systems such as Oracle, Teradata, SQL Server, and others.
• Prior knowledge of Banking (preferably Regulatory) applications dealing with large data sets.

Requirements

• Advanced SQL Proficiency
• Banking Experience
• Strong understanding of data warehouse concepts, data modeling techniques, and end‑to‑end ETL processes.
• Tableau

Nice to Have

• Axiom
• ETL (Informatica) experience
• Knowledge and experience with DevOps Tools a plus
• Liquidity/14A Regulation; Regulatory Submissions (specifically FR‑2052A)
• Power BI
• Python Programming: Basic to intermediate Python coding skills for automation, data transformations, or advanced analytics.

Education

• Bachelor's degree or equivalent experience in lieu of education (8+ years)