Technology Applications Analyst III
Company is seeking a SQL Database Administrator with expertise in performance tuning, indexing, SQL Clustering, T-SQL, SSRS, and PowerBI.
Responsibilities include maintaining data collection and sharing processes, developing SSRS reports and Power BI Dashboards, optimizing database processes, building stored procedures, views, and functions to support database interactions by applications, services, reports and dashboards.
This contractor works closely with all members of the Business Analysis and Applications Development Teams as well as the end user customers.
An expert level of knowledge and experience with Microsoft SQL Server databases, SSRS, and PowerBI is required. This position provides opportunities to contribute to the engineering of new systems and re-engineering of old ones.
CRITICAL SKILLS :
- Install configure and maintain SQL Server Clusters and PowerBI Report Server.
- Monitor and optimize SQL performance.
- Develop complex data extracts, applications, reports, dashboards, and ad-hoc queries by using TSQL.
- Research, troubleshoot, and resolve data issues.
- Work within the project team to assist with system analysis and application design.
- Work closely with Business Analysts and customers to refine requirements, and ensure data quality.
- Collaborate on the definition, development, and maintenance of standards and processes.
- Must possess expertise with T-SQL and development of stored procedures.
- Report writing experience, with SSRS and PowerBI.
- Drive continuous improvement and automation in BI solutions and processes.
- Work effectively with System Administrators, Project Manager(s), Developers, Customers and Management.
- Participate in a team development environment using JIRA.
- Must possess excellent written and verbal communication skills
DESIRABLE SKILLS :
- Degree in Computer Science, business or related discipline.
- Knowledge of data integration, e.g. extract, transform, and load (ETL) process development / support
- Able to develop and troubleshoot SSRS reports and PowerBI dashboards; requires good analytical skills.
- Experience with data access performance tuning, and database performance optimization.
- Application Development Lifecycle knowledge and experience.
- Data transport protocols, e.g. SFTP, XML, and JDXDML.
- Experience with Case Management data and / or Justice System data.
- Documentation of system support information.
- Basic understanding of networking principles.
- Ability to analyze system resource usage and constraints.
- Strong communication skills; ability to interact at all levels including management.
- Works independently and follows through on assignments.
OTHER IMPORTANT INFORMATION :
- A background check is required
- Telecommuting is not offered
- Work location is : Sacramento, CA.
- Free parking.
Benefits :
- Health insurance
- 401(k)
Technology Applications Analyst III
Responsibilities include maintaining data collection and sharing processes, developing SSRS reports and Power BI Dashboards, optimizing database processes, building stored procedures, views, and functions to support database interactions by applications, services, reports and dashboards. This contra...
Information Technology Business Systems Analyst III
Information Technology Business Systems Analyst IIIPrint ()ApplyInformation Technology Business Systems Analyst IIISalary$98,762. Select the one box that best describes your college level education in Management Information Systems, Information Technology, Computer Science, Business Administration,...
Technology Applications Analyst III
Responsibilities include maintaining data collection and sharing processes, developing SSRS reports and Power BI Dashboards, optimizing database processes, building stored procedures, views, and functions to support database interactions by applications, services, reports and dashboards. This contra...
Information Technology Applications Analyst Level I/II
Completion of formal training courses relevant to Information Technology Applications Analyst I/IICompletion of self-guided online training relevant to Information Technology Applications Analyst I/IIOtherNone of the above06Describe your education and training as it relates to the position of Inform...
Information Technology Applications Analyst III
Information Technology Applications Analyst III. Utilizes skills that require technical expertise and an understanding of complex analytical procedures and systems processes, including analysis of complex business processes and requirements, the design and development of applications, and/or databas...
Information Technology Business Systems Analyst III
Advanced principles, methods and techniques used in designing, developing, testing and implementing various software technology solutions. Lead, train, assign, schedule and review the work of technical and/or professional information technology staff. A Bachelor's Degree or higher from an accredited...
Information Technology Applications Analyst Level I/II
Information Technology Applications Analyst I/IIperforms professional duties related to the analysis, design, development, maintenance and administration of computer applications to meet business needs. The Information Technology (IT) Applications Analyst is a single class with two salary levels. Re...
Business Systems Analyst 4 (BUS SYS ANL 4)
As a senior business systems analyst in the Academic Information Systems web application development team, this position is responsible for leading complex, custom web-based application development projects to support the School of Medicine and the School of Nursing. This position will work in colla...
IT Client Cloud Support Specialist
The fundamental purpose of our technology is to help our customers to run their businesses better - with less cost, with more security and with better productivity. IT Client Cloud Support Specialist. This position is Home Office with the occasional visit to the New York office. Support Quality Assu...
Office Administrator
Position provides administrative support to the Shop, other OA within their regions and the Support Center in the areas of training, billing, collections, customer service, purchasing, report generation and analysis, inventory control, payroll, shipping and receiving.May supervise and train other ad...