Data Engineer Lead developing and maintaining data applications and pipelines in Azure for State Street. Collaborating with teams to ensure data integrity and implementing data processing principles.
N(
Hybrid Data Warehouse Developer II
Posted 2 months ago
About the role
- Data Warehouse Developer II designing and maintaining ETL processes at NCCPA, a certifying organization for physician assistants in the U.S.
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.
Requirements
- 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.
Benefits
- As a matter of policy, NCCPA restricts remote positions to those in which the employee’s home office location in a U.S. jurisdiction in the Eastern or Central time zones.
- We get to do meaningful work every day and we enjoy working and having fun together! No wonder we’ve been ranked #5 out of 62 small businesses in the metro Atlanta area by the Atlanta Journal Constitution's 2025 Top Workplaces in the Region.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Architect designing and implementing data architectures for pharmaceutical clients. Collaborating with teams to create efficient data ecosystems that drive business value.
Working student in Automation & Data Engineering at Kelvion supporting internal tools and automations using Microsoft Power Platform. Involvement in systems configuration, reports, dashboards, and data structure maintenance.
Senior AWS Data Engineer supporting HHS grant award management, providing technical leadership and maintaining cloud data systems. Ideal for candidates excelling in modernization and operational environments.
Data Engineer at Booz Allen developing technology solutions for clients analyzing large datasets. Collaborating with teams on mission - driven projects using data engineering best practices.
Data Engineer supporting data pipelines for business insights and GenAI applications at Assurity Trusted Solutions. Collaborating with teams on data workflows in a hybrid environment.
Senior Data Engineer leveraging big data and cloud expertise to build data pipelines at Alight. Ensuring reliability, governance, and operational excellence across data platforms.
Data & AI Engineer at Decathlon Colombia designing and optimizing data ecosystems. Involves building data pipelines and deploying machine learning models.
Senior hands - on engineering lead at Electric Mind focusing on data platforms, AI, and analytics. Collaborating with teams on complex, mission - critical transformations in technology solutions.
AI Data Engineer (Azure + Copilot Studio) developing data pipelines and AI agent solutions. Involves working with Azure Data Factory, Copilot Studio, and data integration in a hybrid role.