Information Technology Specialist 4- ETL DeveloperPrint (https://www.governmentjobs.com/careers/iowa/jobs/newprint/4531965) ApplyInformation Technology Specialist 4- ETL DeveloperSalary $65,395.20 - $101,150.40 AnnuallyLocation Des Moines - 50319 - Polk County, IAJob TypeFull-timeRemote EmploymentFlexible/HybridJob Number24-04146Agency185 Department of Management - Office of Chief Information OfficerOpening Date06/04/2024Closing Date6/16/2024 11:59 PM CentralLinkedIn Tag#LI-POSTPoint of ContactDishti Mehra ([email protected])
Description
Benefits
Questions
Job DescriptionThe State of Iowa, Department of Management (DOM), Division of Information Technology (DoIT) is seeking a dynamic and experiencedETL Developerto join our team. The successful candidate will be responsible for developing and maintaining efficient Extract, Transform, Load (ETL) processes to extract data from various sources, transform it into a standardized format, and load it into our Enterprise Data Warehouse. This role requires a proactive individual with strong technical skills, attention to detail, and excellent communication abilities.Key Responsibilities:
Extract data from diverse sources, including databases, flat files, APIs, and external systems, ensuring efficiency and minimal impact on source systems.
Cleanse, validate, and transform data to maintain accuracy and consistency, while meeting business requirements.
Design, develop, and optimize ETL processes, workflows, and data pipelines using tools like Informatica or programming languages such as SQL and Python.
Collaborate with business stakeholders to design data models that support ETL processes and strategic goals specific to Workforce development.
Implement data validation and quality checks to identify and resolve data issues, ensuring data accuracy and completeness.
Monitor ETL jobs for failures or anomalies, troubleshoot issues promptly, and develop alerting mechanisms for failures or data quality problems.
Address performance bottlenecks in ETL processes and optimize SQL queries, data transformations, and workflows for efficiency.
Ensure ETL processes adhere to data security and compliance standards, including data privacy regulations such as GDPR and HIPAA.
Plan for scalability as data volumes grow and perform routine maintenance and updates to ETL workflows and systems.
Maintain thorough documentation of ETL processes, data mappings, and transformations for troubleshooting and auditing purposes.
Collaborate closely with data engineers, analysts, and other stakeholders to understand data requirements and align ETL processes with overall architecture and infrastructure.
Prepare and present metrics to senior leadership on different aspects of the ETL process and data quality.
Please note, candidates for this position must reside in the state of Iowa at the time of starting the role.Employer Highlights:The Department of Management, Division of Information Technology provides adaptable, secure, and cost-effective technology services and solutions to support the agencies across the State of Iowa, trusted partners, and citizens. We are responsible for managing all IT assets, projects, and resources to deliver top-tier technology support and expertise across the enterprise. Our strength is driven by the skills, talents, and diversity of our people.We have a great total compensation package for all of our full-time employees, including:
Iowa Public Employees' Retirement System (IPERS)
Retirement Investors Club (RIC)
Flexible Working Environment- Work from Home Opportunities
Health, Dental and Vision Insurance
Vacation Leave
Sick Leave
Paid Holidays
Flexible Spending Accounts
Life Insurance
Long-Term Disability Insurance
Background check requirements
After a conditional offer of employment has been made, and as the final step in the hiring process, candidates for this position will be subject to a background investigation, which may include but may not be limited to a verification of a candidate's education, previous employment/work history, contact of personal references, motor vehicle records, and a criminal history check (including through Federal, State, or Local criminal justice agencies).
Information gathered as part of such background investigation will be treated as confidential to the extent permitted by Iowa Code section 22.7, 8B.4A, and other applicable laws, rules, and regulations; provided that, to the extent permitted by applicable law, such information shall be available to candidates upon request.
Minimum Qualification RequirementsGraduation from an accredited four-year college or university and experience equal to two years of full-time work: operating a multi-job computer; installing, operating and coordinating computer based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks and/or servers; managing operating systems; developing/ delivering information management training; providing Information Technology (IT) customer service; or designing/administering Internet sites;ORan equivalent combination of education and experience substituting the completion of an approved curriculum/specialized training program developed and implemented by or in cooperation with state government; or eighteen semester hours of accredited post high school course work in one of the specialty areas listed above; or certification by an authorized educational institution/major computer or software producer in an area directly related to one of the specialty areas listed above, for the required education;ORan equivalent combination of education and experience substituting one year of the required experience for thirty semester hours of the required education;ORemployees with current continuous experience in the state executive branch that includes experience equal to six months of full-time work as an Information Technology Specialist 3.For additional information, please click on this link to view the job description (https://das.iowa.gov/sites/default/files/hr/documents/classandpay/JobClassDescriptions/InformationTechnologySpecialist4-00121-90121.pdf) .Why Choose the State of Iowa?At the heart of our commitment to excellence is a dedication to our most valuable asset – our employees. Discover the outstanding benefits that set us apart as an employer of choice.Our Robust Benefits Package Includes:Competitive Compensation:Enjoy a competitive salary that reflects directly on your skills and expertise.Keep in mind, your wage is just one part of your total compensation. Unlock the complete value of your employment with the State of Iowa by using our user-friendlyTotal Compensation Calculator (https://das.iowa.gov/media/3773/download?inline) .Gain insights into your comprehensive annual compensation, including salary and State-provided benefits.Health and Wellness:Prioritize your well-being with our comprehensive health plans, including medical, dental, and vision coverage. Enjoy the peace of mind knowing that the State of Iowa covers 90% of the premiums, providing you and your loved ones with excellent coverage at a remarkably low cost.Retirement Planning:We are proud to offer the Iowa Public Employees Retirement System (IPERS). A defined benefit plan, IPERS benefits are guaranteed for life, meaning once you retire, you will receive the same monthly benefit for the remainder of your life (once vested). We invest in your long-term financial well-being, so you can retire with peace of mind.Click here to learn more about IPERS (https://ipers.org/members) .Paid Time Off:Life is unpredictable, and at the State of Iowa, we understand the importance of work-life balance. Our leave policies, including paid holidays, vacation, and sick leave with unlimited accrual, ensure you have the flexibility you need for personal and family matters.Professional Development:Elevate your career with continuous learning opportunities. We support your growth through training programs, workshops, and tuition reimbursement.Employee Assistance Program (EAP):We care about your well-being beyond the workplace. Access confidential counseling, resources, and support through our Employee Assistance Program.Diversity and Inclusion:Be part of a diverse and inclusive workplace that embraces all backgrounds and perspectives. We believe diversity is a strength that drives innovation.Join Us - Elevate Your Career:Ready to elevate your career with the State of Iowa?Click here (https://iowa.attract.neogov.com/recruitment/p/benefits) to explore more about our unparalleled benefits and discover what makes us unique. Your success is our priority!01 Do you understand that the answers to all of the following questions must be truthful, honest, and accurate to the best of your ability? Please read all questions and answers thoroughly and make sure you understand them completely.Ensure the answers to your questions match the information filled out on your application and the attachments you have uploaded. If the answers to your questions are inconsistent with your application information or uploaded attachments, you will be given zero points for the question.Knowingly misrepresenting the facts when submitting any information related to an application, examination, certification, appeal, or any other facet of the selection process will result in your disqualification from this application and future employment with the state of Iowa.
Yes - I understand and agree.
No
02
PLEASE READ CAREFULLY
Have you filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq?
No - I have NOT filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq
Yes - I HAVE filed a registration statement pursuant to the federal Foreign Agents Registration Act of 1938, as amended, 22 U.S.C. §611 et seq
03
Have you graduated from a four-year college or university? IF YES- How many years of full time experience do you have operating a multi-job computer; installing, operating and coordinating computer based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks and/or servers; managing operating systems; developing/ delivering information management training; providing Information Technology (IT) customer service; or designing/administering Internet sites?
I have not graduated from a four-year college or university
No experience to less than one year
One year to less than two years of the identified experience
Two years or more of the identified experience
04
How many years do you have of combined post high school education in any field and experience in operating a multi-job computer; installing, operating and coordinating computer based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; or designing/administering Internet sites?
I do not have any of the identified education or experience
Less than two years of the combined identified education or experience
Two years to less than four years of the combined identified education or experience
Four years to less than six years of the combined identified education or experience
Six years or more of the combined identified education or experience
05
Have you completed an approved curriculum/specialized training program developed and implemented by or in cooperation with State Government; or eighteen semester hours of accredited college or university course work in one of the specialty areas listed above (operating a multi-job computer; installing, operating and coordinating computer based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; or designing/administering Internet sites); or certification by an authorized educational institution/major computer or software producer in an area directly related to one of the specialty areas listed above? IF YES - How many years of experience do you have operating a multi-job computer; installing, operating and coordinating computer based networks; installing/maintaining database management systems; developing business application processes; developing/operating system programs; installing/maintaining personal computers, Local Area Networks and/or servers; managing operating systems; developing/delivering information management training; providing Information Technology (IT) customer service; or designing/administering Internet sites?
NA - I have not completed the identified currriculum
Less than one year of experience in the identified areas
One year to less than two years of experience in the identified areas
Two years or more of experience in the identified areas
06
If you are a current State of Iowa employee (executive branch) - How many months of full-time work have you had as an Information Technology Specialist 3 for the State of Iowa?
I am not a current State of Iowa employee (executive branch)
Less than three months of experience as an Information Technology Specialist 3 for the State of Iowa
Three months to less than six months of experience as an Information Technology Specialist 3 for the State of Iowa
Six months or more of experience as an Information Technology Specialist 3 for the State of Iowa
Required Question
AgencyState of IowaAgency185 Department of Management - Office of Chief Information OfficerAddress200 East Grand Ave.Des Moines, Iowa, 50309Websitehttps://ocio.iowa.gov/ApplyPlease verify your email addressVerify Email