IT Professional 3 - Business Intelligence

State of Nevada•Carson City, NV

About The Position

The Governor’s Finance Office, Office of Project Management, is seeking an experienced professional to join the Reports Team supporting the CORE.NV Enterprise Resource Planning (ERP) implementation project and ongoing production support. This position will work collaboratively with State employees, contractors, vendors, and project stakeholders to analyze business processes and design, develop, and support enterprise reporting and analytics solutions. Responsibilities include translating business requirements into scalable reporting solutions; developing and optimizing reports, datasets, and data models; performing data validation, reconciliation, testing, and root cause analysis; and supporting reporting modernization, deployment, and release management activities. The position will ensure compliance with enterprise BI governance and development standards, maintain technical documentation and reporting standards, and communicate findings and recommendations to technical and non-technical stakeholders. The successful candidate will also provide reporting and data support to other CORE.NV Project and Production Support teams, including human resources, fiscal, procurement, budget, grants, security/configuration, interfaces/integrations, and testing. The ideal candidate will have experience delivering enterprise-level BI solutions using complex data models, SQL, Power BI, and cloud data platforms such as Snowflake. Experience with tools such as JIRA, the Atlassian Suite, or ServiceNow is desirable. Strong organizational, analytical, communication, and problem-solving skills, along with the ability to adapt to evolving technologies and business needs, are essential. Information Technology (IT) Professionals analyze, develop, implement, maintain, and modify computer operations, systems, networks, databases, applications, and/or information security. Incumbents may perform duties in one or more IT specialization areas depending on the needs of the agency.

Requirements

Bachelor's degree from an accredited college or university in computer science, management information systems, or closely related field and three years of professional IT experience relevant to the duties of the position which may include computer operations, systems administration, network administration, database administration, applications analysis and development, and/or information security, one year of which was at the journey level; OR one year of relevant experience as an IT Professional II in Nevada State service; OR an equivalent combination of education and experience as described above.
Experience delivering enterprise-level BI solutions using complex data models, SQL, Power BI, and cloud data platforms such as Snowflake.
Strong organizational, analytical, communication, and problem-solving skills.
Ability to adapt to evolving technologies and business needs.
Detailed knowledge of physical and logical database structure and design.
Detailed knowledge of database backup and recovery scenarios and methodologies.
Detailed knowledge of database security management and data integrity.
Working knowledge of computer and network operating systems, computer hardware, and communications systems.
Working knowledge of database and operating system performance tuning monitoring.
Working knowledge of business practices and procedures.
Working knowledge of customer service standards and procedures.
Working knowledge of business software, systems analysis, systems design, system development lifecycle, and information architecture to effectively design and create databases.
Working knowledge of structured query language.
Ability to coordinate system design, applications and software programming, and computer operations activities relative to the database environment.
Detailed knowledge of basic programming techniques such as table handling and on-line file updates.
Detailed knowledge of general purpose programming languages (in software-oriented positions).
Detailed knowledge of principles, tools and techniques as applied to writing, modifying, and documenting programs.
Detailed knowledge of techniques of diagramming program flow.
Working knowledge of access methods and file structures.
Working knowledge of at least one formal systems design methodology.
Working knowledge of principles of designing test procedures.
Working knowledge of principles, practices and procedures required to develop, design, and implement information system-based solutions in a wide range of problem domains.
General knowledge of project control techniques, including cost estimating and resource scheduling.
Ability to utilize interactive programming techniques.
Ability to logically analyze problems of considerable complexity.
Ability to test and validate information systems.
Detailed knowledge of specific departmental information systems (some positions require this).
Working knowledge of principles of designing test procedures.
Working knowledge of principles, practices, and procedures required to design, analyze, and maintain software.
Working knowledge of principles, tools, and techniques as applied to writing and modifying programs.
Working knowledge of systems programming languages and techniques.
General knowledge of capacity planning techniques.
General knowledge of performance monitoring principles and related software products.
General knowledge of telecommunication technology and related systems software.
General knowledge of various systems software products and their interrelationships.
General knowledge of vendor procedures for applying maintenance and temporary fixes.
Ability to communicate effectively orally and in writing.
Ability to evaluate and tailor information system hardware and/or software to meet local requirements.
Ability to implement auxiliary software and subsystems.
Ability to maintain effective working relationships with others.
Ability to provide mid-level technical consultation and training.
Ability to recommend and implement system changes.
Skill in implementing changes to a variety of networking systems.
Skill in managing large volumes of data on various storage media.

Nice To Haves

Experience with tools such as JIRA, the Atlassian Suite, or ServiceNow is desirable.

Responsibilities

Translate business requirements into scalable reporting solutions.
Develop and optimize reports, datasets, and data models.
Perform data validation, reconciliation, testing, and root cause analysis.
Support reporting modernization, deployment, and release management activities.
Ensure compliance with enterprise BI governance and development standards.
Maintain technical documentation and reporting standards.
Communicate findings and recommendations to technical and non-technical stakeholders.
Provide reporting and data support to other CORE.NV Project and Production Support teams.
Conduct detailed alternative analyses and determine end-user requirements through consultation with end-users, technicians, vendors, management, and others.
Maintain documentation related to the assigned IT specialization’s architecture, operations, and other records of work activities as required.
Maintain current knowledge of technological trends and advancements in the IT field as well as security management practices, laws, policies, and ethics.
Participate in recommending and justifying resource allocations and expenditure decisions, tracking, and recording expenditures, preparing purchase requests, and writing technical requirements for grant proposals.
Perform related duties as assigned.
Under general direction, incumbents perform advanced journey level duties and may train, supervise, and evaluate the performance of subordinate staff and/or serve as a project leader as assigned.
Incumbents may function as a unit leader to include directing the activities of a branch IT support unit, overseeing projects of limited scope, and coordinating activities with other work groups.