Cloud Data Warehouse Engineer - Power BI & SQL Specialist

Memphis Shelby County Schools; Memphis (TN); On-site; USD 73,000 - 106,000; Full time

Job summary

Memphis Shelby County Schools is seeking a Database Engineer to develop, maintain, and extend the data warehouse and analytics architecture to meet reporting needs. The role collaborates with decision analytics consultants and the iPaaS platform to transform disparate data into a accessible data store.

Responsibilities include building table structures, hardening security, managing the cloud-based MS SQL warehouse, and enabling ad hoc analysis with PowerBI.

Qualifications

• Bachelor's degree in Computer Science, Computer Information Services, Computer Queering, Management Information Systems or similar field.
• 5 years related experience; total education/experience of 9 years.
• 5+ years of Microsoft SQL Server database administration experience preferred.
• Experience with SaaS environment with a managed services vendor partnership a plus.
• 1 year of SQL Azure experience would be preferred.

Responsibilities

• Build/maintain table structures aligned with date standard for PowerBI.
• Manage permissions, data transfers, health and performance of the integration platform and MS SQL warehouse in a cloud environment.
• Collaborate with vendor managed services team to maintain a structured, high performing cloud environment.
• Identify and execute database improvement opportunities to provide a superior experience for end users performing ad hoc analysis.
• Develops, promotes, and deploys stored procedures that improve data accessibility and optimize new reporting requirements.
• Determines, enforces and documents database policies, procedures and standards.
• Completes tests and evaluations regularly to ensure data security, privacy and integrity.
• Performs all other related duties as assigned or directed.

Skills

SQL Server

Performance tuning

Ad hoc analysis

Data security

Education

Bachelor's degree in Computer Science / MIS

Tools

Azure SQL

Job description

Memphis Shelby County Schools is seeking a Database Engineer to develop, maintain, and extend the data warehouse and analytics architecture to meet reporting needs. The role collaborates with decision analytics consultants and the iPaaS platform to transform disparate data into a accessible data store.

Responsibilities include building table structures, hardening security, managing the cloud-based MS SQL warehouse, and enabling ad hoc analysis with PowerBI.