Job Description
Only applicants who meet the Minimum Qualification Requirements and meet all selective requirements (listed below) will be placed on the eligible list.
Iowa Department of Transportation’s Mission is Making Lives Better Through Transportation . To accomplish our Mission, the person selected for this position will demonstrate actions and behaviors guided by the Iowa Department of Transportation’s five CORE values: Safety First, People Matter, Customer Focused, Servant Leadership, and Integrity Without Exception .
Location: Ames – 50010 – Story County, IA
Shift Requirements: Days, Monday-Friday; Flexible schedule available. Some travel may be required.
Are you passionate about data and ready to take on an exciting challenge in the world of data warehousing? We're on the lookout for a friendly and detail-oriented Data Warehouse Analyst to join our dynamic team! In this role, you will be the backbone of our data-driven decision-making process, working closely with cross-functional teams to ensure our data infrastructure is top-notch. Your expertise will help us optimize data storage and access methods, enabling our stakeholders to make informed decisions effectively. You'll have the chance to dive deep into data architecture, analyze data flow, and contribute significantly to the design and maintenance of our data warehouse environment. If you enjoy problem-solving and have a knack for transforming raw data into meaningful insights, this is the perfect opportunity for you! Join us and be a part of a collaborative atmosphere where your contributions are valued, and your ideas can lead to innovation. Bring your enthusiasm for data and your analytical skills to our team, and let's build something incredible together!
As a Data Warehouse Analyst your responsibilities will include, but are not limited to:
- Design, develop and maintain data warehouse solutions to support the Iowa Department of Transportation ‘s analytical and business reporting needs.
- Collaborate with cross-functional teams to gather requirements, identify data sources, and ensure accurate integration into the data warehouse.
- Develop project specific FME (Feature Manipulation Engine) applications incorporating data from Bureaus, field staff and consultant work products. This will require extensive knowledge of the department’s GIS Enterprise and LRS (Linear Reference System).
- Create and optimize ETL (Extract, Transform, Load) processes to ensure efficient and reliable data flow from various systems into the data warehouse.
- Perform data profiling, cleansing, and validation to maintain high levels of data integrity and quality across all datasets.
- Develop and implement effective data models, schemas, and queries that facilitate advanced analytics and decision-making capabilities.
- Manage and monitor data warehouse performance, identifying and resolving any issues or bottlenecks to enhance overall system efficiency.
- Provide technical support and training to end-users, ensuring they have the necessary tools and knowledge to utilize data warehouse resources effectively.
- Stay current with industry trends and best practices in data warehousing and analytics, recommending improvements and innovations to our existing systems.
What we offer YOU:
- Competitive pay and benefits package including health, dental, flexible spending, and life insurance
- Insurance benefits start first of the month following 30 days of employment. 2024 health and dental insurance premiums can be found here .
- Opportunities for professional growth and development.
- Paid time off effective immediately - biweekly vacation, separate sick leave, accruals rollover on a yearly basis, and 9 paid holidays per year.
- Iowa Public Employee Retirement System (IPERS) Retirement Package with employer match
- Optional 401A plan with employer contributions.
- Employee Discount Programs from variety of vendors (vision, cellular, fitness, recreation, season passes, travel, counseling; legal, financial).
We encourage you to view more about the State of Iowa Employee benefits and costs at the State of Iowa Employee Benefits Website !
You have the freedom to flourish in Iowa – Apply today!
If you require a reasonable accommodation in completing any screening, interviewing, pre-employment testing, or otherwise participating in the selection process, please direct your request to the Affirmative Action & Equal Employment Opportunity (AA/EEO) Officer at: aa-eeo@iowadot.us
Reasonable accommodation such as: interpreter, translator, written materials, modified equipment / devices, ADA access, etc. This does not include scheduling needs.
Selectives
121 T-SQL Business Query Writing
6 months’ experience writing complex T-SQL queries against SQL Server database which includes:
- SQL database experience must use most recent SQL release or two versions prior
- Queries against normalized, de-normalized and dimensional SQL database
- Use of database data models to design and construct queries
- Analyzing end-user presentation requirements and business rules and then translating into T-SQL queries
- Creating parameterized queries for application database calls
- Providing input to DBA(s) on data element formats and data granularity necessary to meet end-user requirements
OR
230 Geographic Information Systems (Department of Natural Resources)
18 semester hours of education or 1 year of experience that demonstrates the applicant has competencies in the following areas:
- Ability to create, edit, import, export, project, and georeference GIS data.
- Demonstrated proficiency with the major ESRI software products. These products include ArcView, ArcInfo, ArcGIS.
- Utilize user-developed and/or ESRI scripts and extensions for incorporation and utilization in projects.
- Ability to conduct spatial analyses and queries in order to answer complex questions relating to spatial data.
- Ability to produce cartographic documents which clearly present outputs from spatial analyses. Document formats should at a minimum include hardcopy as well as the following digital formats .pdf, .tif, and .jpg.
- Ability to work with, or train, others to use GIS to attain a common goal
Applicant must provide specific work examples to demonstrate each of the competencies. The examples should include a thorough explanation of the project goal, the process utilized and the result of the process.
OR
984 Business Information Technology
6 months' experience, 12 semester hours, or a combination of both, in business information technology including any of the following: support for management decision-making using computer technology, i.e., computer decision support systems, billing, accounting, queries, data modeling, and IT/manager interface including support for individual, group and corporate goals and managerial concerns with the design, use and implementation of information technology.
Minimum Qualification Requirements
Graduation from an accredited four-year college or university with demonstrated experience equal to three years of full-time work accomplishing activities related to formal or informal data warehousing decision support systems. Experience should include both technical and non-technical activities, including integrating mapping data needs, data flows and business processes;
OR
substitution of experience of the caliber and scope indicated above for the required undergraduate college education on the basis of one year of qualifying experience is equivalent to one year of undergraduate education;
OR
substitution of twenty-four hours of graduate level course work in a special program curriculum such as Social Work, Public Policy, or Business Administration or related field for each year of the required experience of the caliber and scope indicated above to a maximum substitution of two years;
OR
employees with current continuous experience in the state executive branch that includes experience equal to twelve months of full-time work as a Fiscal & Policy Analyst, Fiscal & Policy Analyst Senior, Management Analyst 4, Income Maintenance Worker 6, Social Worker 6 or Statistical Research Analyst 3. Experience must include both technical and non-technical activities related to formal and informal data warehousing, decision support systems, or significant levels of management analysis and reporting or function in a systems liaison role.
For additional information, please click on this link to view the job description.