Cloud Data Warehouse Engineer | SQL & PowerBI Expert

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

Job summary

Memphis Shelby County Schools seeks a Database Engineer to develop, maintain, and extend the data warehouse and analytics architecture. You will transform disparate raw data into an accessible data store and enable intuitive PowerBI dashboards for analysts.

You will manage permissions, data transfers, and the health of the cloud SQL environment while collaborating with a managed services partner to ensure performance and security. Experience with SQL Azure is preferred.

Qualifications

• Bachelor's degree in Computer Science, Computer Information Services, Computer Queering, Management Information Systems or similar field plus 5 years related experience, for a total education/experience of 9 years.
• 5+ years of Microsoft SQL Server database administration experience preferred
• Experience managing a SaaS environment with a managed services vendor partnership a plus
• Experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools. 1 year of SQL Azure experience would be preferred
• Degree Equivalency Formula:
• Bachelor’s Degree= 4 years plus required years of experience.
• Master’s Degree= 2 years plus required years of experience. Where Master’s degrees are required, years for Bachelor’s Degrees must be included.

Responsibilities

• Build/maintain table structure that aligns with date standard, delivers intuitive PowerBI visualizations and empowers ad hoc querying and analysis by business analysts.
• Manage permissions, data transfers, overall health and performance of the integration management solution and MS SQL warehouse in a cloud environment.
• Collaborate with vendor managed services team to maintain 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 administration

Data analysis

Cloud environment management

Education

Bachelor's degree in Computer Science / CIS / MIS or similar

Tools

Microsoft SQL Server

Azure SQL

PowerBI

Job description

Memphis Shelby County Schools seeks a Database Engineer to develop, maintain, and extend the data warehouse and analytics architecture. You will transform disparate raw data into an accessible data store and enable intuitive PowerBI dashboards for analysts.

You will manage permissions, data transfers, and the health of the cloud SQL environment while collaborating with a managed services partner to ensure performance and security. Experience with SQL Azure is preferred.