"Alerted.org

Job Description

We are seeking a highly skilled Data Architect to support a North Carolina university in building and maintaining modern data architecture solutions. This role will focus on designing scalable ETL pipelines, supporting cloud-based data platforms, and setting data engineering standards across teams. The ideal candidate has a strong background in SQL, Python, and PySpark, with deep experience in data modeling and modern cloud data tools like Databricks or Microsoft Fabric.

*This is a hands-on technical role with architectural responsibilities, requiring someone who can both build complex solutions and support existing infrastructure.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

Advanced SQL skills for building and optimizing queries across large datasets.

Strong experience with Python and PySpark for data pipeline development.

Deep understanding of data modeling, particularly star schemas and Kimball methodology.

Proven ability to design complex ETL architectures in a modern cloud environment.

Hands-on experience with Databricks for building and maintaining lakehouse architecture (or strong transferable experience with similar/ MS Fabric, or Snowflake).

Experience working with Azure Data Factory and related Azure services.

Strong understanding of cloud networking, including private endpoints, NSGs, and secure credentialing.

Comfortable working with data governance and compliance frameworks (HIPAA, FERPA). Databricks administration experience (clusters, jobs, access control).

Experience with Azure DevOps, including CI/CD pipelines and YAML configuration.

Familiarity with Power BI for reporting and dashboards.

Prior experience working in a higher education environment.

Knowledge of APIs, ODBC, and integrating with third-party systems. null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].