Description
DEPARTMENT OF ECONOMIC SECURITY Your Partner For A Stronger Arizona.
DES works with families, community organizations, advocates and state and federal partners to realize our collective vision: A thriving Arizona.
DES serves more than 3 million Arizonans. Our Mission is to strengthen individuals, families, and communities for a better quality of life. BUSINESS INTELLIGENCE ANALYST INTERMEDIATE Job Location: Child Community Services Division (CCSD)
1789 West Jefferson Street, Phoenix, Arizona 85007 Posting Details: Salary: $79,000-$92,997
Grade: 26
Closing Date: October 14, 2024 Job Summary:
Would you like to be part of an amazing team that helps Arizonans thrive? At the Department of Economic Security (DES) we strengthen individuals, families, and communities for a better quality of life. DES is looking for individuals who are committed to service, community, and teamwork. To learn more about DES please visit des.az.gov; or click on the link here to view ‘Our DES' video. Come Join the DES Team!
DES is seeking an experienced and highly motivated individual to join our team as a Business Intelligence Analyst Intermediate. The position will perform complex tasks to support the division by performing data analysis, data mining, design, development, testing activities, and execution of Ad-hoc and Standard reports to achieve strategic objectives and goals following unit Standard of Work processes. This position plans, organizes and prioritizes business analysis project deliverables from inception to completion in collaboration with business stakeholders. Responsible for requirements gathering for business questions of staff and management and developing those technical needs into meaningful reports which enable data driven decision making and aid in the establishment of guidelines and policies. This role interfaces with other team members to analyze and design methodologies for complex data extraction from a variety of data sources and assist other team members in cross-training, quality control and reporting methodologies.
This position may offer the ability to work remotely, within Arizona, based upon the department's business needs and continual meeting of expected performance measures.
The State of Arizona strives for a work culture that affords flexibility, autonomy and trust. Across our many agencies, boards, commissions, many State employees participate in the State's Remote Work Program and are able to work remotely in their homes, in offices and in hoteling spaces. All work, including remote work, should be performed within Arizona, unless an exception is properly authorized in advance.
Essential Duties and Responsibilities include but are not limited to:
• Design Adhoc and Standard reports in Tableau, SSIS, or other technology solutions which may require writing SQL and "Run Book" documentation to support design. Record work related activities in an operating system and/or place documents in the appropriate drive following system processes and procedures.
• Manage life-cycle development and deployment utilizing SSIS, SQL, Tableau, Visual Basic, MS Access, dimensional and relational database design, or other business intelligence software tools. Perform data analysis, data mining, design, development, and execution of Adhoc and Standards reports ensuring consistency and applicability to achieve established strategic objectives and goals.
• Serves on projects and/or pilots (develop Workplan, monitor, schedule, etc.) to provide technical guidance working collaboratively with the Analyst on design to ensure integration between Business Intelligence and business requirements, and ensure timely and successful completion.
• Write and/or provide input for requirements, framework, and mechanisms for data analytics working closely with Analyst and End User and make recommendations to support automation and maintenance ensuring successful integration between Business Intelligence environment and business requirements.
• Participate in planning, development, testing, and delivery of solutions, and data stewardship activities. Develop and/or review test plans, monitor testing (assist with testing), ensure results are adequately tested (integration testing of technical and functional requirements and regression testing to identify anomalies) and validated, and create system documentation.
• Develop, analyze, and evaluate business needs to improve workflow processes, troubleshoot Business Intelligence tool problems and tune for performance optimization and usability.
• Design and deliver end-user presentations, training, Desk-Aids, and/or associated materials to technical and non-technical audiences. Attend and participate in meetings.
Knowledge of:
• Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management.
• Engineering workflow, IT lifecycle and system design, performance tuning, and Business Intelligence tools and features.
• Statistical and business analysis and research and analysis methodologies.
• Multiple Business Intelligence software applications (SSIS, SQL, Tableau, Visual Basic, MS Access, and multidimensional and Relational database design.)
• Project management concepts, principles and practices.
• English language for sentence structure, composition, content, spelling, and grammar.
Skills In:
• Dimensional and Relational database design.
• Analysis, design review, trouble-shooting, implementation and integration for applications.
• Problem and negotiation skills to resolve issues.
• Good time management and organizational skills with attention to detail.
• Effective listening, oral and written communication skills to communicate technical and non-technical concepts to a variety of audiences.
• Use of Business Intelligence (BI software (SQL, SSIS, Tableau, Visual Basic, and MS Access.)
Ability to:
• Write requirements and diagram business processes, translate into technical solutions and reports, query and view objects, and present in a meaningful format.
• Work independently or collaboratively and under stress/pressure.
• Analyze data, develop and execute queries and reports, and proficiently manipulate data.
• Adapt to changing needs and priorities quickly while contributing feedback based on rules and
regulations.
• Multi-task and prioritize competing deadlines and tasks.
This ideal candidate for this position will have:
• A Bachelor's Degree from an accredited college or university in Computer Science, Information Systems, Business Management or closely related field and 2 years of experience in a business intelligence or data analysis role.
• Employee shall obtain and maintain a valid Level One fingerprint clearance card that meets DES requirements for a Level One card pursuant to Arizona Revised Statute 41-1969.
• This position may require driving or the use of a vehicle as an essential function of the job to conduct State business, then the following requirements apply: Driver's License Requirements. Any employee operating a motor vehicle on State business must possess and retain a current, valid class-appropriate driver's license, complete all required training, and successfully pass all necessary driver's license record checks. The license must be current, unexpired, and neither revoked nor suspended. Employees who drive on state business are subject to driver's license record checks, must maintain acceptable driving records, and must complete all required driver training. An employee who operates a personally owned vehicle on state business shall maintain the statutorily required liability insurance (see Arizona Administrative Code (A.A.C.) R2-10-207.11).
• Successfully pass background and reference checks; employment is contingent upon completion of the above-mentioned process and the agency's ability to reasonably accommodate any restrictions.
• All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify.
The Arizona Department of Economic Security offers a comprehensive benefits package to include:
• Affordable medical, dental, life, and short-term disability insurance plans
• Participation in the Arizona State Retirement System (ASRS) and long-term disability plans
• 10 paid holidays per year
• Vacation time accrued at 4.00 hours bi-weekly for the first 3 years
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
• Sick time accrued at 3.70 hours bi-weekly
• Deferred compensation plan
• Wellness plans
• Tuition Reimbursement
• Stipend Opportunities
• Infant at Work Program
• Rideshare and Public Transit Subsidy
• Career Advancement & Employee Development Opportunities
• Flexible schedules to create a work/life balance
By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.
Learn more about the Paid Parental Leave pilot program here. For a complete list of benefits provided by The State of Arizona, please visit our benefits page
Retirement:State employees are required to participate in the Arizona State Retirement System (ASRS), the State sponsored retirement contribution plan and the Long-Term Disability (LTD) program after a 27-week waiting period. The ASRS defined benefit plan provides for life-long income upon retirement. You will also have the option to participate in a voluntary deferred compensation program to take advantage of tax-deferred retirement investments.
On, or shortly after, your first day of work you will be provided with additional information about the available insurance plans, enrollment instructions, submission deadlines and effective dates.
For questions about this career opportunity, please contact us Jessica Grover at 520-235-3174 or OODHRstaffing@azdes.gov.
The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer. Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by contacting Jessica Grover at 520-235-3174 or OODHRStaffing@azdes.gov. Requests should be made as early as possible to allow sufficient time to arrange the accommodation.
Apply on company website
Find Connections via Linkedin
