Apply on Employer Site

National Commission on Certification of Physician Assistants (NCCPA) · 2 days ago

Data Warehouse Developer II

Johns Creek, GA

Full-time

Hybrid

Mid Level

$82K/yr - $91K/yr

3+ years exp

National Commission on Certification of Physician Assistants (NCCPA) is the only certifying organization for physician assistants in the United States. As the Data Warehouse Developer II, you will be responsible for designing, developing, and maintaining robust ETL processes and data warehouse solutions to support enterprise-wide data initiatives and ensure data integrity and performance.

EducationGovernmentNon ProfitTraining

Comp. & Benefits

No H1B

Responsibilities

Design, develop, and maintain complex ETL processes using SQL Server Integration Services (SSIS) and other tools

Build and optimize star and snowflake schema data models to support analytical and reporting needs

Ensure the accuracy, integrity, and performance of data pipelines and warehouse structures

Monitor, troubleshoot, and tune ETL jobs and data warehouse performance

Collaborate with business analysts, data architects, and other stakeholders to gather requirements and deliver data solutions

Develop and maintain technical documentation for ETL processes and data models

Support data quality initiatives and implement data validation and cleansing routines

Participate in code reviews, testing, and deployment activities following SDLC best practices

Monitor and validate nightly ETL jobs and data loads; troubleshoot and resolve failures

Implement alerting and logging for ETL processes and participate in on-call rotations as needed

Qualification

ETL developmentSQL ServerData warehousingPerformance tuningCloud-based data platformsReporting toolsAgile methodologiesData governanceData quality frameworksAnalytical skillsData lake architectureData privacy regulationsReal-time data processingData lineageData observabilityData mesh conceptsTime managementCommunication skillsInterpersonal skills

Required

Applicants must be authorized to work lawfully in the United States for NCCPA as NCCPA will not sponsor or take over sponsorship of employment visas

Bachelor's degree in Computer Science, Information Systems, or a related field

At least 3 years of experience in ETL development using SSIS or similar tools

At least 3 years of experience with SQL Server and T-SQL development

Strong understanding of data warehousing concepts and dimensional modeling

Experience with performance tuning and troubleshooting of ETL processes

Familiarity with reporting tools such as Power BI or SSRS

Experience with cloud-based data platforms (e.g., Azure Data Factory, Synapse)

Knowledge of scripting languages (e.g., Python, PowerShell)

Experience with Agile methodologies and DevOps tools (e.g., Azure DevOps)

Familiarity with data governance and data quality frameworks

Your strong analytical and problem-solving skills

Your highly developed time management skills, systematic approach to organization/planning and keen attention to detail while managing multiple projects

Your excellent verbal and written communication skills

Your interpersonal skills and ability to collaborate with cross-functional teams