• Job Description

  Req#: JPC - 10183231

  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

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice