Data Developer

Data Developer

3–6-month contract.

Phoenix, AZ 85007

Hybrid/First week on the office then once a month or as needed. Local candidates only. Development work must be completed September, or by mid-October at the latest.

Position Description

Imagine designing, developing, and maintaining state-wide data solutions supporting over one million K-12 students, plus hundreds of thousands of parents, teachers, and school staff in Arizona. The Arizona Department of Education is creating award-winning solutions using leading-edge technologies. This position will allow the ideal candidate to positively impact the projects and services that improve educational outcomes in our state.

POSITION SUMMARY:

This Data Developer position will be primarily responsible for development, enhancement, troubleshooting, and maintenance of data-focused software solutions using T-SQL, SSIS, PowerBI and other BI and Data Visualization tools, in support of various ADE business processes, data analysis, and reporting requirements. The successful developer will be solution-oriented, adapt to changing environments, and able to work with minimal defined requirements. Preferred candidates will be investigative, detail-oriented problem solvers who understand the power of data and the criticality of its quality.

RESPONSIBILITIES:

• Develop T-SQL for creation and maintenance of database objects and ETL solutions

• Develop interactive data visualizations, analytics, and dashboard solutions using, Power BI

• Support existing SSRS reporting

• Participate in all phases of the data solutions development and maintenance lifecycle

• Perform impact analysis on change requests, provide estimates for development efforts

• Participate in collaborative design and definition sessions

• Assist in documenting technical specifications from business requirement documents

• Support defect analysis and resolution

• Work with the lead Data Architect on implementation of data architecture principles to align and conform business capabilities

• Engage with the core data team in the design of efficient processes to load and manage data, data quality assessment to ensure that the quality of the source data will meet the information requirements, and development of business rules, data mappings, and transformation rules

• Assist in supporting multiple SQL Server data repositories, which may include documenting database architecture, analyzing datasets to identify missing, incomplete, or invalid information, and maintaining formal descriptions of data and data structures

• Work closely/collaboratively with cross-functional teams (Project Management, Business Analysis, Quality Assurance, Operations, etc.)

• Participate in various Agile/Scrum activities, such as backlog grooming, sprint planning, daily stand-ups, and sprint retrospectives

• Perform other duties as assigned or apparent

Skills Required

• SQL Server development using T-SQL, SSIS

• Intermediate- to advanced-level relational database modeling and design

• Power BI, SSRS and other BI and Data Visualization tools

• Ability to recognize and apply data systems development patterns and best practices

• Ability to excel in a collaborative and distributed team environment

• Ability to effectively collaborate with both technical and business experts alike

• Ability to effectively communicate with various levels of employees ranging from entry level to senior leadership

• Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs

• Ability to work with a minimal amount of direction while being proactive in keeping management and coworkers informed of project related issues

• Ability to work under pressure while maintaining focus on deadlines and deliverables

• Ability to manage multiple projects at the same time and shift priorities quickly

• Proven strong problem-solving skills, troubleshooting and root cause analysis

• Demonstrated ability to use discretion and make sound decisions

• Ability to maintain confidentiality of sensitive information

• Excellent written and verbal communication skills

Skills Preferred

• Working knowledge/practice in Data Vault data modeling methodology

• Microsoft Azure data technologies

Experience Required

• 5 or more years of professional Data Development experience with relational database systems, utilizing the required knowledge, skills, and abilities listed above.

Experience Preferred

• Experience working on an Agile/Scrum team

• Experience in the Education or Government sector

• Familiarity with Special Education programs, services, and monitoring