Apply on Employer Site

Keystone Custom Homes · 2 hours ago

SQL & PowerBI Specialist

Lancaster, PA

Full-time

Onsite

Senior Level

5+ years exp

Keystone Custom Homes is seeking a talented and experienced IT Specialist with strong expertise in Power BI, Microsoft SQL Server, and modern analytics techniques. The role focuses on leveraging analytical and data science skills to transform complex datasets into actionable insights, while developing and maintaining high-quality Power BI reports and SQL database structures.

Real Estate

Responsibilities

Design, develop, and maintain high-quality Power BI reports and dashboards using SQL database tables, views, and analytical models

Analyze complex, multi-source datasets to uncover trends, patterns, and actionable insights that support strategic and operational decision-making

Apply advanced analytical techniques, including statistical analysis and AI-assisted methods (e.g., forecasting, anomaly detection, automated insights), to enhance reporting and business intelligence

Collaborate with business stakeholders and technical teams to translate analytical and reporting requirements into intuitive, user-friendly Power BI solutions

Develop, optimize, and maintain Microsoft SQL Server database structures, writing complex queries, views, stored procedures, and performance-optimized logic

Troubleshoot, refactor, and enhance legacy reports and data models to improve reliability, performance, and analytical value

Partner with Web Development and other technical teams to ensure seamless integration of data, analytics, and visual components where appropriate

Debug and resolve data, reporting, and performance issues, delivering timely and effective solutions

Continuously learn and stay current with emerging trends in data science, AI, analytics, and business intelligence technologies

Qualification

Power BISQL ServerData AnalysisData ModelingDAXQuery OptimizationAgile/ScrumCI/CDProblem SolvingCollaboration

Required

Bachelor's degree in Computer Science, Data Science, Information Systems, Analytics, or equivalent demonstrated experience

Minimum of 5 years of professional experience in analytics, business intelligence, or data-focused roles

Strong background in data analysis, data modeling, and translating data into business insights

Demonstrated experience working independently and collaboratively in a fast-paced, deadline-driven environment

Advanced knowledge of SQL Server database architecture, including working with both legacy and modern data environments

Strong experience navigating complex schemas to connect and prepare data for analytical use

Proficiency with SQL, including: Stored Procedures, Functions, Triggers, Query optimization and performance tuning

Advanced Power BI development experience, including: Creation of complex, enterprise-grade reports and dashboards across multiple SQL Server data sources, Modification, optimization, and modernization of legacy Power BI reports, Data modeling, DAX, and best practices for performance and usability