IT Data Analyst

State of Idaho Career Opportunity

Applications will be accepted through 11:59 PM MST on the posting end date.

IT Data Analyst I Enterprise Reporting - Applications and Development

The State of Idaho Controller's Office (SCO) is an equal opportunity employer. This position is exempt from state classified service and the rules of the Division of Human Resources and the Idaho Personnel Commission. This is an at-will position.

GENERAL INFORMATION:

This is a data analyst position responsible for developing and maintaining reports, dashboards, and data solutions within the SCO's Enterprise Reporting Platform and broader analytics ecosystem. The analyst assists business stakeholders and technical delivery teams by translating complex reporting needs into clear, reliable, and actionable data solutions. A successful candidate will be experienced with business intelligence (BI) tools, relational database systems, and modern data visualization techniques, and will demonstrate strong analytical and problem-solving skills. Key technologies in the tech stack include IBM Cognos Analytics, Microsoft Power BI, SQL Server Management Studio (SSMS), Python, JavaScript, and SQL. This role delivers new and enhanced Enterprise Reporting solutions, including operational reports, financial dashboards, and self-service analytics. Ensuring that data is reliable, consistent, and optimized to support operational, analytical, and executive decision-making across Idaho state government. This analyst will collaborate with cross-functional teams, including product owners, functional and agency personnel, and other engineers, to create innovative solutions that drive the success of the Office's reporting products and services. This role is dependent on real-time teamwork, in-person mentoring and in-person collaboration to problem-solve and provide customer service in real time.

KEY RESPONSIBILITIES

This role ensures that the Office has a stable, scalable, and trusted data foundation, enabling high-quality reporting, improved transparency, and data-driven decision-making across the organization.

Essential Job Functions:

• Design, build, and maintain reports and dashboards using IBM Cognos Analytics, Microsoft Power BI, and other BI tools.

• Develop and optimize SQL queries, stored procedures, views, and functions using SQL Server Management Studio (SSMS).

• Optimize data models and structures (including Cognos frameworks and Power BI semantic models) for reporting performance and usability.

• Enable and support self-service analytics capabilities for agency and operational stakeholders.

• Perform regular audits to identify and resolve data errors, inconsistencies, gaps, and cross-system mismatches.

• Establish and promote data standards, naming conventions, and field definitions to ensure consistency across reporting solutions.

• Maintain data dictionaries and documentation covering field definitions, ownership, lineage, and standards.

• Ensure a single, reliable source of truth is reflected consistently across enterprise reporting outputs.

• Partner with business stakeholders to gather, clarify, and document requirements for analytics, reporting, and data products.

• Translate ambiguous business requests into structured problem statements, user stories, acceptance criteria, and technical specifications.

• Facilitate discovery sessions, requirements workshops, and cross-functional alignment meetings.

• Identify gaps between stakeholder expectations, available data, and technical feasibility; proactively communicate risks and tradeoffs.

• Support user acceptance testing and promote consistent use of data definitions and standardized analytics practices.

• Participate in Agile/Scrum ceremonies, team meetings, and cross-training activities.

• Develop subject matter expertise in assigned reporting tools and data systems; assist with training and onboarding of team members and end users as proficiency grows.

• Write user stories, document acceptance criteria, and support sprint planning and prioritization.

• Contribute to time-sensitive development, scheduled releases, and technology strategy milestones.

• Monitor, troubleshoot, and resolve production support tickets for current reporting systems.

• Communicate with users in a timely, clear, and effective manner.

• In-person (and in-office) collaboration with team members to problem solve and provide customer service in real time is essential to this position.

Additional Functions:

• Contributes to the positive performance of the Computer Services Division and the Office.

• Demonstrates timely and consistent attendance (critical to this position).

• This is an in-office position.

• Any additional duties as assigned by the State Controller or their designee.

Minimum Qualifications:

Note: College coursework in the areas mentioned will count as experience

• Experience writing and optimizing SQL queries, including joins, aggregations, stored procedures, and functions (SQL Server preferred).

• Experience developing or maintaining reports and/or dashboards using a BI or reporting tool (e.g., IBM Cognos, Power BI, SSRS, or equivalent).

• Experience gathering stakeholder requirements and translating them into clear documentation for technical teams.

• Experience identifying and resolving complex data or system-related problems and translating them into workable solutions.

• Experience with version control systems (e.g., Git/Bitbucket).

• Strong attention to detail and a high standard for data accuracy and consistency.

• Good knowledge of current trends in Information Technology and SDLC practices.

• Strong written and verbal communication skills; able to adapt style for both technical and non-technical audiences.

• Ability to organize and manage multiple concurrent initiatives effectively.

Preferred Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.

• Proficiency with IBM Cognos Analytics, including Framework Manager, Report Studio, Dashboard authoring, and data module development.

• Proficiency with Microsoft Power BI, including Power Query (M), DAX, data modeling, and workspace/gateway administration.

• Proficiency with SQL Server Management Studio (SSMS), including database object management and performance tuning.

• Experience with data warehouse concepts, ETL/ELT processes, and data modeling best practices.

• Familiarity with enterprise data governance, data lineage, and security practices.

• Experience maintaining data dictionaries, metric definitions, or business glossaries.

• Proficiency in one or more programming languages (e.g., Python, JavaScript, Visual Basic).

• Experience with software development methodologies (Agile, Scrum, etc.).

• Understanding of financial or governmental reporting requirements is a plus.

• Knowledge of software testing techniques and quality assurance frameworks.

• Strong analytical, problem-solving, and interpersonal skills.

• Ability to work both independently and collaboratively in a team environment.

Benefits:

The State of Idaho offers a robust total compensation package, including medical, vision, and dental insurance; PERSI retirement benefits; paid sick, vacation, and parental leave; and 11 paid holidays per year. For additional information related to benefits and/or State programs, please visit

EEO/ADA/Veteran:

The State of Idaho is committed to providing equal employment opportunities and prohibit discrimination against qualified individuals based on their status as protected veterans or individuals with disabilities and prohibit discrimination against all individuals based on their race, color, religion, political affiliation or belief, sex, national origin, genetics, or any other status protected under applicable federal, state, or local laws.

The State of Idaho is committed to access and reasonable accommodations for individuals with disabilities, auxiliary aids and services are available upon request. If you require an accommodation at any step in our recruitment process, you are encouraged to contact View phone number on click.appcast.io (TTY/TTD: 711), or email View email address on click.appcast.io.

Preference may be given to veterans who qualify under state and federal laws and regulations.