SQL Report & Database Developer - Power BI & Analytics

DYCK-O'NEAL, INC

Dallas (TX)

On-site

USD 65,000 - 100,000

Full time

6 days ago

Be an early applicant

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

DYCK-O'NEAL, INC. is seeking a SQL Report Writer and Database Developer to design, develop, and optimize SQL databases, reports, dashboards, and data solutions while supporting IT across multiple business systems and data sources.

The successful candidate will write complex queries, maintain tables and views, build Power BI reports and Power Query transformations, and produce accurate, timely reports from written descriptions and business requirements.

Qualifications

Associate’s or bachelor’s degree in Information Technology, Computer Science, Data Analytics, Business Intelligence, or a related field, or equivalent professional experience.
Experience writing SQL queries and developing database reports.
Experience working with relational databases and multiple software systems.
Strong Microsoft Excel skills, including pivot tables, advanced formulas, lookups, charts, and data analysis.
Experience developing reports and dashboards in Microsoft Power BI.
Working knowledge of Power Query and DAX.
Experience providing technical support or resolving IT service tickets.
Ability to follow detailed written and verbal instructions.
Ability to interpret a report description and turn it into a complete, accurate report.
Ability to understand business requirements and translate them into technical reporting solutions.
Strong analytical, problem-solving, and troubleshooting skills.
High attention to detail and commitment to data accuracy.
Strong written and verbal communication skills.
Ability to document work clearly and consistently.
Ability to manage multiple assignments, priorities, systems, and deadlines.
Ability to work independently while following management direction and established procedures.

Responsibilities

Write, test, optimize, and maintain SQL queries, stored procedures, views, and functions.
Develop and maintain database tables, relationships, and other database objects.
Work with multiple business systems, applications, databases, and data sources.
Combine, compare, and validate data from different systems.
Create scheduled, recurring, and ad hoc reports based on written descriptions, verbal instructions, and business requirements.
Follow management direction and translate reporting requests into accurate, useful reports.
Ask appropriate questions when requirements are unclear or incomplete.
Design and maintain Power BI reports, dashboards, data models, and visualizations.
Write Power Query transformations and DAX calculations for Power BI.
Build and maintain advanced Excel reports using formulas, pivot tables, charts, lookups, and data connections.
Extract, clean, validate, and analyze data from multiple sources.
Verify report calculations, filters, totals, formatting, and overall accuracy before delivery.
Troubleshoot report errors, data discrepancies, system issues, and database performance problems.
Assist employees with IT support tickets related to software, systems, reports, databases, user access, and general technical issues.
Document IT tickets, troubleshooting steps, solutions, and follow-up activities.
Escalate unresolved or high-priority technical issues to the appropriate manager or support resource.
Communicate report status, technical issues, delays, and completed work clearly and promptly.
Ensure reports are accurate, consistent, secure, and delivered by established deadlines.
Document database structures, report logic, data definitions, and development processes.
Support report automation and process-improvement initiatives.
Follow established data-security, privacy, access-control, and IT support procedures.
Perform other database, reporting, and IT support duties assigned by the Manager.