Greater Iowa Credit Union
  • 29-Apr-2022 to Until Filled (CST)
  • IT
  • Ames, IA, USA
  • Full Time

We are currently seeking a Data Systems Analyst that is responsible for building and maintaining data sets, reports, and dashboards to support business intelligence. They partner with managers and senior leaders to identify data and reporting needs, and then design and build data repositories, data pipelines, reports, and dashboards to support those needs. They manage the organization's data platforms, and participate in the creation and execution of the organization's data strategy. They manage, administer, and use technologies such as Microsoft SQL Server, Azure database services, Power BI, SSRS, and Crystal Reports.

Location: 1509 Baltimore Drive, Ames, IA 50010

Hours: Monday - Friday 8am to 5pm, rotating Saturdays 9am to 1pm

Essential Functions & Responsibilities:

  • Report and dashboard creation. Collaborates with business leaders to identify data reporting requirements. Receives and process requests for new data reports. Creates reports using SSRS, Crystal Reports, and Power BI and/or Tableau. Develops self-service reporting capabilities and trains others on how to use self-service reporting capabilities.
  • Data platform management. Performs general administration and management tasks for Microsoft SQL Server instances and databases. Optimizes database management for security, performance, and availability. Manages database access and backups. Designs and builds data warehouses and data marts as-needed.
  • Data pipelines and ELT functions. Creates data pipelines and ETL processes that support application-to-application data transfers, data migrations, and data warehouse enrichment. Ensures data quality and integrity during processing.
  • Data management documentation. Creates and maintains relevant documentation including data flow diagrams, data platform architecture diagrams, data catalogs, data dictionaries, and data platform security and resiliency standards and controls.
  • Data governance. Participates in data governance activities as a technical subject matter expert to assist in the creation of data policies, standards, and definitions. Collaborates with the Information Security Officer to identify data security risks, determine data security control requirements, and implement data security solutions.
  • Performs other related duties as needed. Participates in Saturday rotation.

Knowledge and Skills:

Experience: Five years of relevant experience in a combination of database administration, data platform engineering, data analysis, or business intelligence, including experience with:

  • Managing data platforms including a data warehouse
  • Microsoft SQL Server, SSRS, and SSIS
  • Crystal Reports, Power BI and/or Tableau
  • Scripting languages such as SQL, T-SQL, and Python
  • Creating data pipelines and ETL functions
  • Creating data flow diagrams
  • Creating or maintaining a data catalog
  • Azure database services experience preferred
  • IBM DB2 administration experience preferred
  • Financial institution experience preferred

Education: Associate degree in information technology or related field. Bachelor's degree preferred. CDMP, DGSP, Microsoft, or other relevant certifications preferred.

Other Skills:
1. Expert knowledge of data management concepts and best practices
2. Strong knowledge of databases, data warehouses, ETL functions, and data pipelines
3. Strong knowledge of data query and scripting languages including SQL, T-SQL, and Python
4. Ability to develop and execute a data management strategy
5. Ability to create moderately-complex reports using Crystal Reports
6. Ability to create moderately-complex BI dashboards using Power BI or Tableau
7. Familiar with data governance concepts and best practices
8. Familiar with data security concepts and best practices

Physical Requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing duties of this job, the employee is regularly required to sit, stand, walk and manipulate (life, carry, move) light to medium weights of 10-50 pounds. Requires good hand-eye coordination, arm, hand and finger dexterity, including ability to grasp, and visual acuity to use a keyboard, operate equipment and read technical information.

Work Environment:
Work is performed in a standard office environment with a quiet to moderate noise level. May periodically travel to other branches. The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • Greater Iowa is an Affirmative Action, Equal Opportunity Employer (AA/EOE). All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
Greater Iowa Credit Union
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Sign Up For Job Alerts!

  • Share This Page
.
Contact Locations News Events FAQ Membership Members-Only SwapSpot Espanol Careers logo Pesonal 24/7 Access Business Belong