Job Description
Job Description
ROLE AND PURPOSE :
Wrangle, clean, and transform complex data from multiple data sources into deliverables in various formats to drive strategic decision-making across the district. Continuously improve data quality and processes. Provide excellent customer service to other departments. The ideal candidate will combine strong technical skills with customer service skills to deliver high-quality data results and reporting solutions.
QUALIFICATIONS :
Education / Certification :
- Bachelor's Degree or equivalent experience
Experience :
Three years of SQL programming experience in a database environmentThree years of experience with database design, implementation, and performance tuningSPECIAL KNOWLEDGE AND SKILLS (REQUIRED) :
Strong SQL skills working with Microsoft SQL Server and IBM DB2 databasesExperience with Database tools including SQL Management StudioStrong Excel skillsStrong analytical and problem-solving skillsAbility to organize and prioritize workloadExcellent oral and written communications skillsProficient in creating documentation and providing training as requiredPreferred)Experience with Power BI and SQL Serve Integration Services (SSIS)Preferred)Experience with Frontline ERP / SIS software (Formerly Prologic TEAMS)Preferred)Knowledge of SQL Server administration and Windows server administrationPreferred)Experience with Microsoft Visual Studio, C#, ASP.NET Core, HTML, CSS, and JavaScriptPreferred)Promote and maintain positive morale among department, district, and campus employeesPreferred)Continually look for ways to improve processes / procedures that result in increased efficiencyMAJOR RESPONSIBILITIES AND DUTIES :
Identifies, prioritizes, and executes data reporting processes including data retrieval, preprocessing, analyses, visualization, and reporting for varying levels of stakeholders with fluctuating degrees of ambiguity.Wrangle data from multiple data sources (e.g., SQL Server, independent spreadsheets, external databases, etc.) into a single source aligned to project needs.Create and maintain SQL views, functions, and stored proceduresAutomate processes using SQL, PowerShell, batch script, and other programming languagesDesign, build, and maintain Power BI reports used to monitor the performance of cross-departmental initiativesDocument data processing routines for recurring data reports to decrease turnaround time, increase accuracy, establish standardization, and provide training as necessaryIdentify problems and areas of improvementProvide outstanding customer service on the phone, in person, and through written communicationAppropriately escalate unresolved issues and / or concerns to next level of supportPerform other duties as may be assigned by supervisor