BI Developer

\nWork closely with Business Users and Subject Matter Experts (SMEs) to understand and gather requirements and design the system accordingly.\nDevelop and implement an enterprise data warehouse and reporting solution using Business Intelligence (BI) suite of tools.\nDesign and implement multidimensional data models using star and snowflake schema.\nDevelop and publish ETL procedures to Extract, Transfer, and Load data from various sources.\nExperience working on the software development life cycle (SDLC).\nPerform data cleansing, data profiling, and in depth analysis using SQL queries, stored procedures, and optimize queries for performance.\nPrepare release documents with deployment instructions, configurations, and environments for production release,following release management policies and procedures.\nBuild data pipelines and end to end ETL and ELT processes for Data Ingestion and transformation in Google Cloud Platform (GCP), coordinating tasks among the team.\nDesign and architect various layers of Data Lake and star schema in BigQuery.\nDesign ETL jobs using various GCP services like Data Proc, Google Cloud Storage (GCS), Cloud Functions, and BigQuery.\nEnsure appropriate levels of quality assurance for all new and existing applications/Change Requests.\nEnsure that application changes are fully documented and supportable.\nMonitor and troubleshoot daily processes for any job failures in the production \n

Labor Condition Application (ETA Form 9035 & 9035E) filed with the United States Department of Labor, Office of Foreign Labor Certification for a H-1B non-immigrant worker with the following details:\n1. Number of H1B non-immigrant workers included in LCA: \n1(One)\n2. Job Position: \nBI Developer\n3. Wages Offered:\n$101,192.00 to $101,193.00 per year \n4. Period of Employment: \n10/1/2024\n \nto\n \n09/30/2027\n5. Locations where H1B non-immigrant worker will work:\n1. \n4108 Kyles Landing Dr,Hickory Creek,Texas-75065\n \nComplaints alleging misrepresentation of material facts in the Labor Condition Application and/ or failure to comply with the terms of the Labor Condition Application may be filed with any office of the Wage & Hour Division of the United States Department of Labor.\n \nThe verification of Labor Condition Application (ETA Form 9035 & 9035E) will be available for all to review .\n \nhttps://us-west-2.graphassets.com/AhL7j39r8QqrJYMwlDWAYz/gAFYlbYTmWhAVvMeWMqZ\n