Integration, Analytics & Reporting Services Manager

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

Job summary

DYCK-O'NEAL, INC is seeking an Integration, Analytics & Reporting Services Manager to oversee data integrations, analytical solutions, enterprise reporting, and IT support services. This role develops and maintains integrations and reports, responds to IT tickets, and supervises a SQL Report Developer/Report Builder.

The ideal candidate has strong SQL skills, experience with SFTP-based file transfers, and familiarity with Power BI and Microsoft technologies.

Qualifications

• Strong working knowledge of SQL and relational databases.
• Experience writing, reviewing, optimizing, and troubleshooting complex SQL queries.
• Experience developing or supporting reports using SSRS, Microsoft Report Builder, or similar tools.
• Familiarity with SFTP protocols, secure file transfers, and file-processing workflows.
• Experience developing or supporting Microsoft Power BI dashboards and reports.
• Familiarity with Microsoft products and technologies, such as SQL Server, Microsoft 365, Excel, Power Automate, or Azure.
• Experience managing IT tickets through a help-desk or service-management platform.
• Understanding of data integration, transformation, validation, and reconciliation concepts.
• Previous experience supervising, mentoring, or providing technical direction to staff.
• Strong analytical, organizational, and problem-solving abilities.
• Ability to translate business requirements into effective technical solutions.
• Strong written, verbal, and customer-service skills.
• Ability to manage multiple priorities and work both independently and collaboratively.

Responsibilities

• Design, develop, maintain data integrations between systems.
• Create and optimize SQL queries, stored procedures, views, and data extracts.
• Manage secure file transfers using SFTP, including scheduling, monitoring, file validation, and troubleshooting.
• Develop and maintain Power BI dashboards, reports, datasets, and data models.
• Create, publish, schedule, and manage operational and analytical reports.
• Support Microsoft reporting technologies, including SSRS, Report Builder, and Report Manager.
• Analyze data to identify trends, exceptions, and process-improvement opportunities.
• Validate report results and investigate data-quality or reconciliation issues.
• Gather reporting and integration requirements from business stakeholders.
• Maintain technical documentation, data mappings, report definitions, and support procedures.
• ]( ]),
• CoT_job_summary_short
• COMPANY NAME: DYCK-O'NEAL, INCKEY POINTS: Data integrations, Power BI reporting, staff supervision
• job_summary_short":"<p>DYCK-O'NEAL, INC is seeking an Integration, Analytics & Reporting Services Manager to oversee data integrations, analytical solutions, enterprise reporting, and IT support services.</p><p>The ideal candidate will design, develop, and maintain integrations, Power BI dashboards, and reports while supervising a SQL Report Developer/Report Builder. Strong SQL, SFTP, and Microsoft technologies experience are essential, with leadership to manage staff and priorities.</p>" ,
• contract_type
• fulltime
• location_type
• on site
• remote_scope
• null
• perks
• []
• stated_min
• null
• stated_max
• null
• stated_absolute
• null
• salary_estimation_cot
• Integration, Analytics & Reporting Services Manager in Dallas, TX with 8+ years IT leadership: market rate roughly $110k–$140k gross per year.
• estimated_low
• 110000
• estimated_medium
• 125000
• estimated_high
• 140000
• currency
• USD
• frequency
• yearly
• bonus
• null
• tax
• gross
• application_email
• null
• job_end_date
• null
• contact_person
• null
• hiring_department_name
• IT Services

Skills

SQL

SSRS

Power BI

Data integration

Report Builder

SFTP

Staff supervision

Stakeholder communication

Analytical thinking

Customer service

Education

Bachelor's degree in Information Systems

Bachelor's degree in Computer Science

Data Analytics degree

Tools

SSRS

Microsoft Report Builder

SQL Server

Power BI

Azure

Microsoft 365

Power Automate

Excel

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 an Integration, Analytics & Reporting Services Manager to oversee data integrations, analytical solutions, enterprise reporting, and related IT support services. This position will develop and maintain integrations and reports, respond to assigned IT support tickets, and supervise a SQL Report Developer/Report Builder.

The ideal candidate has strong SQL skills, experience with SFTP-based file transfers, and familiarity with Power BI, Microsoft technologies, and report-management tools. This role requires both hands-on technical expertise and the ability to manage staff, priorities, and service requests.

Key Responsibilities

Integration, Analytics, and Reporting

• Design, develop, maintain, and monitor data integrations between internal and external systems.
• Create and optimize SQL queries, stored procedures, views, and data extracts.
• Manage secure file transfers using SFTP, including scheduling, monitoring, file validation, and troubleshooting.
• Develop and maintain Power BI dashboards, reports, datasets, and data models.
• Create, publish, schedule, and manage operational and analytical reports.
• Support Microsoft reporting technologies, including SQL Server Reporting Services (SSRS), Report Builder, and Report Manager.
• Analyze data to identify trends, exceptions, and process-improvement opportunities.
• Validate report results and investigate data-quality or reconciliation issues.
• Gather reporting and integration requirements from business stakeholders.
• Maintain technical documentation, data mappings, report definitions, and support procedures.

IT Support and Ticket Management

• Respond to assigned IT service tickets promptly and professionally.
• Troubleshoot reporting, database, integration, file-transfer, application, and user-access issues.
• Document ticket activity, investigation steps, solutions, and follow-up actions.
• Prioritize requests based on urgency, business impact, and established service-level expectations.
• Escalate complex infrastructure, security, or application issues to the appropriate technical teams.
• Identify recurring problems and recommend permanent solutions, automation, or process improvements.
• Communicate ticket status, expected resolution times, and outcomes clearly to end users and stakeholders.

Leadership and Supervision

• Directly supervise a SQL Report Developer/Report Builder.
• Assign and prioritize report-development, maintenance, and support requests.
• Review SQL queries, reports, dashboards, and technical documentation for accuracy, quality, security, and performance.
• Provide coaching, technical guidance, performance feedback, and professional development support.
• Balance staff workloads and ensure reporting requests are completed within agreed-upon timelines.
• Establish and maintain reporting-development standards, naming conventions, testing procedures, and documentation requirements.
• Coordinate priorities with business leaders, IT teams, vendors, and other stakeholders.

Required Qualifications

• Strong working knowledge of SQL and relational databases.
• Experience writing, reviewing, optimizing, and troubleshooting complex SQL queries.
• Experience developing or supporting reports using SSRS, Microsoft Report Builder, or similar tools.
• Familiarity with SFTP protocols, secure file transfers, and file-processing workflows.
• Experience developing or supporting Microsoft Power BI dashboards and reports.
• Familiarity with Microsoft products and technologies, such as SQL Server, Microsoft 365, Excel, Power Automate, or Azure.
• Experience managing IT tickets through a help-desk or service-management platform.
• Understanding of data integration, transformation, validation, and reconciliation concepts.
• Previous experience supervising, mentoring, or providing technical direction to staff.
• Strong analytical, organizational, and problem-solving abilities.
• Ability to translate business requirements into effective technical solutions.
• Strong written, verbal, and customer-service skills.
• Ability to manage multiple priorities and work both independently and collaboratively.

Preferred Qualifications

• Experience with ETL or data-integration tools, processes, and scheduling platforms.
• Familiarity with APIs and data-exchange formats such as CSV, XML, and JSON.
• Experience with Power BI data modeling, DAX, Power Query, and gateway management.
• Knowledge of Microsoft Azure data and analytics services.
• Experience with automated job scheduling, monitoring, and incident resolution.
• Familiarity with IT service-management practices and service-level agreements.
• Knowledge of data governance, security, privacy, and regulatory requirements.
• Bachelor's degree in Information Systems, Computer Science, Data Analytics, or a related field—or equivalent professional experience.

Success in This Role

The successful candidate will be a hands-on technical leader who can manage reporting and integration responsibilities while providing responsive support to end users. They will set clear priorities for their direct report, take ownership of IT tickets, communicate effectively with technical and nontechnical stakeholders, and ensure that integrations, data, and reports are accurate, secure, timely, and reliable.