Lead Business Intelligence Developer

Lead Business Intelligence Developer Location - Jersey City NJ / Coppell, Texas / Tampa, FL Job Description: Looking for a Lead Business Intelligence Developer with a Minimum of Seven Plus years hands-on experience in developing reports to support portal applications. Should have extensive experience in Oracle SQL Developer, PostgreSQL Primary Responsibilities: Design, develop and write performance tuning queries using Talend ETL code for large volume and complex transformations. Work with Product Owners for Requirements grooming and Clarifications. Work with Datawarehouse Team on the design and development of tables Support end to end testing , Release management and Deployments. Support Production Issues and be On call on a need basis Demonstrate the work done to the Risk Business users, implement the feedback, and provide suggestions as needed. Provide ad hoc support to pull data from Data Warehouse as needed from Risk Business users. Co-ordinate with offshore peers on requirements clarification, delegate work and help them with any code related issues. Provide MIM Support as needed for Production issues . Work with Data Integrity Team and help them build the queries for threshold checks. Skills Sets SQL, Snowflake, Power BI ,Cognos Data Analytics, Microsoft SQL Server, HTML Hands on experience in Shell, python scripting handling orchestrations of ETL pipelines. Hands on experience in creating and managing Autosys JILs for orchestration Talents Needed for Success: Minimum 7 years of related experience in building and maintaining large scale Data warehouse applications in cloud. Minimum 3 years of experience in Talend ETL tool as a developer, developing complex ETL pipelines loading data into snowflake Database. Minimum 5 years of Hands-on experience in writing, tuning, and managing complex SQL for real-time reporting from large scale data warehouse systems in Snowflake, Oracle etc. 3 years of experience in writing and performance tuning of PL/SQL languages with best practices and standards. Strong hands-on experience in bitbucket, git, Liquibase and managing multiple versions of release and CICD pipelines. Good understanding of Enterprise Data integration concepts, Data warehouse modelling and Data architecture patterns . 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.