Analyst IT Report -Technology Development
Apply NowCompany: Shelby County Schools
Location: Memphis, TN 38109
Description:
Company Description
Destination 2025, our 10-year strategic plan, is designed not only to improve the quality of public education, but also to create a more knowledgeable, productive workforce and ultimately benefit our entire community.
What will success look like in 2025?
By 2025, 80 percent of seniors will be on track to learn in a postsecondary classroom or enter the workforce straight out of high school; 90 percent of students will earn their high school diploma on time; and every student will enroll in a postsecondary opportunity college or career-ready.
We believe:
How will we get there?
Teachers, parents and community leaders have worked with us to develop the high-leverage priorities to focus all of our efforts and resources over the next 10 years - early literacy, post-secondary readiness, teacher and staff development, high quality schools and community engagement.
Job Description
Purpose and Scope 1. Work with the Leadership and Department to gather requirements to design, develop, test and deploy reports and strategic and operational dashboards.
2. Responsible for day-to-day designs, developments, monitoring and support of assigned reports and dashboards.
3. Develops Excel, SQL, or application specific reports.
4. Pulls data from various data sources and combine into a single report, either via Data Warehouse or through direct integration.
5. Builds reports to help identify data patterns to scrub/clean data and maintain good data hygiene.
6. Provide database development expertise (stored procedures, views etc.) for application development, design, implementation, verification, debugging, optimizing and maintenance of SQL Server database objects and process for the application, reporting and interface modules
7. Perform report development with strong stored procedure skills utilizing SQL Server 2008 R2, 2005, 2000
8. Design code and test SQL Server reporting services components (user interface, Stored Procedures, Tables etc.)
9. Experience in complete development lifecycle from requirements through deployment and maintenance
10. Provides end-user training on report writing software and support users in ad-hoc report creation.
11. Develops and applies solutions to complex problems which require the regular use of ingenuity and creativity and competency in SQL and EXCEL.
12. Converses with management to determine type, scope, and purpose of analyses. May lead a team in the effort. Works with other analysts and management to complete assigned project work.
13. Deals with complex problems and provides solutions that are innovative and ingenious, achieving quality and work process improvements.
14. May ensure that the workgroup's goals and activities are in sync with and support the broader goals and objectives of the organization; and that the execution of responsibilities are in accordance to lawful and ethical standards.
15. Directs and assists in the preparation and maintenance of a variety of narrative and statistical repmis, records, correspondence, and files related to assigned service, activities, and operations; provides for appropriate research and compiles reports, as needed.
16. Performs other related duties as assigned or directed.
Qualifications
Essential Job Functions Delivers at a high level of competency Information Technology software development. Assesses and performs analysis on data, and prepares data to facilitate Technical Services functions of organization. Responsibilities require understanding of both theory and practice. Minimum Qualifications Graduation from an accredited college or university with a Bachelor's Degree in Computer Science plus an additional four (4) years related experience, or equivalent, for a total education/experience of 8 years. Prefer experience with MS SQL Server 2008 R2, 2005 Reporting Services, Integration Services. Prefer 2+ years' experience in use and application of stored procedures, DTS package, SSIS package, and Crystal reports. Experience with multi-dimensional Data Sources, reporting tool such as MS Reporting services, Tableau 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. Knowledge, Skills, and Abilities Basic understanding and familiarity with database structure (particularly SQL).
Strong analytic and problem-solving skills, with the ability to swiftly and accurately understand complex data and perform analysis
Skill in developing data-supported solutions and using fact-based logic; ability to translate complex analysis in easy-to-understand manner and present to a broad audience
Strong written and verbal communication skills
Outstanding leadership skills and ability to build high-performing teams through both recruitment and selection and professional development
Ability to tackle the operational challenges of the merged school district in a complex, changing political and educational environment
Ability to manage daily administrative tasks without losing sight of long-term goals and planning
Additional Information
Why Memphis?
Shelby County
Schools-one of the 25 largest school districts in the nation-is located in
Memphis, TN, a city
known for its great food, original music, professional sports, high-quality
arts in the most affordable urban setting in the nation. Not only that, but Memphis is a hotbed and national leader
for groundbreaking work in education.
Benefits:
SCS
benefits include the following:
Destination 2025, our 10-year strategic plan, is designed not only to improve the quality of public education, but also to create a more knowledgeable, productive workforce and ultimately benefit our entire community.
What will success look like in 2025?
By 2025, 80 percent of seniors will be on track to learn in a postsecondary classroom or enter the workforce straight out of high school; 90 percent of students will earn their high school diploma on time; and every student will enroll in a postsecondary opportunity college or career-ready.
We believe:
- Proficiency in literacy is the foundation of all learning, and we are committed to making that a top priority for students.
- As we raise expectations of our students, innovative and varied practices are needed in the classroom to provide students with learning experiences that will prepare them for life after graduation.
- Successful teachers and leaders are the drivers for student success. That means continuing to provide educators with the support and tools needed to make classroom teaching impactful.
- Although 2025 is in the future, the work is happening to produce engaged and prepared students.
- By devoting time and other resources to schools, community members can have a direct impact on student achievement.
How will we get there?
Teachers, parents and community leaders have worked with us to develop the high-leverage priorities to focus all of our efforts and resources over the next 10 years - early literacy, post-secondary readiness, teacher and staff development, high quality schools and community engagement.
Job Description
Purpose and Scope 1. Work with the Leadership and Department to gather requirements to design, develop, test and deploy reports and strategic and operational dashboards.
2. Responsible for day-to-day designs, developments, monitoring and support of assigned reports and dashboards.
3. Develops Excel, SQL, or application specific reports.
4. Pulls data from various data sources and combine into a single report, either via Data Warehouse or through direct integration.
5. Builds reports to help identify data patterns to scrub/clean data and maintain good data hygiene.
6. Provide database development expertise (stored procedures, views etc.) for application development, design, implementation, verification, debugging, optimizing and maintenance of SQL Server database objects and process for the application, reporting and interface modules
7. Perform report development with strong stored procedure skills utilizing SQL Server 2008 R2, 2005, 2000
8. Design code and test SQL Server reporting services components (user interface, Stored Procedures, Tables etc.)
9. Experience in complete development lifecycle from requirements through deployment and maintenance
10. Provides end-user training on report writing software and support users in ad-hoc report creation.
11. Develops and applies solutions to complex problems which require the regular use of ingenuity and creativity and competency in SQL and EXCEL.
12. Converses with management to determine type, scope, and purpose of analyses. May lead a team in the effort. Works with other analysts and management to complete assigned project work.
13. Deals with complex problems and provides solutions that are innovative and ingenious, achieving quality and work process improvements.
14. May ensure that the workgroup's goals and activities are in sync with and support the broader goals and objectives of the organization; and that the execution of responsibilities are in accordance to lawful and ethical standards.
15. Directs and assists in the preparation and maintenance of a variety of narrative and statistical repmis, records, correspondence, and files related to assigned service, activities, and operations; provides for appropriate research and compiles reports, as needed.
16. Performs other related duties as assigned or directed.
Qualifications
Essential Job Functions Delivers at a high level of competency Information Technology software development. Assesses and performs analysis on data, and prepares data to facilitate Technical Services functions of organization. Responsibilities require understanding of both theory and practice. Minimum Qualifications Graduation from an accredited college or university with a Bachelor's Degree in Computer Science plus an additional four (4) years related experience, or equivalent, for a total education/experience of 8 years. Prefer experience with MS SQL Server 2008 R2, 2005 Reporting Services, Integration Services. Prefer 2+ years' experience in use and application of stored procedures, DTS package, SSIS package, and Crystal reports. Experience with multi-dimensional Data Sources, reporting tool such as MS Reporting services, Tableau 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. Knowledge, Skills, and Abilities Basic understanding and familiarity with database structure (particularly SQL).
Strong analytic and problem-solving skills, with the ability to swiftly and accurately understand complex data and perform analysis
Skill in developing data-supported solutions and using fact-based logic; ability to translate complex analysis in easy-to-understand manner and present to a broad audience
Strong written and verbal communication skills
Outstanding leadership skills and ability to build high-performing teams through both recruitment and selection and professional development
Ability to tackle the operational challenges of the merged school district in a complex, changing political and educational environment
Ability to manage daily administrative tasks without losing sight of long-term goals and planning
Additional Information
Why Memphis?
Shelby County
Schools-one of the 25 largest school districts in the nation-is located in
Memphis, TN, a city
known for its great food, original music, professional sports, high-quality
arts in the most affordable urban setting in the nation. Not only that, but Memphis is a hotbed and national leader
for groundbreaking work in education.
Benefits:
SCS
benefits include the following:
- State
retirement plan - Paid
holidays - Paid
vacation - Paid
sick days - Heath
Care Insurance (e.g. Medical, Dental)