VP, Senior Data Engineer responsible for designing and developing cloud data solutions for insider risk in Information Security at SMBC. Collaborating with multiple teams to enhance cybersecurity data platform.
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 Engineer responsible for architecting, developing, and maintaining Allegiant’s enterprise data infrastructure. Overseeing transition to cloud hosted data warehouse and developing next - generation data tools.
Senior Data Engineer developing Azure - based data solutions for clients in the Data & AI department. Collaborating with architects and consultants to enhance automated decision making.
Data Engineer II focusing on strategic ingestion product for Travelers. Building data solutions and collaborating across teams to support analytic transformation.
Data Engineer at Tatum focusing on scalable data solutions and blockchain technology. Collaborating with teams to ensure data integrity and manage data infrastructure in a hybrid setup.
Senior Lead Data Engineer at Capital One collaborating with Agile teams and mentoring developers. Leading full - stack development and driving cloud - based solutions for financial empowerment.
Senior Data Engineer responsible for developing data pipelines and collaborating with US business teams. Working at Beghou Consulting, a life sciences company providing advanced analytics and technology solutions.
Data Solutions Architect designing enterprise - scale Azure and Databricks Lakehouse solutions for clinical trials and life sciences data enabling advanced analytics and compliance.
Data Architect at ADEO ensuring interoperability of IT systems through architecture design and data knowledge diffusion. Collaborating with teams to maintain data integrity and quality standards in an international setup.
Consultant, Data Engineer leading end - to - end data solutions and analytics. Collaborating with clients to improve data strategies and deliver actionable insights.