Data Developer

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., * 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.

• 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.

PREFERRED:

• Experience in the education industry.
• Experience working on an Agile/Scrum team.
• Experience developing with Azure data technologies.

SOFT SKILLS:

• 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.