What are the responsibilities and job description for the Lead Data Analytics Engineer position at AGM Tech Solutions - A Woman and Latina-owned IT Staffing Firm-an Inc. 5000 company?
AGM Tech Solutions, on behalf of the Client is hiring:
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. 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 (pref 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
- Tableau Prep
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.
Soft Skills:
• Strong Communication verbal & written • Problem solving • Time management.
Education:
• Bachelor's degree or will look at equivalent experience in lieu of education (8 years)