Senior Manager, Systems Development, Integration & Reporting

DYCK-O'NEAL, INC; Dallas (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

DYCK-O'NEAL, INC is seeking a hands-on Senior Manager of Systems Development, Integration & Reporting to lead development, integration, reporting, and support of the company’s data platforms in Dallas, TX. The role requires coding, troubleshooting, and steering a team of SQL Report professionals.

You will design and maintain SQL solutions, APIs, SFTP workflows, and Power BI dashboards, while aligning projects with business priorities and vendor relationships.

Qualifications

• Seven+ years in systems development, data integration, BI, or related technical field.
• Strong project-management, documentation, and communication skills.

Responsibilities

• Lead design, development, testing, and support of internal applications and data processes.
• Develop and maintain integrations using APIs, REST, SFTP, flat files, and database connections.
• Create and optimize SQL queries, stored procedures, and reporting views.
• Oversee IT support tickets and production operations, ensuring issue resolution and reliability.
• Supervise SQL Report Developer/Report Builder and coordinate with vendors and stakeholders.

Education

Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or related discipline

Tools

Microsoft SQL Server

Power BI

SSRS/Report Builder

Job description

Note: This position is not eligible for visa sponsorship. Applicants must be authorized to work in the U.S. without sponsorship.

Position Summary

We are seeking a hands-on Senior Manager of Systems Development, Integration & Reporting to lead the development, integration, reporting, and support of the company’s business systems and data platforms.

This position will be responsible for designing and maintaining software solutions, database processes, system integrations, secure file-transfer workflows, reports, dashboards, and technical automations. The Senior Manager will also oversee assigned IT support requests and directly supervise a SQL Report Developer/Report Builder.

The ideal candidate combines strong technical development skills with the ability to manage employees, projects, vendors, system priorities, and business-user expectations. This is not solely a management or analytics position. The successful candidate must be comfortable personally writing code, troubleshooting systems, reviewing technical work, and resolving production issues.

Key Responsibilities

Systems Development and Coding

• Design, develop, test, implement, and support internal applications, database solutions, system enhancements, and process automations.
• Develop and maintain SQL queries, stored procedures, functions, views, database jobs, scripts, and data-processing routines.
• Build utilities and automated processes that reduce manual work and improve operational accuracy.
• Develop and maintain integrations using APIs, web services, SFTP, flat files, middleware, and database connections.
• Review existing applications and processes to identify opportunities for modernization, consolidation, or automation.
• Troubleshoot code, application, database, integration, and performance problems.
• Conduct code reviews and establish development standards for documentation, testing, security, error handling, and deployment.
• Maintain source control and development workflows using Git, Azure DevOps, GitHub, or similar platforms.
• Follow a structured software-development lifecycle covering requirements, design, development, testing, user acceptance, deployment, and post-production support.

Systems and Integration Management

• Serve as a technical owner for assigned business applications, databases, integrations, and reporting platforms.
• Design, develop, maintain, and monitor integrations between internal systems, external vendors, clients, and business partners.
• Manage secure SFTP processes, including authentication keys, encryption, naming conventions, file validation, scheduling, acknowledgments, exception handling, and failed-file recovery.
• Develop and support REST API, JSON, XML, CSV, fixed-width, and other system-to-system data exchanges.
• Monitor scheduled jobs, services, data feeds, interfaces, and automated processes for successful completion.
• Investigate failed integrations, missing files, duplicate records, reconciliation differences, and data-quality issues.
• Maintain system diagrams, interface specifications, source-to-target mappings, data dictionaries, credentials documentation, and recovery procedures.
• Coordinate system implementations, upgrades, conversions, testing, and vendor-supported changes.
• Ensure appropriate access controls, change management, backup procedures, and production safeguards are maintained.

Reporting, Analytics, and Business Intelligence

• Lead the development and administration of enterprise reports, dashboards, datasets, and analytical solutions.
• Create and optimize complex SQL queries, stored procedures, reporting views, and data extracts.
• Develop and support Power BI dashboards, semantic models, datasets, gateways, refresh schedules, security roles, and deployment processes.
• Support Microsoft SQL Server Reporting Services, Report Builder, Report Manager, and other reporting platforms.
• Establish consistent definitions for financial, operational, customer-service, and collection-related performance measures.
• Review reports and dashboards for accuracy, performance, security, usability, and compliance with business requirements.
• Investigate reporting discrepancies and reconcile results back to source systems.
• Work directly with Accounting, Operations, Compliance, Legal, and executive management to translate business requirements into dependable technical solutions.
• Establish reporting standards, naming conventions, testing requirements, documentation expectations, and release procedures.

IT Support and Production Operations

• Respond to and manage assigned IT service tickets involving business applications, databases, reports, integrations, user access, file transfers, and technical errors.
• Personally troubleshoot complex or high-priority production issues.
• Prioritize support requests based on urgency, business impact, compliance risk, and operational deadlines.
• Document investigation steps, root causes, resolutions, workarounds, and follow-up actions.
• Communicate clearly with employees regarding ticket status, expected resolution time, and final outcomes.
• Escalate infrastructure, network, cybersecurity, or vendor-related issues when appropriate.
• Identify recurring issues and implement permanent solutions, monitoring, or automation.
• Participate in incident response, business continuity, and disaster-recovery planning for assigned systems.

Leadership and Management

• Directly supervise a SQL Report Developer/Report Builder and potentially additional technical employees as the department grows.
• Assign and prioritize development, reporting, integration, maintenance, and support work.
• Review employee workloads, project status, ticket queues, deadlines, and completed work.
• Provide technical direction, coaching, training, performance feedback, and accountability.
• Review code, SQL queries, reports, documentation, testing results, and deployment plans before production release.
• Establish measurable expectations for quality, responsiveness, accuracy, documentation, and timely completion.
• Coordinate technical priorities with senior management and department leaders.
• Manage relationships with software vendors, consultants, hosting providers, and other technology partners.
• Assist with technology budgeting, vendor evaluations, system selections, contract reviews, and long-term planning.
• Develop a practical technology roadmap aligned with the company’s operational and financial priorities.

Required Qualifications

• Seven or more years of experience in systems development, database development, data integration, business intelligence, application support, or a related technical field.
• At least three years of experience supervising employees, leading technical teams, or formally directing technical work.
• Advanced SQL and relational database experience, preferably with Microsoft SQL Server.
• Demonstrated experience writing and troubleshooting complex queries, stored procedures, functions, views, and automated database processes.
• Experience developing and supporting APIs, SFTP workflows, flat-file exchanges, ETL processes, and system integrations.
• Experience with Microsoft Power BI and Microsoft reporting technologies such as SSRS, Report Builder, or Report Manager.
• Experience supporting production applications and resolving technical support tickets.
• Understanding of source control, code reviews, testing, deployment, and change-management practices.
• Ability to investigate problems across applications, databases, integrations, files, and reporting layers.
• Strong project-management, prioritization, documentation, and communication skills.
• Ability to explain technical issues and solutions to nontechnical employees and senior management.
• Ability to balance hands-on technical work with employee supervision and project leadership.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or a related discipline, or equivalent professional experience.
• Experience with Azure, Microsoft Fabric, Azure Data Factory, Azure DevOps, SQL Server Integration Services, or similar Microsoft technologies.
• Experience developing applications or integrations using C# and the .NET framework.
• Experience with Power BI data modeling, DAX, Power Query, gateways, row-level security, and deployment pipelines.
• Experience supporting financial, accounting, collection, customer-service, or regulated business systems.
• Familiarity with cybersecurity, data privacy, access controls, audit requirements, and secure development practices.
• Experience managing vendors, software implementations, system conversions, budgets, or technology roadmaps.
• Familiarity with Microsoft 365, Active Directory, Entra ID, SharePoint, Power Automate, and related business technologies.

Success in This Role

The successful candidate will be a senior technical leader who can personally solve complex systems and data problems while providing structure and direction to others. They will take ownership of applications, integrations, reports, production issues, and assigned IT requests from initial requirements through final resolution.

Success will be measured by system reliability, accurate reporting, timely resolution of technical issues, secure and dependable integrations, quality of technical documentation, successful project delivery, and the performance and development of the employees reporting to this position.