You are viewing a preview of this job. Log in or register to view more details about this job.

Data Architect

Job Title: Data Architect
Location: Teacher Administrative Center, 3215 Cuming Street, Omaha, NE 68131
Work Schedule/FLSA Status: 261 day 12-month / Salaried Exempt
Position Purpose: 
This position is primarily responsible for the overall data architecture and data strategy for the school district’s business intelligence (BI) environment. This includes analyzing, planning, and developing the architecture to ensure that it is in line with business requirements. The Data Architect will provide expertise for data related projects and activities, as well as influence and drive strategic data efforts with other departments.  
Essential Performance Responsibilities:
  • Write and maintain SQL stored procedures and SQL Server Agent Jobs
  • Maintain and update SQL databases for the District dashboards/applications 
  • Communicate with software vendors
  • Document specific details for development and provide written documentation for systems, programs, and procedures
  • Develop and maintain comprehensive data dictionary, data models, mapping documents, and inventory of ETL jobs
  • Develop ETLs (SSIS development)
  • Assist in the management of SQL and Windows security
  • Provide ongoing support for Microsoft Identity Management (MIM)
  • Provide support for the Tableau server environment
  • Manage application security for Tableau
  • Provide technical expertise for data analytics, data visualizations, custom applications, and various District IT projects
  • Design, develop, install, monitor and troubleshooting support for district data mart and warehouse solutions
  • Assist technical staff with development of complex SQL queries
  • Provide technical information and advice regarding network interconnections and overall data processing master plans
  • Determine and assist with fixes, problem resolutions, escalations, and cases that affect users
  • Provide end-user training in small group settings and on a one-to-one basis
  • Assist technical staff and contractors with development, coding, and database design questions
  • Collaborate with the IMS Technical Support Security and Database Administrators as appropriate
  • Identify areas for improvement and make recommendations
  • Escalate problems to the IMS Technical Support Leads and IT Directors as appropriate
  • Provide input and knowledge as needed to others on the IMS Technical Support teams
  • Evaluates software/hardware requirements and/or enhancements before making purchases or installing version upgrades
  • Perform ETL monitoring procedures on a routine basis
  • Analyze and evaluate performance problems
  • Document critical processes, repeatable processes, work requests and instructions for technical support or end users, stored procedures, SQL jobs and automated SQL jobs
  • Promote Database Objects (Procs/Views), SSIS Objects, SSRS Objects, and Tableau Objects as requested
  • Establish strong standards of professional ethics when relating to staff, students, parents, administration, and the community
  • Maintain strict confidentiality
  • Complies with the District’s operational guidelines 
  • Keeps abreast of technology developments relating to current trends/issues and education needs (such as training, reading literature, participating in professional organizations)
  • Provide technical assistance and training to staff as necessary; willingness to share knowledge with others 
  • Adhere to District and IMS security practices
Knowledge, Skills, and Abilities:
  • Minimum of bachelor’s degree in a technology related field or equivalent experience required
  • Minimum of five years of database administration or relevant IT experience with recent or current versions of Microsoft SQL Server required
  • Advanced experience with DDL, stored procedures, views, indexes, foreign keys, etc.
  • Advanced experience using strong analytical, problem-solving, and organizational skills 
  • In-depth knowledge of SQL, data marts, data warehouses, and deep expertise of Microsoft BI Stack (SSIS/SSRS)
  • Competency in MS SQL Server data extracting, transformation and loading tools, Integration Services, and Reporting Services
  • Proficiency with monitoring tools (such as Idera)
  • Proficient in developing and executing rigorous test plans for all development, data changes and data analysis
  • Proficiency with MS EXCEL functions and formulas
  • Broad experience across web / intranet development with solid understanding of relational database technologies
  • Experience with ETL best practices (lineage tracking, transformation, data validation, audit reporting, etc) along with ability to establish database standards
  • Working knowledge of PeopleSoft Financials and HRMS software, Infinite Campus student software and Tableau data analytics software
  • Knowledge of replication technologies for copying, distributing, and synchronizing data and objects between databases
  • Knowledge of SQL Server Clusters and failover options
  • Knowledge of web programming support for Microsoft.NET
  • Knowledge of Microsoft: Windows Operating Systems, Team Foundation Server (TFS), Office Suite versions, Visio, Project, etc.
  • Ability to translate user needs into business requirements 
  • Ability to design, install, configure, and implement technical solutions based on business requirements
  • Ability to study, document and prepare system diagrams regarding present day ETL processes for student and analytical data
  • Ability to analyze existing ETL processes and redefine them to take into account changes in business or system requirements 
  • Skills pertinent to positive human relationships and the ability to work effectively with staff members in a multicultural urban setting
  • Ability to conduct analysis (plan, organize, problem-solve, and think abstractly/ conceptually) in an educational environment
  • Demonstrated ability to organize information and provide direction regarding District-wide management efforts involving data analytics, data marts, and data warehouses
  • Ability to work independently or with a team to research and solve critical issues
  • Strong communication skills enabling the ability to convey accurate and timely information – verbally and written
  • Willingness to comply with District, local, state, and federal laws and standards
  • Ability to write clear, concise technical documentation (architectural/design diagrams, specifications, and assorted plans
  • Ability to understand technical manuals and procedural documentation as well as keep documentation up to date 
  • Ability to work through difficult issues and maintain a positive attitude when communicating with others 
  • Ability to work hours outside of normal schedule with little or no advance notification