Database Architect 1

Title: Database Architect 1

Fully Remote

Skills test will be sent out before interview

Top Skills:

1. SQL Server Integration Services (SSIS) package development

2. SQL Server stored procedure development

3. Ability to multitask

4. Ability to communicate

Description of Position: This contractor is responsible for providing critical customer service support. This position will be critical in advancing the efforts by developing implementing protecting and visualizing federal state and publicly reported data from the data architecture. This position will support leadership and other stakeholders by ensuring data are timely accurate protected and made available for consumers to use to make betterinformed decisions.

Major Responsibilities:

• Manages and/or provides data sets for several data visualization platforms including the Report Card and the Open Data Portal using data tools such as Microsoft Excel Microsoft SQL Server Microsoft SQL Server Reporting Services (SSRS) and Microsoft Power BI and developer tools such as Microsoft Visual Studio.
• Fulfills ad hoc data requests and those regular data requests established through data sharing agreements (DSAs) and memoranda of understanding (MOUs).
• Assists Team Lead with managing assigned educational data domains and provide support to Department and internal data staff.
• Continuously improves and expands data reporting options to meet Departmental needs.
• Engages with users and internal staff to ensure implemented solutions satisfy business requirements and are delivered in a timely manner.

Essential Qualifications:

Education:

• Option 1: Bachelors degree in the areas of accounting business finance mathematics statistics engineering computer science data science or related field.
• Option 2: Associate degree in the areas of accounting business mathematics statics engineering computer science data science or related field and at least 4 years experience in one of more of the following areas: database administration database development database architecture data collection data reporting data visualization data extraction data transformation or data loading.
• Option 3: At least 8 years experience in one of more of the following areas: database administration database development database architecture data collection data reporting data visualization data extraction data transformation or data loading.

Experience:

• A minimum of three (3) years of experience with large data sets preferably using Microsoft SQL Server relational databases and enterprise information systems.
• Demonstrated proficiency with analytical software and in creating and modifying structured query language (SQL) SQL Server Reporting Services (SSRS) or other programming languages and tools.
• Experience managing multiple projects while ensuring that goals and priorities are met.
• Experience with Microsoft Power BI a plus but not required.
• General knowledge of education related data domains a plus but not required.

Skills:

• Proven experience in moving data from one source to another.
• Strategic mindset including demonstrated ability to problemsolve effectively and efficiently.
• Demonstrated ability to translate business requirements in data specifications.
• Good project management skills in public nonprofit and/or private sectors; track record of delivering results against tight deadlines.
• Strong oral and written communication skills particularly in translating data into easytointerpret actionable reports presentations and findings.
• Must be proficient in performing responsibilities with minimal supervision.
• Must be skilled in setting priorities working under pressure and working in collaboration with others.
• Must be able to proactively solve problems with professionalism.
• Must possess excellent interpersonal skills and the ability to deal with staff in a tactful congenial and personal manner.
• Must be experienced in exercising discretion and confidentiality in all professional duties.

Notes:

A criminal background check is required.