BI Data Developer
BI Data Developer
Posted on :
20-02-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
20-02-2025
Job Description
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 TSQL SSIS query SQL Indexing database performance tuning ETL data management visualization data analysis.
POSITION DESCRIPTION:
- Imagine designing developing and maintaining statewide data solutions supporting over one million K12 students plus hundreds of thousands of parents teachers and school staff in Arizona.
- The Arizona Department of Education is creating awardwinning solutions using leadingedge 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 datafocused software solutions using Power BI TSQL 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 solutionoriented adapt to changing environments and able to work with minimal defined requirements.
- Preferred candidates will be investigative detailoriented 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 tools
- Develop TSQL 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 functions
- Participate in all phases of the BI and data solutions development and maintenance lifecycle
- Participate in collaborative design and definition sessions engaging with business analysts and stakeholders to understand requirements and contribute to functional specifications
- Perform impact analysis on change requests providing estimates for development efforts
- Assist in documenting technical specifications from business requirements and maintaining system design and reference documentation
- Work with the lead Data Architect on implementation of data architecture principles to align and conform with 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
- Support production systems participating in defect analysis and resolution
- Work closely/collaboratively with crossfunctional teams (Project Management Business Analysis and Stakeholders Quality Assurance Operations etc.)
- Participate in various Agile/Scrum activities such as backlog grooming sprint planning daily standups and sprint retrospectives
- Perform other duties as assigned or apparent.
QUALIFICATIONS REQUIRED:
- Education Required: Bachelors degree in computer science Information Systems or related field of study or equivalent professional experience.
- Experience Required: 5 or more years of professional Data Development experience with relational database systems utilizing the required knowledge skills and abilities listed above.
- Demonstrated experience and capability developing in Power BI and other BI and Data Visualization tools
- SQL Server development using TSQL and SSIS plus intermediate to advancedlevel relational database modeling and design
- Strong 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
- 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 problemsolving 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
- Strong customer service and interpersonal skills
QUALIFICATIONS PREFERRED:
- Working knowledge/practice in Data Vault data modeling methodology
- Microsoft Azure data technologies
- Experience working on an Agile/Scrum team
- Experience in the Education and/or Government sector
- Familiarity with the EdFi CEDS and/or SIF data standards and specifications
ADDITIONAL INFORMATION:
- LOCAL ARIZONA CANDIDATES ONLY
- Candidates should apply with the ability and willingness to work inoffice up to five days per week as business needs necessitate.
- Standard 7year background check
- Is a Fingerprint Clearance Card (FPCC) Required Yes
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
