State of Arizona · 10 hours ago
BUSINESS INTELLIGENCE ANALYST SENIOR
Phoenix, AZ
Full-time
Hybrid
Mid, Senior Level
$71K/yr - $141K/yr
3+ years expThe State of Arizona's Department of Economic Security is seeking an experienced and highly motivated individual to join their team as a Senior Business Intelligence Analyst. This role involves performing complex data analysis, report development, and serving as a subject matter expert while collaborating on projects to enhance system performance and usability.
GovernmentOffice AdministrationPublic Relations
Responsibilities
Design and develop complex custom reports including coding 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
SME for SSIS, SSRS, SQL, Visual Basic, Tableau Developer, MS Access, and new technology platforms, dimensional and relational database design to manage full life-cycle development and deployment. Perform data analysis, data mining, design, development, and execution of complex custom reports ensuring consistency and applicability to achieve established strategic objectives and goals
Serves as a lead technologist on all facets of projects and/or pilots (develop Work Plan, monitor, schedule, etc.) working collaboratively with analyst on design, business requirements, make recommendations to enhance performance and usability, and ensure timely and successful completion
Write and/or provide input for requirements, tools, framework, and mechanisms for data analytics working closely with Analyst and End User ensuring successful integration between Business Intelligence environment and business requirements
Participate in planning and oversee full aspects of development, testing activities, maintenance, and deployment of custom reports using various business intelligence software tools, investigate and recommend new technology platforms, and ensure are in compliance with data stewardship and data governance activities
Analyze performance for process improvement of existing systems and standards, assist in the maintenance ensuring deliverables meet development and security standards, and research new technologies that may add value across the division. Develop and/or review test plans, monitor testing activities, ensure results are adequately tested and validated, and create system documentation
Design and deliver end-user training and/or associated materials to technical and non-technical audiences. Attend, participate in, and may lead meetings. May participate in the development of short and long-term planning for appropriate information technology infrastructure, applications, and related systems. May temporarily lead a team when necessary
Other duties as assigned, as related to the position
Qualification
Required
Experience with SSIS, SSRS, SQL, Visual Basic, Tableau, MS Access
Ability to perform data analysis, data mining, design, development, testing activities, and execution of complex custom reports
Knowledge of Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management
Knowledge of engineering workflow, IT lifecycle, and system design, performance tuning, and Business Intelligence tools
Knowledge of statistical and business analysis, research, and analytical processes and methodologies
Knowledge of multiple Business Intelligence software applications (SQL, Tableau, Visual Basic, SSRS, SPSS, etc.) and multidimensional and relational database design
Knowledge of project management concepts, principles, and practices
Skill in multidimensional and relational data modeling and database design
Skill in problem-solving and negotiation skills to resolve complex issues
Excellent time management and organizational skills with attention to detail
Excellent listening, verbal, and written communication skills to write and communicate complex, conceptual, and technical and non-technical concepts to a variety of audiences
Working skills and use of Business Intelligence (BI) software (SQL, SPSS, SSIS, SSRS, Tableau, Visual Basic, MS Access, etc.)
Analysis, design review, troubleshooting, implementation, and integration for applications
Proficient in the manipulation of reports and analysis of enterprise data
Ability to write requirements, diagram business processes and workflows, entity relationships, translate into technical solutions and reports, develop and execute queries and view objects, and present in a meaningful format
Ability to work at least 40 hours per week and maintain satisfactory attendance and punctuality standards
Ability to work independently or collaboratively and under stress/pressure interact with all levels of personnel in a professional manner
Ability to analyze data, develop and execute queries and reports, and proficiently manipulate data
Ability to engage in critical thinking using logic and reasoning
Ability to adapt to changing needs and priorities quickly while contributing feedback based on rules and regulations
Ability to multi-task and make good decisions, balancing competing deadlines and priorities
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
Successfully pass background and reference check; 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)
Preferred
A Bachelor's Degree from an accredited college or university in Computer Science, Information Systems, Business Management or a closely related field
3 years of experience in a business intelligence or data analysis role
Benefits
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
Company
State of Arizona
As public servants, we deeply care about Arizona and are committed to facing the issues of our state head-on.
10001+ employees
H1B Sponsorship
State of Arizona has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (3)
2022 (1)
2021 (2)
2020 (6)
Funding
Current Stage
Late StageLeadership Team
Aletha Della Rocco
Human Resources Business Partner, Talent Acquisition
George McNeely MBA
Chief Human Resources Officer - Arizona Department of Administration - Shared Services
Recent News
Phoenix Business Journal
2025-01-11
The Arizona Republic
2024-01-27
Company data provided by crunchbase