Lead Analytics & Data Integration Manager (SQL + Power BI)

DYCK-O'NEAL, INC

Dallas (TX)

On-site

USD 110,000 - 140,000

Full time

32 hours ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

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