Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Business Intelligence MS SQL T SQL PLSQL SQL Microsoft Developer
(Jobs in Atlant
 
Requirement id 140863
Job title Developer
Job location in Atlanta, GA
Skills required Data Modeling, Data Warehouse, Business Intelligence, MS SQL T SQL PLSQL SQL Microsoft
Open Date 15-May-2023
Close Date
Job type Contract
Duration 12 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Developer: Data Modeling, Data Warehouse, Business Intelligence, MS SQL T SQL PLSQL SQL Microsoft

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 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:
•Bache
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 140863 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 Modeling job openings in Atlanta, GA
Jobs List

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 (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 Architect
Create date: 30-Dec-2019
Note:

* Only candidates that are submitted at the rates included will be accepted.

* All candidates must be your W2 or your vendors W2, we cannot accept any candidates that are C2C to the candidate.

* We also cannot accept candidates who have more than 3 vendors – us, your agency and your vendor.

* Let al.... (This job is for - Data ArchitectAWS Jobs in GA Atlanta Architect - (in Atlanta, GA))

Senior ETL Developer - 54674
Create date: 15-Apr-2019
Design, develop, test, debug, implement and maintain Extract, Transformation & Load (ETL) system. Includes workflows, mapping, scripts and stored procedures to support business application needs.

IMPACT & INFLUENCE:

This position will interact on a consistent basis with: management and personnel within OIT - Enterprise Informa.... (This job is for - Data Warehousing IBM Jobs in GA Atlanta Developer - (in Atlanta, GA))

Data Architect - 42282
Create date: 17-Jan-2019
Candidate must be our W2 Employee


Note :
The manager is open to candidates willing to relocate on their own to Atlanta for the project. They will substitute an onsite interview with a video interview!
Selling points for candidate :
Project Verification Info :
The manager is open to candidates willing to relocate.... (This job is for - job Jobs in GA Atlanta Architect - (in Atlanta, GA))
 
 Data Modeling job openings in other states
Jobs List

SOFTWARE ARCHITECT - CONSULTANT-11434-1
Create date: 29-Oct-2024
No of Submissions : 2

start date : 12/07/2024

submission deadline : 11/5/2024

client info : Department of Health and Human Services

Note:

Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)?

A) A video conference interview or in-person interview may be con.... (This job is for - JQuery Jobs in SC Columbia Architect - (in Columbia, SC))

DRC-Programmer 4/ PR 4Replacements (748107)
Create date: 30-Sep-2024
No of Submissions : 2

start date :11/11/2024

End date :06/30/2025

submission deadline : 10/03/2024

client info : DRC

Note:

* AM: Shalaka

* A more senior developer is responsible for planning, processing and performing all jobs in an efficient manner with little or no su.... (This job is for - NET FRAMEWORK Jobs in OH Columbus Consultant - (in Columbus, OH))

NC FAST Integration Engineer (743614)
Create date: 19-Aug-2024
Hybrid

No of Submissions : 1

start date :09/16/2024

End date :09/12/2025

submission deadline : 08/26/2024

client info : NCDHHS-NCFAST

Note:

* Agency Interview Type: Either Webcam Interview or In Person

Description : .... (This job is for - JSON Jobs in NC Durham Engineer - (in Durham, NC))

Albemarle County - Data Analyst 2 (742704)
Create date: 22-Jul-2024
No of Submissions :2

Start date :8/19/2024

End Date :06/30/2025

Submission deadline :7/25/2024

Client Info :Albemarle County

Note:
* Hybrid
* Agency Interview Type:Both Web Cam and In Person Interview

Description :

Mgr agrees to initial Virtual IVs but reserves .... (This job is for - job Jobs in VA Charlottesville Analyst - (in Charlottesville, VA))

Data Science Analytics Financial Data Manager (742107)
Create date: 11-Jul-2024
Position Title: IA-DOM-DoIT-TS3-Data Science Analytics Financial Data Manager (742107)

* Onsite

No of Submissions : 1

Start date : 08/05/2024

End Date : 07/13/2025

Submission deadline : 7/16/2024

Client Info : OCIO: Office of the Chief Information Officer

Note:

.... (This job is for - SaaSOLAP Jobs in IA DesMoines Manager - (in Des Moines, IA))
 
 Data Modeling job openings in GA
Jobs List

Senior Data Modeler-Erwin - J-10-939-196
Create date: 03-Oct-2014
Job Description: Accountable for analyzing and developing complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. Understands the methodologies and technologies that depict the flow of data within and between technology systems and business function.... (This job is for - job Jobs in GA ALPHARETTA Modeler - (in Alpharetta, GA))
(Developer: Data Modeling, Data Warehouse, Business Intelligence, MS SQL T SQL PLSQL SQL Microsoft in Atlanta, GA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us