Register
Recruit Create CV
Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
Some similar recruitments
Information Systems Specialist 6 (Child Support Program Business Intelligence / Etl Developer)
Recruited by Department of Justice 9 months ago Address , Salem, 97301, Or $5,315 - $8,049 a month
Sr. Business Intelligence Developer | Full Time
Recruited by Henry Ford Health 11 months ago Address , Detroit, Mi
Business Intelligence / Etl Cognos Developer (Information Systems Specialist 7)
Recruited by Department of Justice 11 months ago Address , Salem, 97301, Or $5,885 - $8,894 a month

Business Intelligence Developer (Etl)

Company

State of Arizona
Address , Phoenix, 85007
Employment type FULL_TIME
Salary $84,000 a year
Expires 2023-09-12
Posted at 9 months ago
Job Description

Come join the Arizona Department of Revenue, one of the 2022 and 2023 Top Companies to Work For in Arizona! We are committed to our team-based work environment and culture; one that is unlike any other in state government. The Arizona Department of Revenue (ADOR) is consistently striving to recruit team members who are committed to providing quality services to the citizens of Arizona and are passionate about creating solutions to the ever-evolving decisions faced within state government. If you have a passion for service and are driven to “make things better”, please apply to join the ADOR team and assist the Grand Canyon State by exemplifying our mission of “Serving Taxpayers.”

The Arizona Department of Revenue is looking for a Business Intelligence Developer (ETL )to utilize their advanced skills to support and improve complex data warehousing and reporting operations. This position will be responsible for designing, coding, and documenting ETL interfaces, as well as creating reports using Business Intelligence Reporting tools, such as COGNOS, SSRS, and PowerBI.

Additionally, this role will engage in programming tasks, including the creation of database objects, unit and integration testing, and verification of programming logic. The ETL Developer will assist Quality Assurance and User Acceptance Test Teams in resolving application-related issues during testing, and develop comprehensive online help systems, user manuals, and training manuals, as needed.

If you’re looking to put your skills to great use for the benefit of Arizona taxpayers, this role is for you!

Job Duties:
Essential duties and responsibilities include but are not limited to:
  • Work with management and project management offices to develop and maintain project objectives and plans
  • Identify technologies that support the system development goals
  • Design, develop, and maintain ETL processes and Business Intelligence reports
  • Perform unit and integration testing to ensure business requirements are met and programming logic executes as expected
  • Work closely with business analysts and/or users to determine requirements and receive feedback, and provide support and training to users during user testing
  • Plan, manage, and provide project status following the adopted agency’s Software Development Life-Cycle (SDL) from inception to implementation
  • Work as a Senior Developer to include, where applicable, programming and design of overall system architecture
  • Organize and participate in team project meetings, to include weekly status reports during all project phases, business requirements gathering and reviews, design reviews, and test conditions reviews
Knowledge, Skills & Abilities (KSAs):
Knowledge of:
  • Release and configuration management
  • Azure DevOps, preferred
  • XML, XML schemas, and extracting data from complex XMLs
  • Extract, Transform, and Load methodologies

Skilled in:
  • N-tier object oriented client/server applications
  • Pragmatic Works, BIXpress, BIDocumentor, and Task Factory
  • Microsoft Visual Studio and .NET technologies
  • Developing and writing effective technical documentation
  • Developing SSIS ETL software and SSRS reports

Ability to:
  • Lead, motivate, and coordinate team members to meet business expectations
  • Develop client/service strategies
  • Manage time-boxed Production Support defect releases
  • Research and analyze information
  • Bring projects to completion, on time and within budget using the System Design Life Cycle and the established Project Management methodologies
  • Effectively communicate, orally and in writing
Requirements and Selective Preference(s):
  • REQUIREMENT: Bachelor’s Degree and 8+ years of related experience, or equivalent combination of experience
  • PREFERENCE: Additional experience with Cognos and Azsure DevOps
Pre-Employment Requirements:
The final candidate will be required to abide by the the following pre-employment checks:
  • Employment Verification and Reference Checks
  • State and Federal Criminal Background Check, including fingerprinting
  • If applicable, ASEDRA Authorized Driver Identification Check
  • Arizona Tax Filing Records Check

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

Benefits:
The State of Arizona provides a world class comprehensive benefits package including:
  • A robust and affordable insurance plan that includes medical, dental, vision, life insurance, short-term, and long-term disability options.
  • Work-life balance and additional options for life betterment such as the Infant at Work Program, State Wellness Program, Public Transit Discounts, Alternate Work Schedules, and Telework opportunities.
  • Paid time off for holidays, sick days, annual leave, military leave, bereavement leave, and civic duty leave
  • Higher education discounts for State employees and tuition reimbursement up to $5,250 per fiscal year, available to seek further career advancement or certification in Continuing Professional Education.

For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Retirement:

Top ranked Arizona State Retirement System (ASRS) provides 100% employer matched contributions (enrollment eligibility will be effective after 27 weeks of State employment). ASRS provides a lifelong benefit based on years of service earned, or worked, and your ending salary. Learn more about ASRS at: https://www.azasrs.gov/content/new-and-prospective-members.

Contact Us:

Persons with a disability may request a reasonable accommodation such as a sign language interpreter or an alternative format by contacting 602-716-6950. 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.

If you have any questions, please contact the ADOR Human Resources office at [email protected] or at 602-716-6950 for assistance.