Data Warehouse Developer II

Join to apply for the Data Warehouse Developer II role at National Commission on Certification of Physician Assistants (NCCPA).

Base pay range: $82,000.00/yr - $91,000.00/yr.

This range is provided by NCCPA. Pay will be based on skills and experience.

Hybrid work environment with headquarters in Johns Creek, Georgia. Remote position for employees in U.S. Eastern or Central time zones; required travel for mandatory meetings.

Senior Director of Application Development.

• 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.

• Bachelor's degree in Computer Science, Information Systems, or 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, Power Shell).
• Experience with Agile methodologies and Dev Ops tools (e.g., Azure Dev Ops).
• Familiarity with data governance and data quality frameworks.

• Strong analytical and problem‑solving skills.
• Highly developed time‑management skills and attention to detail while managing multiple projects.
• Excellent verbal and written communication skills.
• Interpersonal skills and ability to collaborate with cross‑functional teams.
• Experience with data lake architecture and implementation.
• Exposure to data privacy regulations such as GDPR and HIPAA.
• Experience with real‑time data processing frameworks (e.g., Apache Kafka, Spark Streaming).
• Experience with data lineage and metadata management practices.
• Familiarity with data observability and monitoring tools.
• Understanding of data mesh or modern data platform concepts.

Mid‑Senior level.

Full‑time.

Information Technology.

Non‑profit Organization Management.

We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace. NCCPA is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please contact Human Resources at 678‑417‑8589.