BI Data Developer - Hybrid
Title: BI Data Developer - Hybrid
Mandatory skills:
Professional Data Development, database systems, Power BI, BI, Data Visualization tools,
SQL Server development, T-SQL, SSIS, database modeling, database design,
query optimization, SQL Indexing, database performance tuning,
Data Vault data modeling, Microsoft Azure data technologies,
Agile, Scrum, Ed-Fi, CEDS, SIF data,
ADE business processes, data analysis, reporting requirements, information requirements,
SQL Server Integration services, ETL solutions, system design, production systems,
data management, data architecture, data manipulation, data solutions development, data quality assessment, data mappings
Description:
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 the client.
The client 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 tools
Develop 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 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 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 retrospectives
Perform other duties as assigned or apparent
Skills Required:
Demonstrated 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 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 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
Strong customer service and interpersonal 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 and/or Government sector
Familiarity with the Ed-Fi, CEDS, and/or SIF data standards and specifications
Education Required:
Bachelor s Degree in Computer Science, Information Systems, or related field of study, or equivalent professional experience.
Skills:
Professional Data Development experience with relational database systems - 5 Years
Demonstrated experience and capability developing in Power BI and other BI and Data Visualization tools -3 Years
SQL Server development using T-SQL and SSIS, plus intermediate- to advanced-level relational database modeling and design - 3 Years
Strong understanding of query optimization, SQL Indexing, and other database performance tuning concepts and techniques - 3 Years
Notes:
Candidates should apply with the ability and willingness to work in-office up to five days per week as business needs necessitate
Hybrid
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Contact Details :
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
Title: BI Data Developer - Hybrid
Mandatory skills:
Professional Data Development, database systems, Power BI, BI, Data Visualization tools,
SQL Server development, T-SQL, SSIS, database modeling, database design,
query optimization, SQL Indexing, database performance tuning,
Data Vault data modeling, Microsoft Azure data technologies,
Agile, Scrum, Ed-Fi, CEDS, SIF data,
ADE business processes, data analysis, reporting requirements, information requirements,
SQL Server Integration services, ETL solutions, system design, production systems,
data management, data architecture, data manipulation, data solutions development, data quality assessment, data mappings
Description:
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 the client.
The client 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 tools
Develop 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 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 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 retrospectives
Perform other duties as assigned or apparent
Skills Required:
Demonstrated 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 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 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
Strong customer service and interpersonal 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 and/or Government sector
Familiarity with the Ed-Fi, CEDS, and/or SIF data standards and specifications
Education Required:
Bachelor s Degree in Computer Science, Information Systems, or related field of study, or equivalent professional experience.
Skills:
Professional Data Development experience with relational database systems - 5 Years
Demonstrated experience and capability developing in Power BI and other BI and Data Visualization tools -3 Years
SQL Server development using T-SQL and SSIS, plus intermediate- to advanced-level relational database modeling and design - 3 Years
Strong understanding of query optimization, SQL Indexing, and other database performance tuning concepts and techniques - 3 Years
Notes:
Candidates should apply with the ability and willingness to work in-office up to five days per week as business needs necessitate
Hybrid
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Contact Details :
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008