Mid-Level Data Engineer | Siri Info Inc. | Dallas, TX

Siri Info Inc.; Dallas (TX); On-site; USD 90,000 - 125,000; Full time

Job summary

Siri Info Inc. is hiring a Mid-Level Data Engineer for our Dallas, TX client team. You will design and optimize data pipelines and OLTP databases in Azure, ensuring high-throughput transactional processing and secure data warehousing.

You will work with DBAs, developers, and BI specialists to deliver scalable, cloud-native data solutions. Onsite interviews and Day 1 readiness in Dallas are required.

Qualifications

• 4+ years of professional data engineering, database administration, or software engineering.
• Strong SQL Server expertise and OLTP system design.
• Hands-on cloud-native data solutions on Microsoft Azure.
• Advanced SQL querying, performance tuning, and indexing.
• ETL/ELT design and data warehousing principles.
• Problem-solving, analytics, and communication skills.
• Eligible to work in the United States; Day 1 onsite in Dallas.

Responsibilities

• Design, build, and maintain data pipelines for efficient ingestion and movement.
• Manage OLTP relational databases and SQL Server instances for high throughput.
• Develop and optimize complex SQL queries, stored procedures, and indexes.
• Create cloud-native data integrations across Azure environments.
• Troubleshoot data processing bottlenecks and failures.
• Ensure data governance, security, and backup/recovery practices.
• Collaborate with software and BI teams to align data models with reporting.
• Participate in face-to-face interviews and client assessments.

Skills

SQL Server

OLTP systems

Azure

ETL/ELT

Data warehousing

SQL queries

Performance tuning

Data pipelines

Tools

Azure Data Factory

Azure SQL Database

Databricks

Synapse Analytics

Job description

Position Summary:

Siri Info Inc. is actively seeking a skilled and dedicated Mid-Level Data Engineer to join our client team in Dallas, TX on a full-time, Day 1 onsite basis. In this critical data engineering role, you will be responsible for designing, optimizing, and maintaining robust data pipelines, OLTP transactional architectures, and cloud-native data platforms on Azure. You will collaborate closely with database administrators, software developers, and business intelligence teams to ensure high-performance data ingestion and secure data warehousing. This opportunity requires a qualified technology professional with strong SQL Server expertise, robust OLTP background, and readiness for a face-to-face interview process.

Detailed Job Description:

As a Mid-Level Data Engineer at Siri Info Inc., you will take full ownership of building and supporting scalable data pipelines and relational database structures in Azure. Your day-to-day responsibilities include designing efficient OLTP database schemas, optimizing complex SQL Server queries, managing database indexes, and integrating on-premise transactional systems with cloud data lakes and warehouses. You will troubleshoot data integration failures, execute ETL/ELT transformations, and ensure data integrity across multi-tier applications. Furthermore, you will collaborate with cross-functional technical teams to support high-availability operations and maintain meticulous technical documentation.

Key Responsibilities:

• Design, build, optimize, and maintain robust data pipelines for efficient data ingestion and movement.
• Manage and optimize OLTP relational databases and SQL Server instances for high-throughput transactional processing.
• Develop and execute advanced SQL queries, stored procedures, triggers, and performance tuning mechanisms.
• Build and maintain cloud-native data integration workflows and infrastructure across Microsoft Azure environments.
• Troubleshoot data processing bottlenecks, connection failures, and query performance degradation.
• Ensure strict adherence to data governance, security policies, and backup/recovery best practices.
• Collaborate with software development and business intelligence teams to align data models with reporting requirements.
• Participate in face-to-face interview evaluations and technical assessments with client stakeholders.

Required Qualifications & Skills:

• Minimum of 4+ years of professional experience in data engineering, database administration, or software engineering.
• Strong, demonstrable expertise in SQL Server architecture, relational database design, and OLTP systems.
• Practical hands-on experience designing and deploying cloud-native data solutions on Microsoft Azure.
• Excellent proficiency in advanced SQL querying, performance tuning, index optimization, and stored procedure development.
• Solid understanding of ETL/ELT pipeline design and data warehousing principles.
• Excellent problem-solving, analytical, and interpersonal communication capabilities.
• Mandatory eligibility to work in the United States and availability for Day 1 onsite work in Dallas, TX.
• Readiness to attend a face-to-face interview process in Dallas.

Nice-to-Have Skills:

• Professional certifications such as Microsoft Certified: Azure Data Engineer Associate or Azure Database Administrator Associate.
• Experience with Azure data services including Azure Data Factory, Azure SQL Database, Databricks, and Synapse Analytics.
• Proficiency in modern programming languages such as Python or C# for pipeline automation.
• Familiarity with CI/CD deployment pipelines, Git version control, and infrastructure as code.
• Prior working experience within IT staffing consultancy environments or enterprise client sites.

Application Information:

Salary/Rate: Market Competitive / Standard

Deadline: Open until filled

Notice Period: Immediate to 15 Days

Contract Duration: Permanent / Full-Time Onsite (Day 1 Onsite in Dallas, TX)

Recruitment Pro Tip:

When applying for this Mid-Level Data Engineer position, ensure your resume explicitly highlights your hands-on experience with SQL Server, OLTP database tuning, and Microsoft Azure data services. Clearly confirm your availability for Day 1 onsite work in Dallas, TX and face-to-face interviews.