Overview
Skills
Job Details
Job Title: Data Warehouse Developer / BI Developer
Location: 205 Jesse Hill Jr. Drive, 2052 Twin Towers East, Atlanta, GA 30334 (Onsite Role)
Work Mode: Video or In-Person Interview
- Position may require on-site presence depending on project need
- Local or willing-to-relocate candidates preferred
Job Overview:
We are seeking an experienced Data Warehouse/BI Developer to support enterprise data initiatives for a key public sector client. This role requires strong expertise in T-SQL, SSIS, Power BI, and data warehousing principles. You will play a crucial part in designing and developing scalable data pipelines, integrating multiple data sources, and enabling analytics through BI solutions.
Key Responsibilities:
- Collaborate with internal customers and stakeholders to understand use cases and translate them into data integration routines
- Perform data analysis, mapping, transformation, and ETL processes between systems
- Design and maintain database objects (tables, views, indexes, security)
- Optimize and maintain data warehouse performance, batch processing, and parallelization
- Work closely with Data Architects to implement best-in-class data models
- Document data flows, source-to-target mappings, and technical processes
- Support audit control, data validation, cleansing techniques, and process monitoring
- Provide on-call support after hours when necessary
- Use version control (GitHub) and participate in CI/CD pipelines
- Enable and mentor junior developers on data-related best practices
Required Qualifications:
- 5+ years of experience in Data Warehousing and Business Intelligence
- 3+ years of BI development using Microsoft SQL Server and expert-level T-SQL
- 5+ years working with SSIS and stored procedures
- 2+ years of Power BI development and dashboarding
- Strong understanding of data modeling (conceptual, logical, and physical), including EDW and data marts
- Deep knowledge of relational databases and SQL programming
- Demonstrated ability to mentor junior developers and guide design decisions
- Bachelor's degree in Computer Science, Information Technology, or related field
Preferred Skills (Nice to Have):
- 1 2 years experience with Azure Synapse / Azure Data Warehouse
- 1 2 years working with Azure Data Factory, SQL VMs, and building/maintaining ETL in a Data Lake environment
Skill | Required / Desired | Amount | of Experience |
Data Warehousing and Business Intelligence | Required | 5 | Years |
BI development leveraging the Microsoft SQL Server 2014+. Needs to be an expert in T-SQL | Required | 5 | Years |
SSIS and use of Stored Procedures | Required | 5 | Years |
Azure Data Factory, SQL VMs, build and maintain ETL | Required | 2 | Years |
Azure Data Warehouse (Synapse) | Highly desired | 2 | Years |
Power BI | Required | 2 | Years |
eye