CAPPS, Inc.
THECB - Systems Analyst III-IV, Power BI
CAPPS, Inc., Austin, Texas, us, 78716
Job Description
THECB is observing a hybrid telecommuting schedule with employees required to be in the office at least two (2) days per week.
The agency is located at the George Herbert Walker Bush State Building located in the Capitol Complex at 1801 N. Congress Ave. Austin, TX 78701.
Employment Requirements: Job offer, and continuation of employment are contingent on:
Proof of eligibility/authorization to work in the United States on a full-time basis. Proof of educational credentials that satisfies the requirements of the position. Satisfactory results from a criminal history background check, if applicable. The THECB does not sponsor H-1B visas. The THECB does not allow dual employment with other state of Texas agencies or institutions.
Note: Salary range for Systems Analyst III- $5,583 - $6,147. Salary range for Systems Analyst IV - $5,583 - $6,333.
Introduction:
The candidate should be able to perform below tasks:
1. Power BI Administration and development activities
2. Collaborate with business and technical team to understand the requirement and implement that by following industry best practices and THECB agency's ITS standards
General Description:
Building Power BI reports to support the Information Technology Services Division of the Texas Higher Education Coordinating Board (THECB) legacy modernization project. Work involves collaborating with business and development teams to translate business requirements into technical specifications; develop, test and deploy Power BI reports to higher environments following industry best practices while meeting business requirements. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. This position reports to Director.
General Duties and Responsibilities:
•Analyze business requirements and provides optimal solutions using agile methodologies that correspond to THECB policies and procedures.
•Promotes and adopts consistent testing standards, tools, and processes.
•Coordinate and/or perform work on Power BI projects, including highly complex in nature and/or large in scale.
•Create and manage complex Power BI reports.
•Support multiple Power BI projects and customer enhancements using an Agile methodology.
•Ability to move Power BI components from development to production using pipelines in Azure DevOps.
•Background of data warehouse design (e.g. dimensional modeling) and data mining.
•Familiarity with data integration (ETL) solutions and logical data modeling.
•Develop and document standards/best practices for development and administration of the Power BI platform.
•Assist in development of workbooks and dashboards to support business initiatives.
•Perform research and analysis required for project proposals, and new projects.
•Develop instructions or user manuals for end users.
•Complete regular internal system audits.
•Perform all other duties as assigned.
•Applies appropriate Family Educational Rights and Privacy Act (FERPA) standards at all times. Ensures compliance with federal, state, and agency Web Accessibility policies and procedures.
•Skill in effective oral and written communication.
•A team player having open mind to learn and grow technical and soft skills.
Knowledge, Skills, and Abilities:
•Knowledge of the software development lifecycle
•Knowledge of Agile/Scrum methodologies
•Skill in using personal computers, general office software, databases, and computer programs
•Skill in communicating both in writing and verbally
•Ability to effectively handle multiple responsibilities and priorities and manage time in a fast-paced and sometimes pressured environment
•Ability to work on detailed information and provide accurate, organized results
•Ability to work well in groups, and to establish and maintain effective working relationships both internally and externally
•Ability to interact professionally with customers, users, and other participants in the admin and development process
•Ability to think critically, use logic and reasoning, and identify alternative solutions to problems
•Ensure security and confidentiality of sensitive and/or protected information
Military Crosswalk:
Military Crosswalk for Occupational Category - Information Technology (texas.gov)
Qualifications:
Required Minimum Education and Experience:
•Bachelor's degree from an accredited college or university
•Six additional months of relevant full-time work experience may substitute for 15 semester credit hours of required education, up to four years
Programmer III
•Two years of relevant full-time work experience with Power BI including:
§Power BI product knowledge
§1+ years of SQL server experience - ability to write complex queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
§1 year experience with Azure SQL data warehouses
§MS Power BI Suit (Power Query/M/DAX)
Programmer IV - All of the above functions for a Programmer III, PLUS:
•Four years of relevant full-time work experience with Power BI including:
§Strong Power BI product knowledge
§3+ years of SQL server experience - ability to write complex queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
§2+ years of experience with Azure SQL data warehouses
§1+ years of experience with MS Power BI Suit (Power Query/M/DAX)
Preferred:
•Power BI PL-300 certified
•Experienced or interested in Power Application, Power Automate Developments
•Bachelor's degree in Computer Information Systems, or Management Information Systems
•Working in SCRUM or Agile environment
•Experience with State or Federal government processes
Physical Requirements and/or Working Conditions:
Work is performed in a standard office environment and requires:
Regular, reliable, and punctual attendance at work;Frequent use of personal computer, copiers, printers, and telephones;Frequent sittingFrequently working under deadlines, as a team member, and in direct contact with others.•If/when working from home, a strong, reliable internet connection and a dedicated workspace are required
Workforce:
Must be able to:
Demonstrate knowledge of customer service deliverables.Show flexibility and adaptability toward changes in assignments and work schedules, working extended hours as necessary.Adhere to the organization's internal management policies and procedures.Contribute to the agency's performance measures and mission.Application Requirements:
The Texas Higher Education Coordinating Board is an Equal Opportunity Employer. A State of Texas application is required to apply. For more information on how to apply for this position, go to the Coordinating Board's employment opportunities website atCareers - Texas Higher Education Coordinating Board
The Texas Higher Education Coordinating Board participates in E-Verify for each new employees' Form I-9 to confirm work authorization. For questions, please call the HR Department at 512-427-6190. For vocal and/or hearing assistance call 7-1-1.
Notes to Applicant:
If you require any reasonable accommodation for the interview process, please inform the hiring representative who calls to schedule your interview. This position has been designated as a security sensitive position. A criminal background investigation will be conducted on the final candidate for this position.
Your job application must be completely filled out. Your application must contain dates of employment, job titles, name of employer and a description of duties performed in a way that demonstrates you meet the minimum qualifications for the position for which you are applying. Resumes do not take the place of the requirement to include this information on the application. If this information is not submitted, your application may be rejected because it is incomplete.
Veterans Information:
THECB is committed to hiring Veterans. To receive Veteran's Preference, a copy of the FORM DD214 -member #4, must be attached when submitting your application.
AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER:
THECB does not discriminate on the basis, of race, color, religion, sex, national origin, age, or disability in employment or the provision of services.
Job offer and continuation of employment with THECB is contingent upon:
Proof of education and experience listed on the application.Eligibility/authorization to work in the U.S.Satisfactory results from a pre-employment criminal history background check.Compliance with the Selective Service Law for males ages 18-25. Please be advised that under Texas law, names and other information concerning applicants or nominees may be subject to disclosure upon request.
THECB does not allow dual employment with other state of Texas agencies or institutions.
Skills assessment may be conducted at time of interview
No phone calls or emails, please. Due to the high volume of applications, we do not accept telephone calls and cannot reply to all email inquiries. Only candidates selected for interview will be contacted.
THECB is observing a hybrid telecommuting schedule with employees required to be in the office at least two (2) days per week.
The agency is located at the George Herbert Walker Bush State Building located in the Capitol Complex at 1801 N. Congress Ave. Austin, TX 78701.
Employment Requirements: Job offer, and continuation of employment are contingent on:
Proof of eligibility/authorization to work in the United States on a full-time basis. Proof of educational credentials that satisfies the requirements of the position. Satisfactory results from a criminal history background check, if applicable. The THECB does not sponsor H-1B visas. The THECB does not allow dual employment with other state of Texas agencies or institutions.
Note: Salary range for Systems Analyst III- $5,583 - $6,147. Salary range for Systems Analyst IV - $5,583 - $6,333.
Introduction:
The candidate should be able to perform below tasks:
1. Power BI Administration and development activities
2. Collaborate with business and technical team to understand the requirement and implement that by following industry best practices and THECB agency's ITS standards
General Description:
Building Power BI reports to support the Information Technology Services Division of the Texas Higher Education Coordinating Board (THECB) legacy modernization project. Work involves collaborating with business and development teams to translate business requirements into technical specifications; develop, test and deploy Power BI reports to higher environments following industry best practices while meeting business requirements. Works under general supervision, with moderate latitude for the use of initiative and independent judgment. This position reports to Director.
General Duties and Responsibilities:
•Analyze business requirements and provides optimal solutions using agile methodologies that correspond to THECB policies and procedures.
•Promotes and adopts consistent testing standards, tools, and processes.
•Coordinate and/or perform work on Power BI projects, including highly complex in nature and/or large in scale.
•Create and manage complex Power BI reports.
•Support multiple Power BI projects and customer enhancements using an Agile methodology.
•Ability to move Power BI components from development to production using pipelines in Azure DevOps.
•Background of data warehouse design (e.g. dimensional modeling) and data mining.
•Familiarity with data integration (ETL) solutions and logical data modeling.
•Develop and document standards/best practices for development and administration of the Power BI platform.
•Assist in development of workbooks and dashboards to support business initiatives.
•Perform research and analysis required for project proposals, and new projects.
•Develop instructions or user manuals for end users.
•Complete regular internal system audits.
•Perform all other duties as assigned.
•Applies appropriate Family Educational Rights and Privacy Act (FERPA) standards at all times. Ensures compliance with federal, state, and agency Web Accessibility policies and procedures.
•Skill in effective oral and written communication.
•A team player having open mind to learn and grow technical and soft skills.
Knowledge, Skills, and Abilities:
•Knowledge of the software development lifecycle
•Knowledge of Agile/Scrum methodologies
•Skill in using personal computers, general office software, databases, and computer programs
•Skill in communicating both in writing and verbally
•Ability to effectively handle multiple responsibilities and priorities and manage time in a fast-paced and sometimes pressured environment
•Ability to work on detailed information and provide accurate, organized results
•Ability to work well in groups, and to establish and maintain effective working relationships both internally and externally
•Ability to interact professionally with customers, users, and other participants in the admin and development process
•Ability to think critically, use logic and reasoning, and identify alternative solutions to problems
•Ensure security and confidentiality of sensitive and/or protected information
Military Crosswalk:
Military Crosswalk for Occupational Category - Information Technology (texas.gov)
Qualifications:
Required Minimum Education and Experience:
•Bachelor's degree from an accredited college or university
•Six additional months of relevant full-time work experience may substitute for 15 semester credit hours of required education, up to four years
Programmer III
•Two years of relevant full-time work experience with Power BI including:
§Power BI product knowledge
§1+ years of SQL server experience - ability to write complex queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
§1 year experience with Azure SQL data warehouses
§MS Power BI Suit (Power Query/M/DAX)
Programmer IV - All of the above functions for a Programmer III, PLUS:
•Four years of relevant full-time work experience with Power BI including:
§Strong Power BI product knowledge
§3+ years of SQL server experience - ability to write complex queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
§2+ years of experience with Azure SQL data warehouses
§1+ years of experience with MS Power BI Suit (Power Query/M/DAX)
Preferred:
•Power BI PL-300 certified
•Experienced or interested in Power Application, Power Automate Developments
•Bachelor's degree in Computer Information Systems, or Management Information Systems
•Working in SCRUM or Agile environment
•Experience with State or Federal government processes
Physical Requirements and/or Working Conditions:
Work is performed in a standard office environment and requires:
Regular, reliable, and punctual attendance at work;Frequent use of personal computer, copiers, printers, and telephones;Frequent sittingFrequently working under deadlines, as a team member, and in direct contact with others.•If/when working from home, a strong, reliable internet connection and a dedicated workspace are required
Workforce:
Must be able to:
Demonstrate knowledge of customer service deliverables.Show flexibility and adaptability toward changes in assignments and work schedules, working extended hours as necessary.Adhere to the organization's internal management policies and procedures.Contribute to the agency's performance measures and mission.Application Requirements:
The Texas Higher Education Coordinating Board is an Equal Opportunity Employer. A State of Texas application is required to apply. For more information on how to apply for this position, go to the Coordinating Board's employment opportunities website atCareers - Texas Higher Education Coordinating Board
The Texas Higher Education Coordinating Board participates in E-Verify for each new employees' Form I-9 to confirm work authorization. For questions, please call the HR Department at 512-427-6190. For vocal and/or hearing assistance call 7-1-1.
Notes to Applicant:
If you require any reasonable accommodation for the interview process, please inform the hiring representative who calls to schedule your interview. This position has been designated as a security sensitive position. A criminal background investigation will be conducted on the final candidate for this position.
Your job application must be completely filled out. Your application must contain dates of employment, job titles, name of employer and a description of duties performed in a way that demonstrates you meet the minimum qualifications for the position for which you are applying. Resumes do not take the place of the requirement to include this information on the application. If this information is not submitted, your application may be rejected because it is incomplete.
Veterans Information:
THECB is committed to hiring Veterans. To receive Veteran's Preference, a copy of the FORM DD214 -member #4, must be attached when submitting your application.
AN EQUAL EMPLOYMENT OPPORTUNITY EMPLOYER:
THECB does not discriminate on the basis, of race, color, religion, sex, national origin, age, or disability in employment or the provision of services.
Job offer and continuation of employment with THECB is contingent upon:
Proof of education and experience listed on the application.Eligibility/authorization to work in the U.S.Satisfactory results from a pre-employment criminal history background check.Compliance with the Selective Service Law for males ages 18-25. Please be advised that under Texas law, names and other information concerning applicants or nominees may be subject to disclosure upon request.
THECB does not allow dual employment with other state of Texas agencies or institutions.
Skills assessment may be conducted at time of interview
No phone calls or emails, please. Due to the high volume of applications, we do not accept telephone calls and cannot reply to all email inquiries. Only candidates selected for interview will be contacted.