Data Developer 1.19

Focused HR Solutions•Phoenix, AZ

2h•Hybrid

About The Position

The Data Developer will create solutions using SSIS, SSRS, and T-SQL to support the various ADE business process and reporting requirements. The preferred candidate will be investigative, detail-oriented, problem-solving, and understand the power of data and the criticality of its quality.

Requirements

Bachelor’s Degree in CS or MIS or equivalent experience.
3 or more years of experience working with relational databases.
Minimum 3 years of experience in SQL Server T-SQL, SSIS, SSRS.
Demonstrated ability to use discretion and make sound decisions.

Nice To Haves

Experience in the education industry.
Experience working on an Agile/Scrum team.
Experience developing with Azure data technologies.
Ability to effectively collaborate with developers and business experts.
Ability to excel in a collaborative and distributed team environment.
Ability to work with a minimal amount of direction while being proactive in keeping their management informed of project-related issues.
Ability to work under pressure.
Ability to respectfully question ideas and share a point of view with others in support of the business requirements and needs.
Ability to effectively communicate with various levels of employees ranging from entry-level to senior leadership.
Ability to manage multiple projects at the same time and shift priorities quickly.
Proven strong problem-solving skills, troubleshooting, and root cause analysis.
Excellent written and verbal communication skills.
Strong aspiration to learn modern technologies.

Responsibilities

Develop ETL solutions using SQL Server Integration Services (SSIS).
Develop reports using SQL Server Reporting Services (SSRS).
Create T-SQL scripts for database objects and functionality.
Perform impact analysis on change requests.
Assist in documenting technical specifications from business requirement documents.
Participate in all phases of database development and maintenance lifecycle.
Support defect analysis and resolution.
Assist the team in the design of efficient ETL processes to load and manage data, including a data quality assessment to ensure the quality of the source data will meet the information requirements, develop business rules, data mappings, and transformation rules.
Participate in data mapping documentation sessions.
Responsible for maintaining a formal description of data and data structures.
Assist the Lead Database Architect with the implementation of data architecture principles to align and confirm business capabilities.
Assist in supporting multiple SQL Server data repositories, which may include documenting database architecture and analyzing datasets to identify missing, incomplete, or invalid information.
Performs other duties as assigned or apparent.