Data Warehouse Analyst

3 weeks ago

Ames, Iowa, United States State of Iowa Full time
About the Role

We are seeking a highly skilled Data Warehouse Analyst to join our team at the State of Iowa. As a Data Warehouse Analyst, you will play a critical role in designing, developing, and maintaining our data warehouse solutions to support our analytical and business reporting needs.

Key Responsibilities
  • Design and develop data warehouse solutions to support business intelligence and 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 applications incorporating data from various sources
  • Create and optimize ETL processes to ensure efficient and reliable data flow
  • Perform data profiling, cleansing, and validation to maintain high levels of data integrity and quality
  • Develop and implement effective data models, schemas, and queries to facilitate advanced analytics and decision-making capabilities
  • Manage and monitor data warehouse performance, identifying and resolving any issues or bottlenecks
  • Provide technical support and training to end-users
Requirements
  • 6 months' experience writing complex T-SQL queries against SQL Server database
  • 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
Preferred Qualifications
  • 18 semester hours of education or 1 year of experience in GIS
  • Demonstrated proficiency with major ESRI software products
  • Ability to create, edit, import, export, project, and georeference GIS data
  • Ability to conduct spatial analyses and queries to answer complex questions relating to spatial data
  • Ability to produce cartographic documents that clearly present outputs from spatial analyses
What We Offer
  • Competitive pay and benefits package
  • Opportunities for professional growth and development
  • Paid time off and holidays
  • Employee assistance program
  • Robust benefits package

  • Data Warehouse Analyst

    3 weeks ago

    Ames, Iowa, United States State of Iowa Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Analyst to join our team at the State of Iowa. As a Data Warehouse Analyst, you will play a critical role in designing, developing, and maintaining our data warehouse solutions to support our analytical and business reporting needs.Key ResponsibilitiesDesign and develop data warehouse solutions to...

  • GIS Analyst

    5 days ago

    Ames, Iowa, United States Iowa Department of Administrative Services Full time

    Job SummaryThe Iowa Department of Transportation is seeking a student intern to join their GIS Section in the Traffic & Safety Bureau. As a GIS Analyst, you will work with the entire Traffic & Safety team to perform a variety of GIS tasks involved with the development, maintenance, and implementation of geospatial assets.Key Responsibilities* Utilize desktop...

  • GIS Analyst

    1 week ago

    Ames, Iowa, United States Iowa Department of Administrative Services Full time

    Job Summary:The Iowa Department of Transportation is seeking a student intern to join their GIS Section within the Traffic & Safety Bureau. This internship will provide an opportunity to grow skills and experience in GIS, working with the entire Traffic & Safety team.Key Responsibilities:Utilize desktop and online resources to create and edit data...

  • Senior Financial Analyst

    17 hours ago

    Ames, Iowa, United States PYLE & ASSOCIATES PC Full time

    We are seeking a highly skilled Certified Public Accountant to lead our financial reporting efforts. As a key member of our team, you will be responsible for preparing and analyzing financial records and tax returns for PYLE & ASSOCIATES PC.Key Responsibilities:Prepare and examine accounting records, financial statements, and tax returnsDevelop and implement...

  • Quality Assurance Specialist

    4 weeks ago

    Ames, Iowa, United States Collabera Full time

    Job SummaryWe are seeking a highly skilled QA/QC Technician to join our team at Collabera. As a key member of our quality assurance team, you will be responsible for ensuring the quality of our products and services.Key ResponsibilitiesConduct inspections of raw materials, intermediates, and finished goods to ensure compliance with established test...

  • Maintenance and CMMS Optimization Specialist

    4 weeks ago

    Ames, Iowa, United States HNI Corporation Full time

    Optimize Our Operations as a Maintenance and CMMS Optimization EngineerWe're seeking a skilled Maintenance and CMMS Optimization Engineer to join our HNI Corporation team in Muscatine, IA. As a key member of our HNI Workplace Furnishings team, you'll play a pivotal role in optimizing our manufacturing operations.Key Responsibilities:Investigate and resolve...

  • Behavior Technician or Registered Behavior Technician

    2 weeks ago

    Ames, United States ChildServe Full time

    Behavior Technician or Registered Behavior Technician - Applied Behavior Analysis (Full-Time) Behavioral Health (Mental Health, RBT, Psychologists, BCBA) Ames, Iowa Apply Description Are you looking for a position where you see progress happen in real life? Where you get to watch children master their goals? If so, then a position within...

  • Behavior Technician-Applied Behavior Analysis

    4 weeks ago

    Ames, United States ChildServe Full time

    Behavior Technician-Applied Behavior Analysis (Full-Time) Behavioral Health (Mental Health, RBT, Psychologists, BCBA) Ames, Iowa Apply Description Are you looking for a position where you see progress happen in real life? Where you get to watch children master their goals? If so, then a position within ChildServe's ABA program is for you! We...