Data Engineer supporting data capabilities of the fastest - growing family law firm in the UK. Drive data initiatives and collaborate with the BI team in a hybrid working environment.
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 AWS - based data solutions in hybrid role with a major financial sector client in LATAM. Involves leading data architecture decisions and optimizing data processing solutions.
Senior Data Engineer developing data solutions for a key client in the financial sector. Collaborating in a hybrid setting located in Quito, Ecuador.
Senior Data Engineer designing and building robust data solutions for analytics at Mindera. Collaborating with cross - functional teams to deliver high - quality data products.
Data Engineer developing and maintaining scalable data platforms at Vintage Cash Cow. Collaborating with teams to ensure accurate and reliable data for decision making.
Data Platform Consultant role focused on ETL pipeline configuration and data migration activities for FMCG clients at Snap Analytics. Collaborating in a hybrid work environment with strong data - centric teams.
Senior Data Engineer at Emergn solving real problems with cutting - edge technologies and growing alongside a collaborative global team.
Senior Software Engineer building core infrastructure for AI - driven products at Airwallex. Leading technical decision - making and driving project delivery for complex distributed systems.
Data Engineer designing and implementing scalable data pipelines and interactive dashboards for military clients. Collaborating with teams to support advanced analytics and modernize legacy environments.
Data Migration Consultant for Capgemini Engineering focusing on Teamcenter data migration. Join a team contributing to innovative engineering solutions in a dynamic environment.