IT Developer

Job Announcement: HR2023:144 Position Title: IT Developer Advertising: Publicly Department: Information Technology (I.
T) Division: Tribal Chair’s Office Immediate Supervisor: Manager-IT Development Department Director: Director-Information Technology Employment Status: Exempt Position Type: Regular Full–Time Mandatory Reporter: No Background Check Required: Yes (data-sensitive)** Opening Date: Tuesday, December 12, 2023 Closing Date: Open Until Filled Preference shall be given in accordance with the Title 33 (Tribal Employment Rights) of the Tribal Code/DFWP.
Overall Objectives of Position The IT Developer will provide application support and maintenance on business facing systems, by becoming an expert on the use of all aspects of these systems; delivering support to existing business users and investigating and resolving application errors, data discrepancies and queries, identifying, proposing and developing application system changes, better uses, enhancements and developments and liaising with appropriate vendors, users and the IT Team.
The IT Developer trains end users and performs other tasks as assigned.
This job description is not an all-inclusive list of the duties and responsibilities of this position.
The IT Developer is expected to perform all duties and responsibilities necessary to meet the goals and objectives of applicable programs.
The IT Developer is expected to live the Purpose and Values of the Poarch Band of Creek Indians and will go beyond the call of duty.
Primary Responsibilities of the IT Developer Writes complex SQL queries to combine large data sets and automate ETLs and daily reporting processes.
Gathers, analyzes, and transforms raw data from disparate databases into warehoused and actionable information for use in visualizations, reports, integrations with 3rd party systems and dashboards.
Designs, develops, and implements complex database systems, programs, and applications.
\ Provides database and applications programming support and troubleshooting to multiple IT projects.
Interacts with the other departments to understand and identify informational needs, problems, and requirements.
Deliver applications, data warehouse and custom reporting solutions.
Analyzes, troubleshoots, and tunes SQL and Application code.
Develops and maintains web interfaces to database information to permit the viewing and modification of database contents from browser-based clients.
Performs complex data analysis and develop logical solutions to problems.
Works independently while adhering to company policies and standards; effectively enforce company standards.
Provides technical advice and consultation.
Provides timely project status and issue reporting to management.
Works with end users to identify and analyze business processes, workflows, requirements, issues, and opportunities, and evaluate the potential application of new or modified technology solutions and/or processes.
Resolves data discrepancies between all business systems and applications.
Responsible for beta test releases, updates, and enhancements to new and existing business systems and assist in the coordination of user sign-off and roll out.
Provides training on new and existing systems as needed to support operational activities.
Troubleshoots end user reported problems or coordinate internal and/or external support if necessary.
Develops training manuals, standard operating procedure, document reoccurring issues and communicate resolutions to end users.
Administers user accounts for internal and customer facing software systems.
Trains all new employees on enterprise business system applications.
Prepares workflow charts to specify in detail operations to be performed.
Corrects system application errors after implementations.
Resolves issues related to project specifications or programming.
Performs other duties as assigned by appropriate person.
Day-to-day Responsibilities Administers a variety of software systems including Paramount Workplace, Microsoft Dynamics GP, and others.
Maintains and administers daily operations of software systems.
Rapidly diagnoses and fixes problems.
Education/License/Certification and Experience Requirements Bachelor’s Degree with two (2) years of related IT experience and/or a combination of related education and IT experience equivalent to six (6) years.
Two (2) years of experience as a Developer required.
Experience writing complex SQL queries, combining large date-sets, integrating data from multiple systems required.
Experience automating tasks, integrations, ETLS preferred.
Experience in SSMS, SSRS, Crystal Report, SSIS, BI360 and advanced Excel reports with Power Query preferred.
Experience writing API calls to query and post data 3rd party systems preferred.
Experience writing code in C#, or other OOP language preferred.
Experience working with Microsoft Dynamics GP preferred.
Experience with SQL Server preferred.
Experience with Project Management preferred.
Experience working with Paramount Workplace preferred.
Skills Required Demonstrated knowledge of and experience in common modern programming languages such as ASP.
NET, VB.
NET.
C#.
NET, Transact SQL, stored procedures, functions.
Skilled in managing small to medium-size projects.
Working knowledge of business processes, system development and process improvements.
Ability to quickly analyze and problem solve.
Exceptional interpersonal and communication (verbal and written) skills.
Must be able to communicate pleasantly with clients and be able to demonstrate, teach and/or communicate implemental solutions to clients and subordinates.
Must be analytical and organized with attention to detail.
Able to work well independently and able to work and communicate with others with a professional demeanor.
Must be people oriented and relate well to people from diverse backgrounds.
Additional Requirements Ability to work odd and irregular hours, as needed.
Must successfully pass the required criminal and character background check.
Ability to travel and participate in required training, leadership development, and other events.
Ability to adequately and successfully perform all duties and responsibilities of this position.
Every applicant must complete an application provided by Human Resources.
A resume will not be accepted in the place of an application.
**Please note ALL individuals selected for employment are required to complete a background investigation.
Individuals being placed in positions designed as child-sensitive or data-sensitive must successfully complete a background check prior to employment.
INDIAN PREFERENCE, SPOUSAL PREFERENCE, OR FIRST GENERATION: In the event more than one applicant meets the requirements, as stated in a job description, preference shall be given in the following order: (1) Tribal Member (2) First Generation Descendant of a Tribal Member (3) Spouse of Tribal Member (4) Indian (5) Non-Indian In the event that a position of employment is funded in whole or in part my any federal grant and/or contract or other public funding, preference shall be given in the following order: (1) Indian (2) Non-Indian In order to receive preference, the appropriate documentation must be submitted.
COMPLAINTS ABOUT RECRUITMENT PROCESS: Complaints about the recruitment or selection process for employment should be directed in writing to the Human Resources Director of PCI Tribal Government.
An applicant who disagrees with any issue related to the application or hiring process may submit a letter to Human Resources within ten (10) calendar days from the date the applicant knew or should have known that an adverse hiring decision had been made.
Human Resources will provide a written response within fourteen (14) calendar days informing the applicant of any administrative remedy to be provided.
The decision of the Human Resources Director shall be final and not subject to further administrative appeal.
Any applicant who has exhausted all administrative remedies may be eligible to file a complaint with the TERO Office.
Jason B.
Rackard Human Resources Director 5811 Jack Springs Rd.
Atmore, AL 36502 jrackard@pci-nsn.
gov 251-368-9136 3xR7WQBxIZ