Database Administrator - BI Developer at Pella Windows and Doors by Gunton Corporation

Bedford Heights, Ohio, United States -

Full Time

Start Date

Immediate

Expiry Date

27 Aug, 26

Salary

95000.0

Posted On

29 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Power BI, Power Query, DAX, SSRS, SQL Server, SharePoint, Data Modeling, Data Visualization, Web Development, API Integration, Data Validation

Industry

Wholesale Building Materials

Description

Description JOB SUMMARY Gunton Corporation, the largest independent distributor of Pella Windows & Doors in the country, is an innovative leader in our industry. Our business provides solutions for our customers' window and door needs and are key to our success since 1932. The Database Administrator – BI Developer is responsible for management of the data environment and transforming raw data from multiple sources into accurate, reliable, and well-structured data models that support business reporting. They design and maintain interactive dashboards and reports in Power BI using SQL and Power Query to surface key performance indicators and actionable insights. The role works closely with business stakeholders to understand requirements, answer ad hoc questions, and translate analytical findings into clear recommendations. RESPONSIBILITIES Manage the transition from SQL Server utilizing SSRS to Power BI Design, develop, and maintain interactive Power BI dashboards and reports that clearly communicate business insights Translate complex business requirements into data models, visuals, and KPIs within Power BI Connect, import, and transform data from multiple sources using Power Query, SQL, Excel, and cloud data sources Build and optimize data models using best practices for performance, scalability, and usability Write and maintain DAX measures and calculated columns to support advanced analytics and reporting needs Ensure data accuracy, consistency, and integrity through data validation and quality checks Collaborate with business stakeholders to understand reporting needs and provide actionable, data-driven recommendations Develop standardized reports and templates to promote consistent metrics and definitions across the organization Monitor and improve report performance, including refresh times and model optimization Support ad hoc data analysis requests and respond to evolving business questions Train and support end users on how to interpret dashboards and use Power BI effectively Develop and/or deploy ideas to enhance business functions via applications and web development Program applications and new interfaces using Visual Interdev as the API and SQL as the backend for Web development Handle Helpdesk calls related to your responsibilities from all Gunton computer users and document action taken on all issues (escalate unresolved issues to higher-level support) Management of hosted internal SharePoint environment. Document procedures and code for all applications according to set standards MINIMUM QUALIFICATIONS Experience managing a SQL Server environment Experience managing/developing SSRS reports Experience using Power Query or SQL for preparing, connecting, and transforming data Experience using Power BI for data visualization Experience managing SharePoint PREFERRED QUALIFICATIONS College degree Gunton Corporation is pleased to be an equal employment employer. Decisions concerning employment, transfers, and promotions are made upon the basis of the best qualified candidate without regard to color, race, religion, national origin, age, sex, sexual orientation, marital status, ancestry, status as a disabled or Vietnam era veteran or any other characteristic protected by law.

Responsibilities

The role is responsible for managing the data environment and transforming raw data into structured models to support business reporting. Key tasks include designing Power BI dashboards, maintaining SQL Server environments, and developing web interfaces via APIs.