Role : Data Analyst Location: Detroit, MI (Onsite) Duration: Full-time Technical/Functional Skills
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 etc.).
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.
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.