Joshua Sekyere

Data Analyst with 14+ years of experience supporting data-driven operations across government, healthcare, and financial environments, with expertise in Microsoft SQL Server, T-SQL, Power BI, DAX, Power Query, data modeling, reporting automation, and data quality management. Proven ability to transform complex, high-volume operational data into reliable analytical datasets, interactive dashboards, KPIs, and actionable business intelligence. Strong background in SQL development, database optimization, data validation, ETL/data transformation, dashboard development, reporting automation, and analytical problem-solving.

Experienced in translating business requirements into scalable reporting solutions, troubleshooting data and reporting issues, and partnering with technical and non-technical stakeholders to improve data accuracy, visibility, and operational decision-making.

DATA ANALYST - Maryland Department of Public Safety and Correctional Services (DPSCS) – Roxbury Correctional Institution - Maryland

(2023-12)

Develop and maintain SQL Server-based analytical solutions using T-SQL to extract, transform, validate, and analyze complex operational datasets supporting institutional management and decision-making.

• Write advanced SQL queries using JOINs, CTEs, subqueries, temporary tables, views, stored procedures, aggregations, and window functions to deliver accurate and reusable analytical datasets.
• Develop and maintain Power BI dashboards and management reports that transform operational data into interactive visualizations, KPIs, trends, and actionable business intelligence.
• Build Power BI data models using appropriate fact and dimension structures, relationships, calculated columns, and DAX measures to support scalable analytical reporting.
• Connect Power BI solutions to SQL Server and other authorized data sources while maintaining reliable data pipelines and scheduled refresh processes.
• Perform comprehensive data quality and validation analysis, identifying missing, duplicate, inconsistent, or incorrectly formatted records and working to reconcile discrepancies across data sources.
• Analyze historical and current datasets to identify trends, anomalies, operational patterns, and performance indicators requiring management attention.
• Develop recurring daily, weekly, monthly, quarterly, and annual reports while responding to ad-hoc analytical requests from management and operational stakeholders.
• Translate business and operational requirements into SQL queries, analytical datasets, Power BI dashboards, KPIs, and reporting solutions.
• Optimize SQL queries, data models, DAX calculations, and Power BI reports to improve performance, reliability, and usability.
• Develop reusable SQL queries, views, stored procedures, and standardized reporting datasets to improve consistency and reduce repetitive analytical work.
• Automate repetitive reporting and data-processing activities using SQL Server, Power BI, and other approved tools, reducing reliance on manual data manipulation.
• Troubleshoot SQL Server queries, database connections, Power BI refresh failures, DAX calculations, data relationships, filters, and reporting discrepancies.
• Investigate differences between source-system data and analytical outputs, performing root-cause analysis to ensure accurate reporting.
• Develop and maintain KPI reporting focused on operational performance, population activity, housing utilization, admissions, releases, transfers, incidents, and other institutional metrics.
• Provide analytical support to management by converting complex datasets into clear reports, dashboards, statistical summaries, and actionable insights.
• Partner with business and operational stakeholders to gather requirements, define reporting objectives, validate results, and improve existing analytical products.
• Explain analytical findings and data trends to non-technical stakeholders, helping management interpret data and make informed operational decisions.
• Maintain documentation covering data sources, SQL logic, business rules, Power BI datasets, DAX measures, reporting processes, and KPI definitions.
• Apply appropriate data-security and access-control practices when working with sensitive operational and personally identifiable information.
• Collaborate with IT and database personnel to investigate technical issues involving data sources, database performance, connectivity, and reporting infrastructure.
• Test SQL queries, data transformations, calculations, and Power BI report changes before deployment to production users.
• Support continuous improvement by identifying opportunities to improve data accuracy, reporting efficiency, automation, standardization, and analytical capabilities.

Bachelor of Commerce - University of Cape Coast, Ghana (2019)

Diploma in Business Accounting - Swedru School of Business, Ghana (2007)