Data Engineer

The Data Engineer role at ABACUS is focused on building and supporting data pipelines that move and transform information across a modern Azure-based platform. Working in Dallas, TX onsite, you will develop ETL workflows that integrate data from internal and external systems while following security and compliance procedures in regulated environments.

What you’ll do

• Develop and maintain ETL pipelines using Python and SQL Server for ingestion, transformation, and integration from structured files and RESTful APIs.
• Write, test, and debug Python code for data processing, automation, and basic integrations using established standards and best practices.
• Create and maintain T-SQL queries, views, and stored procedures to support business logic and reporting requirements.
• Assist in building and operating data workflows with Azure Data Factory, Azure SQL, and Azure Blob Storage.
• Support monitoring of data pipelines and help troubleshoot data quality issues, pipeline failures, and performance problems.
• Follow defined data quality, security, and compliance procedures in regulated environments, including healthcare and financial services.
• Collaborate with data analysts, software engineers, and DevOps teams to understand data requirements and upstream systems.
• Participate in code reviews, implement feedback, and continuously improve coding and engineering practices.
• Create and maintain clear documentation for pipeline logic and operational processes.

Required qualifications

• 1–4 years of professional experience in Data Engineering, Software Engineering, or a related technical role.
• Strong, hands-on proficiency in Python, including writing functions, handling errors, and debugging.
• Experience working with relational databases, preferably SQL Server.
• Strong working knowledge of SQL, including joins, aggregations, subqueries, and basic performance considerations.
• Exposure to integrating or consuming data from RESTful APIs or external data sources.
• Familiarity with Git or a similar version control system.
• Strong analytical and problem-solving skills with the ability to learn quickly.
• Bachelor’s Degree (preferred).

Tools and technologies you may work with

• Python, SQL Server, T-SQL, Azure
• Azure Data Factory, Azure SQL, Azure Blob Storage
• RESTful APIs, Git
• Power BI, Azure Synapse, Azure DevOps, Azure Functions
• .NET Framework, C#
• HIPAA, SOC2, SIEM tools

Additional experience that’s a plus

• Experience with additional Azure services such as Azure Synapse, Azure DevOps, and Azure Functions.
• Understanding of data modeling and warehousing concepts.
• Exposure to cybersecurity data, SIEM tools, or SOC operations.
• Knowledge of .NET Framework and C#-based APIs, particularly for data consumption contexts.
• Background in MSP/MSSP environments or consulting.
• Familiarity with Power BI or other data visualization tools.

Location and setup

• Location: Dallas, TX (onsite)