T-SQL SQL Server 2000 Azure Environment Integrated System Business Intelligence Dev   Requirement id 120150 Job title Developer Job location in Atlanta, GA Skills required Data Warehouse, T-SQL, PL/SQL, SQL Server 2000 Azure Environment Integr Open Date 02-Nov-2021 Close Date Job type Not specified Duration 7 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Developer: Data Warehouse, T-SQL, PL/SQL, SQL Server 2000 Azure Environment Integr Start Date :12/1/2021 End Date :06/30/2022 Submison Deadline :11/5/2021 Client Info: DOE/TS/LDS Note : * Agency Interview Type: Either Web Cam or In Person Description : Job Summary: The ideal candidate must demonstrate in-depth knowledge and understanding of Database concepts and, experienced in writing SQL and T-SQL. Need to support the applications with 24/7 availability and experience in handling Large Volume of Data, in Oracle and SQL Server, Azure SQL platform. Essential Duties and Responsibilities: Collaborate with internal customers, prospects, and stakeholders, understand, and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing, and transforming large amount of data between multiple systems. Identifies data sources, provides data flow diagrams, and documents source to target mapping and process. Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports Provide technical enablement to team members developing database applications on a cloud platform. Facilitate the development of data integration efforts by leading small teams of 1-2 junior developers in addition to Knowledge of ETL Design Patterns, Error Handling and Configurations. Design, implement and maintain database objects (tables, views, indexes, etc.) and database security. Collaborate with data stewards, data owners and domain experts to recognize and help adopt best practices in reporting and analysis: data integrity, test design, validation, and documentation. Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc. Work with the Data Architect to establish processes for governing the identification, collection and use of educational metadata to assure metadata is accurate and valid in the business intelligence environments. Ensure data quality through creation of audit controls, proactive monitoring, and data cleansing techniques. Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment. Responsible for scheduled data processes integrity checks, performing deployments and coordinate for releases. Experience with Source Version Control software like GitHub and CICD pipelines Provide on-call support after hours as an when needed. Requirements: 7+ years of experience in Data Warehousing and Business Intelligence 5+ Years in BI development leveraging the Microsoft SQL Server. Needs to be an expert in T-SQL 5+ Years in SSIS and use of Stored Procedures. 1-2 Years in Azure Data Factory, SQL VMs, build and maintain ETL Ingest and aggregate data from both internal and external data sources to build our data lake Strong understanding data modeling (i.e., conceptual, logical, and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts). Deep understanding of relational database design concepts and SQL programming Experience guiding/mentoring developers with lesser experience. Requires strong analytical, conceptual, and problem-solving abilities. Strong experience with business intelligence and data warehousing design principles and industry best practices. Good to have: 1-2 Years in Azure Data Warehouse (Synapse) 1-2 Years knowledge of utilizing Python, PySpark, SparkSQL On Azure Cloud Qualifications: •Bachelors degree from an accredited college or university with   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 120150 while calling.   Other jobs in GA: Alpharetta (12), Atlanta (37), Conyers (2), Downtown Atlanta (1), Dublin (1), Duluth (5), Dunwoody (4), Lawrenceville (2), Norcross (4), Data Warehouse job openings in Atlanta, GA Jobs List GTRI Sr. Data Architect (748151) Create date: 01-Oct-2024 No of Submissions : 2 Start date : 11/04/2024 End Date : 06/30/2025 Submission deadline : 10/04/2024 Client Info : GTRI-Enterprise Systems Department Note: * Agency Interview Type : Either Web Cam or In Person * Hybrid * Plans and schedules team resources, sta.... (This job is for - ArchitectingAnalytics Jobs in GA Atlanta Architect - (in Atlanta, GA)) ETL Data Developer - 60727 Create date: 23-May-2023 Start date :07/01/2023 End Date :06/30/2024 Submission deadline : 06/22/2023 Client Info : APS - IT Note: * Position Location Hybrid Description : The selected candidate will join our Data Integrations team of Data Architects and ETL Developers within the APS IT division. The team .... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA)) DOE Azure Database Developer (710982) Create date: 15-May-2023 Hybrid Start date :06/12/2023 End Date :06/30/2024 Submission deadline :05/19/2023 Client Info :DOE/TS Description : ------------------------------------------------------ Do not submit any candidates that were submitted to Requisition #667306. Job Summary: The ideal c.... (This job is for - Business Intelligence Jobs in GA Atlanta Developer - (in Atlanta, GA)) DOE Database Developer (679251) Create date: 05-Apr-2022 Start Date : 04/18/2022 End Date : 06/30/2024 Submission Deadline : 04/08/2022 Client Info: DOE/TS/FN Note: * Agency Interview Type :Either Web Cam or In Person Description: Collaborate with internal customers, prospects, and stakeholders, understa.... (This job is for - Business Intelligence T SQL Jobs in GA Atlanta Developer - (in Atlanta, GA)) DOE Azure Database Developer (673921) Create date: 11-Jan-2022 Start Date :2/15/2022 End Date :12/31/2022 Submison Deadline :1/19/2022 Client Info: DOE/TS/LDS Note : * Agency Interview Type: Either Web Cam or In Person Description : Do not submit any candidates that were submitted to Requisition #667306. J.... (This job is for - T SQL Jobs in GA Atlanta Developer - (in Atlanta, GA))    Data Warehouse job openings in other states Jobs List Data Warehouse Architect 5 - 144093 Create date: 27-Jun-2025 Start date : 07/28/2025 End Date : 09/30/2025 Submission deadline : 7/3/2025 10:00:00 AM Client Info : DHHS Note: * Interview Process: Virtual Interviews via MS Teams. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of virtual i.... (This job is for - job Jobs in MI Lansing Architect - (in Lansing, MI)) Data Warehouse Developer III - 143070 - Rebid Create date: 27-May-2025 Start date : 07/01/2025 End Date : 06/30/2026 Submission deadline : 5/29/2025 4:00:00 PM Client Info : DCF Note: * INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortl.... (This job is for - Architecture Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Architect 5 - 139883 Create date: 07-Feb-2025 No of Submissions : 1 Start date : 03/10/2025 End Date : 09/30/2025 Submission deadline : 2/14/2025 10:00:00 AM Client Info : DHHS Note: * Will close submissions on: 2/14 at 10am EST. * Interview Process: Virtual interviews are anticipated for this position. A screen.... (This job is for - Teradata Jobs in MI Lansing Architect - (in Lansing, MI)) Certified Project Manager IV/Sr. -136881(REBID) Create date: 31-Oct-2024 No of Submissions : 1 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 11/4/2024 4:00:00 PM Client Info : ETF Note: * Interview Process: MS Teams * Duration of Contract: 6/30/2025, with potential for extension * Onsite or Remote: Candida.... (This job is for - BI Jobs in WI Madison Manager - (in Madison, WI)) QA Test Analyst Advanced -63258 Create date: 20-Sep-2024 No of Submissions : 2 start date : 10/14/2024 End date :10/31/2026 submission deadline : 09/24/2024 client info : NeDHHS Note: * Position Location: Remote Description : We are seeking a highly skilled ETL Test.... (This job is for - job Jobs in NE Lincoln Analyst - (in Lincoln, NE))    Data Warehouse job openings in GA Jobs List ICM Developer - 52946 Create date: 19-Sep-2019 We should submit only GC, GC EAD, L2 EAD, H4 EAD and Citizens. Description: 3-4 Years of ICM IBM Compensation experience (Varicent is the old tool). Strong compensation design knowledge. Experience creating pay-out structures. testing ETL is a plus. Data warehousing experience is a plus. (This job is for - Designing Jobs in GA Columbus Developer - (in Columbus, GA)) Business Analyst Data Warehousing - 53993 Create date: 06-Sep-2018 Start Date :10/08/2018 End Date :06/30/2019 Submission Deadline :09/28/2018 Department of Human Services (DHS) is seeking qualified candidates for the position of Business Analyst - Data Warehousing. The Business Analyst will support the Data Warehousing for Office of Informatio.... (This job is for - Business Analyst Jobs in GA StreetAtlanta Analyst - (in Streetatlanta, GA)) Bi Modeler - J-10-875-430 Create date: 11-Mar-2014 Minimal work direction needed, highly skilled and knowledgeable to the position and provides best practicing sharing within work group. BI Modeling and C# Engineer. Plans, designs, develops OLAP data models. Codes and tests extraction routines and reports to be delivered in .NET SOA web application. Responsibilities: Defines and develops OLAP model.... (This job is for - OLAP Jobs in GA ATL Modeler - (in ATL, GA)) (Developer: Data Warehouse, T-SQL, PL/SQL, SQL Server 2000 Azure Environment Integr in Atlanta, GA)

Featured Jobs Monitoring Troubleshooting Administrator (Jobs in Lansing, Michigan) Specialist (Jobs in Atlanta, Georgia) JAD RDBMS Analyst (Jobs in Lansing, Michigan) ASP.Net .NET Developer (Jobs in Tucker, Georgia) Architecture Architect (Jobs in Lansing, Michigan) Troubleshoot Troubleshooting Customer Consultant (Jobs in Milwaukee, Wisco Reporting Manager (Jobs in Richmond, Virginia) MVC Developer (Jobs in Boise, Idaho) SDLC Documentation Analyst (Jobs in Mechanicsville, Virginia) Imaging Desktop Consultant (Jobs in Madison, Wisconsin)