business intelligence analyst - Phoenix, United States - Arizona State Government

    Default job background
    Description

    DEPT OF ENVIRONMENTAL QUALITY
    We are looking for results-oriented, driven individuals with a thirst for problem solving.


    At Arizona Department of Environmental Quality (ADEQ) our mission is to protect and enhance public health and the environment in Arizona.

    Through consistent, science-based environmental regulation; and clear, equitable engagement and communication; with integrity, respect and the highest standards of effectiveness and efficiency.

    Because Arizonans treasure the unique environment of our state and its essential role in sustaining well-being and economic vitality, today and for future generations.


    We are currently looking for employees who are committed to our Agency, passionate to excel in their career and engaged in our mission.

    Only this caliber of employee will be successful in driving our Agency towards accomplishing our mission


    BUSINESS INTELLIGENCE ANALYST

    Job Location:
    Business Intelligence Unit
    1110 W. Washington St
    Phoenix, Arizona 85007


    Posting Details:

    Salary:
    $80,000

    Grade: 24


    Closing Date:
    Open until filled (First Review of Resumes: 01/02/2024)


    Job Summary:


    The Business Intelligence Analyst position involves designing, managing, and deploying data systems, reports, and dynamic dashboards, as well as training users in these systems and the use of reports.

    The Business Intelligence Analyst will also present analytic findings. This position is responsible for extracting data from multiple sources, manipulating and validating
    data, and conducting root cause analysis.

    The successful candidate should be comfortable performing the following:

    writing queries in SQL Management Studio, writing ETL's in SSIS, developing analytical visualizations such as Tableau, Power BI, etc.

    and managing data systems development/enhancements projects.


    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 employees flexibility, autonomy, and trust.

    Across our many agencies, boards, and 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.


    Job Duties:

    • Acts as primary liaison between Information Technology department, Business Intelligence Team, and the Water Quality Division.
    • Supports the organizations key business processes and applications and recommends business process redesign where applicable.
    • Works with key stakeholders to identify reporting needs, defines the reporting requirements, designs the report, and writes the code required to deliver the report.
    • Queries multiple data sources using SQL, develops ETLs, and produces analysis / reporting using data analysis and visualization tools such as Tableau, R, Stata, Python, etc.
    • Analyzes data and provides insights and recommendations for organizational planning and operations.
    • Performs detailed quality control checks on significant and diverse data sets related to programs.
    • Demonstrate continuous effort to improve operations, streamline work processes, and work cooperatively with both internal and external customers.
    • Prepares and delivers informative, well-organized presentations
    Knowledge, Skills & Abilities (KSAs):


    • Knowledge of current computing technologies and software applications such as SQL query language, and other database applications appropriate to the position's job responsibilities.
    • Knowledge of statistical and business analysis; business operations, methods, practices and workflow engineering.
    • Knowledge of or ability to learn and apply LEAN concepts, principles and tools used to create and deliver the most value from the customers perspective while consuming the fewest resources.
    • Skill in providing technical assistance to business partners; performing analytic functions including workflow and statistical analysis.
    • Ability to promote the use of business intelligence to make effective business decisions; communicate verbally and in writing; to establish and maintain effective working relationships; collaborate with IT/BI and program staff to achieve shared goals.
    Selective Preference(s):


    • A Bachelor's Degree from an accredited college or university in Computer Science, Information Systems, Business Management or closely related field and 5 years of experience in a business intelligence or data analysis role.
    • Experience with Business Intelligence and analytical applications such as Tableau, Power BI, SQL Server
    Management Studio, Visual Studio.


    Pre-Employment Requirements:


    If this position requires 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.

    All newly hired State employees are subject to and must successfully complete the Electronic Employment Eligibility Verification Program (E-Verify).


    Benefits:
    Among the many benefits of a career with the State of Arizona, there are:

    • 10 paid holidays per year
    • Accrual of sick and annual leave beginning at 12 and 13 days per year respectively for full-time employees
    • Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child (pilot program).
    • A top-ranked retirement program with lifetime pension benefits
    • A robust and affordable insurance plan to include medical, dental, life, short-term and long-term disability
    • An incentivized commuter club and public transportation subsidy program
    • We promote the importance of work/life balance by offering workplace flexibility
    • We offer a variety of learning and career development opportunities


    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:
    ASRS Lifetime Benefits


    Contact Us:
    Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by contacting
    Requests should be made as early as possible to allow time to arrange the accommodation. The State of Arizona is an Equal Opportunity/Reasonable Accommodation Employer.

    #J-18808-Ljbffr