Sr ETL Data Analyst - Diverse Linx
DETROIT, MI
About the Job
ETL Data Analyst
Detroit, MI
Engage directly with business and technology partners to understand objectives to deliver analytic-centric solutions.
Support rapid prototyping activities that will validate business requirements, confirm solution definition and manage risk appropriately.
Works directly with team members from business sectors and the applications development team.
Uses technical knowledge, creativity, and company practices and priorities to obtain solutions to complex problems. Assist in quality assurance and defining testing strategy and risks.
Use judgment, creativity, and sound technical knowledge to obtain and recommend effective solutions.
Overall, 8+ years of experience in ETL development.
Expertise in Analysis, Design, development, support and Enhancements of ETL in data warehouse environment with any of the market available ETL Tool (such as Datastage/Informatica/Talend/SSIS/Abnitio e.t.c). Expertise implementing complex ETL logic with Toolset.
Good Understanding on ETL data load Strategies.
Knowledge/Experience in Data vault Modeling Design/Implementation.
Experience in relational databases with strong SQL Coding skills to create stored procedures/views for complex analytical use cases.
Exposure to Data Build Tool (DBT),Qlik replicate, Snowflake, Airflow, AWS infrastructure, CI/CD pipelines
Troubleshoot and quickly resolve data quality issues, performance issues, database capacity issues, replication and other distributed data issues
Exposure to Python programming
Should be proficient in writing complex SQL queries
Strong analyzing capabilities with an ability to fine-tune report/SQL query performance
Exposure to Auto Finance process would be an added advantage.
Detroit, MI
Engage directly with business and technology partners to understand objectives to deliver analytic-centric solutions.
Support rapid prototyping activities that will validate business requirements, confirm solution definition and manage risk appropriately.
Works directly with team members from business sectors and the applications development team.
Uses technical knowledge, creativity, and company practices and priorities to obtain solutions to complex problems. Assist in quality assurance and defining testing strategy and risks.
Use judgment, creativity, and sound technical knowledge to obtain and recommend effective solutions.
Overall, 8+ years of experience in ETL development.
Expertise in Analysis, Design, development, support and Enhancements of ETL in data warehouse environment with any of the market available ETL Tool (such as Datastage/Informatica/Talend/SSIS/Abnitio e.t.c). Expertise implementing complex ETL logic with Toolset.
Good Understanding on ETL data load Strategies.
Knowledge/Experience in Data vault Modeling Design/Implementation.
Experience in relational databases with strong SQL Coding skills to create stored procedures/views for complex analytical use cases.
Exposure to Data Build Tool (DBT),Qlik replicate, Snowflake, Airflow, AWS infrastructure, CI/CD pipelines
Troubleshoot and quickly resolve data quality issues, performance issues, database capacity issues, replication and other distributed data issues
Exposure to Python programming
Should be proficient in writing complex SQL queries
Strong analyzing capabilities with an ability to fine-tune report/SQL query performance
Exposure to Auto Finance process would be an added advantage.
Source : Diverse Linx
