BI Data Developer

Position: BI Data DeveloperLocation: Phoenix, AZ (Onsite) Skills: BI Data Developer, Data Vault data modeling, Data Vault, data modeling, Azure, Data Development, relational database, Agile/Scrum, Power BI, Data Visualization, SQL Server development, SQL Server, T-SQL, SSIS, query, SQL Indexing, database, performance tuning, ETL, data management, visualization, data analysis Job Description: Must have:5 or more years of professional Data Development experience with relational database systems, utilizing the required knowledge, skillsBachelor degree in IT or related field preferredMust be local to the Phoenix area as this role is onsiteDemonstrated experience and capability developing in Power BI and other BI and Data Visualization tools  SQL Server development using T-SQL and SSIS, plus intermediate- to advanced-level relational database modeling and designStrong understanding of query optimization, SQL Indexing, and other database performance tuning concepts and techniques Ability to recognize and apply data systems development patterns and best practices Ability to proactively solve complex problems, applying creative solutions to ensure business needs are most effectively met Proven strong problem-solving skills, troubleshooting and root cause analysis Demonstrated ability to use discretion and make sound decisions  Nice to have: Working knowledge/practice in Data Vault data modeling methodology Microsoft Azure data technologiesExperience working on an Agile/Scrum team  Experience in the Education and/or Government sector  Familiarity with the Ed-Fi, CEDS, and/or SIF data standards and specifications 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 BI Data Developer position will be primarily responsible for development, enhancement, troubleshooting, and maintenance of data-focused software solutions using Power BI, T-SQL, SSIS, and other data management and visualization tools as needed to support 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 interactive data visualizations, analytics, dashboards, and reporting solutions using Power BI and associated data management and BI toolsDevelop T-SQL for creation and maintenance of database objects and data manipulation functionality (tables, views, functions, stored procedures, scripts, etc.)Develop ETL solutions using SQL Server Integration services (SSIS) for preparation and maintenance of data sets as needed for reporting and data visualization functionsParticipate in all phases of the BI and data solutions development and maintenance lifecycleParticipate in collaborative design and definition sessions, engaging with business analysts and stakeholders to understand requirements and contribute to functional specificationsPerform impact analysis on change requests, providing estimates for development effortsAssist in documenting technical specifications from business requirements and maintaining system design and reference documentationWork with the lead Data Architect on implementation of data architecture principles to align and conform with business capabilitiesEngage 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 rulesAssist 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 structuresSupport production systems, participating in defect analysis and resolutionWork closely/collaboratively with cross-functional teams (Project Management, Business Analysis and Stakeholders, Quality Assurance, Operations, etc.)Participate in various Agile/Scrum activities, such as backlog grooming, sprint planning, daily stand-ups, and sprint retrospectivesPerform other duties as assigned or apparent.     Regards, ManojDerex Technologies INCContact : 973-834-5005 Ext 206