Software Engineer - SQL/Full Stack (Hybrid), Plano

Job description:

Software Engineer – SQL / Full Stack (Hybrid), Plano

Location:Plano, Texas
Work arrangement:Hybrid three/four days per week onsite

About Us

O’Neil Digital Solutions (ODS) is a subsidiary of Data Analysis Incorporated (DAI), the umbrella company for the O’Neil family of businesses. DAI and its subsidiaries operate across diverse industries, including global equity markets, healthcare, financial services, digital news, and insurance.

O’Neil Digital Solutions provides technology-driven print, document composition, data-processing, and fulfillment solutions for clients across multiple industries.

We use technology and innovation to improve our businesses and help our customers succeed. We value integrity, personal accountability, collaboration, and practical problem-solving.

Pay

• $90K - $96K base + 10% yearly bonus target

The Opportunity

O’Neil Digital Solutions is seeking a Software Engineer with strong SQL and data-integration experience, along with complementary full-stack development skills.

This is aSQL-first engineering position. The majority of the near-term work will involve SQL development, SSIS packages, data ingestion, transformation, and production workflows. The engineer will also contribute to solutions involving Python, C#, APIs, JSON files, and web applications.

The successful candidate will be able to take a customer specification or business requirement, develop an end-to-end technical plan, and implement the solution within an existing, interconnected processing environment. This role requires someone who understands how changes made at the beginning of a workflow can affect databases, services, applications, files, and production outputs downstream.

This is an excellent opportunity for an experienced engineer who enjoys solving complex data problems, working across multiple layers of an application, and taking ownership from initial requirements through production deployment.

What You’ll Do

• Design, develop, enhance, and maintain SQL-first, full-stack applications and data-processing workflows.
• Develop and support complex SQL queries, stored procedures, database objects, andSSIS packages.
• Build and maintain processes that ingest, validate, transform, and export structured and semi-structured data, including JSON and other file formats.
• Translate customer specifications and business requirements into practical, end-to-end technical plans.
• Analyze upstream and downstream dependencies before implementing changes.
• Integrate SQL-based workflows with internal and external APIs.
• Contribute to backend development using Python, C#, or comparable technologies.
• Support web application development when required.
• Diagnose and resolve SQL performance, data-quality, integration, and production-processing issues.
• Apply performance-tuning and code-optimization practices to improve reliability and efficiency.
• Develop appropriate validation, logging, error-handling, recovery, and monitoring processes.
• Test changes across the complete workflow to ensure they produce the intended downstream results.
• Collaborate with software engineering, client services, manufacturing, composition, and other business and technical teams.
• Estimate and prioritize work when requirements are both clearly defined and ambiguous.
• Deliver medium-to-large projects through the full software development lifecycle, from planning and design through deployment and production support.
• Assist and guide other engineers while contributing as a hands-on member of the team.
• Participate in Agile/Scrum development processes and help the team meet project milestones and delivery commitments.

Required Qualifications

• Bachelor’s degree in Information Technology, Computer Science, a related discipline, or equivalent professional experience.
• Four to seven years of professional software development, database engineering, or data-integration experience.
• Strong, recent hands-on SQL development experience.
• Experience designing, developing, or maintaining ETL and data-integration workflows.
• Experience with SSIS or a comparable enterprise data-integration platform.
• Demonstrated ability to understand and support an interconnected, end-to-end processing environment.
• Experience diagnosing SQL performance issues and applying performance-tuning or code-optimization techniques.
• Experience taking at least one large project or multiple medium-sized projects from initial requirements through production deployment.
• Experience working with production systems, including troubleshooting, validation, and ongoing maintenance.
• Ability to independently translate general specifications into a structured technical approach.
• Strong analytical, planning, and problem-solving skills.
• Clear written and verbal communication skills.
• Ability to collaborate effectively with both technical and nontechnical partners.

Preferred Qualifications

• Advanced experience with Microsoft SQL Server and SSIS.
• Experience integrating databases with REST APIs or other application services.
• Experience developing backend solutions with Python or C#.
• Experience processing JSON or other semi-structured data formats.
• Experience with Java or another object-oriented programming language.
• Experience with a modern frontend framework such as Vue.js, Angular, or React.
• Experience working in manufacturing, document composition, financial services, or another production-oriented environment.
• Experience mentoring engineers or providing technical guidance to project teams.

What Success Looks Like

A successful engineer in this position will:

• Become productive within an established SQL and SSIS framework.
• Take ownership of assignments without requiring step-by-step direction.
• Understand the complete flow of data from initial input through final production output.
• Anticipate how a proposed change may affect related systems and downstream processes.
• Deliver reliable, maintainable solutionsnot isolated code changes.
• Communicate risks, dependencies, progress, and technical decisions clearly.
• Balance immediate delivery needs with long-term system quality and supportability.

Knowledge, Skills, and Abilities

• Perform all work with honesty and integrity.
• Take personal responsibility for the quality, productivity, and timeliness of assigned work.
• Listen attentively and communicate professionally and promptly.
• Use creativity, analysis, and sound judgment to improve existing practices and develop practical solutions.
• Collaborate with colleagues to achieve shared goals.
• Support the organization’s values, departmental objectives, and customer commitments.

Founded in 1973, O’Neil Digital Solutions (ODS) is a leading IT consulting firm specializing in the optimization of complex end-to-end business process systems for a multitude of business verticals including Financial Services, Digital Media, Healthcare, and Transportation industries. ODS provides high-touch bespoke software engineering, systems integration, and infrastructure management services to clients of all sizes and industries. From large scale mass communication projects to highly secure and confidential data analytics using Big Data frameworks like Hadoop and AWS Redshift, ODS has a broad set of proven technical capabilities that help companies make complex digital transformations. ODS offers state of the art publishing solutions through our customer-centric applications and services include electronic document delivery, web applications, high-speed digital printing (color and black & white), automated composition, offset printing, warehousing and fulfillment services. ODS is headquartered in Los Angeles, CA and also has offices/plants in Texas and North Carolina centrally located to serve clients across the country.