Data Analyst Lead
Share
Job Location:
Lincoln, NE - USA
Monthly Salary:
Not Disclosed
Posted on:
2 days ago
Vacancies:
1 Vacancy
Job Summary
The work we do matters!
Hiring Agency:
Transportation - Agency 27
Location:
Hiring Rate:
Job Posting:
Applications No Longer Accepted On (If no date is displayed job is posted as open until closed):
Job Description:
In this role you will serve as a lead technical resource for SQL Server database administration and system integration projects working on initiatives that connect internal applications with vendor-hosted and cloud-based solutions. You will play a key role in planning and implementing database upgrades designing data integration approaches and ensuring systems perform reliably as our technology environment continues to evolve.
You will work closely with the IT Supervisor and other senior staff to define integration strategies database standards and best practices helping guide the technical direction of new projects and system enhancements. This includes collaborating with software vendors evaluating new technologies and developing solutions that allow multiple systems to share data efficiently and securely.
This position also provides the opportunity to take a leadership role in technical projects mentor other IT staff and influence how enterprise data systems are designed and maintained. If you enjoy working at a senior technical level while still being hands-on with SQL database design and system architecture this role offers a strong balance of leadership and technical work.
Why this position is a great opportunity:
Work on enterprise-level SQL Server and database systems
Lead data integration and modernization projects
Collaborate with vendors and cloud-based platforms
Influence technical architecture and best practices
Take on a senior technical leadership role without moving into full management
Be part of long-term system modernization and upgrade initiatives
This position is a great fit for someone who wants to continue growing as a senior technical specialist while helping guide the future of enterprise data and application systems.
JOB DUTIES
- Lead work related to enterprise database administration data integration and business intelligence systems supporting agency applications and reporting needs.
- Coordinate and lead database and business intelligence projects including planning task assignments monitoring progress and ensuring completion of technical deliverables.
- Act as backup for primary database administration functions including SQL Server maintenance troubleshooting upgrades and support of production test and development environments.
- Plan coordinate and implement database upgrades patches and migrations ensuring proper testing documentation and minimal disruption to operations.
- Lead and support Business Intelligence and Business Intelligence tracking initiatives including development and maintenance of reporting databases dashboards and data integration processes.
- Perform and coordinate FME upgrades patching and configuration changes ensuring compatibility with existing systems and vendor applications.
- Perform and coordinate Windows Server updates patching and maintenance for servers supporting database integration and reporting environments.
- Monitor and manage assigned service requests and incident tickets ensuring timely resolution proper prioritization and communication with users and technical staff.
- Plan and implement data integration solutions between internal systems and vendor-hosted or cloud-based applications including defining data flows interfaces and validation processes.
- Work with software vendors and internal stakeholders to evaluate integration approaches system requirements and technical specifications.
- Assist the IT Supervisor I in establishing database standards integration practices and technical procedures to ensure consistency across systems.
- Monitor system performance and troubleshoot issues related to database availability data integrity and system interoperability.
- Participate in long-range planning for system upgrades database capacity and technology improvements affecting enterprise data systems.
- Provide technical guidance and mentoring to other IT staff on database business intelligence and integration tools and processes.
- Document system configurations upgrade procedures and integration processes in accordance with agency standards.
- Ensure systems comply with agency policies related to security data management backup and disaster recovery.
- Participate in project planning and coordination activities for enterprise IT initiatives and modernization efforts.
- Coordinate with OCIO and BTSD BI developers on the creation of NDOT SharePoint sites.
- Perform other duties as assigned.
Requirements/ Qualifications:
Minimum Qualifications:Associate Degree in Computer Science/IT and four years related experience or a bachelors degree or equivalent in computer science information systems mathematics engineering or other related field and three years of experience. Experience may include application programming software installation and software maintenance including systems programming online programming database design analysis and programming using IFS and/or SQL/DS and database administration. Any equivalent combination of education and experience will be considered.
Preferred Qualifications:
- Experience with SQL Server database administration including performance tuning backups upgrades and troubleshooting
- Experience with data integration ETL or business intelligence tools (such as FME SSIS Power BI or similar technologies)
- Experience supporting Windows Server environments including updates patching and system maintenance
- Experience working with enterprise applications and vendor-hosted systems
- Experience leading or coordinating technical projects database work or reporting/BI initiatives
- Experience writing advanced SQL queries stored procedures or database scripts
- Experience with system upgrades migrations or infrastructure changes
- Experience using service portals or ticketing systems to track requests and incidents
- Completion of an NDOT or State of Nebraska Leadership Development program
- Experience working independently while also coordinating work with technical staff supervisors and vendors
Other: This position requires in-office attendance; remote work is not permitted.
KNOWLEDGE / SKILLS / ABILITIES
Knowledge of:
- Principles and practices of database administration data management and data integration; relational database systems such as SQL Server including backup recovery performance tuning and security; business intelligence reporting and data tracking systems.
- ETL and data integration tools such as FME SSIS or similar technologies.
- Windows Server operating systems including patching updates and system maintenance; application database and server upgrade processes including testing and deployment procedures.
- System architecture concepts related to enterprise applications vendor-hosted systems and cloud-based solutions.
- Information technology project planning coordination and implementation practices.
- IT service portal processes including incident and service request tracking.
- Data security backup and disaster recovery principles.
- Technical documentation standards policies and procedures.
Skills in:
- Strong problem-solving communication and technical documentation skills.
- Leading and coordinating work related to databases business intelligence and data integration.
- Analyzing system performance and resolving database server and integration issues.
- Planning and implementing system upgrades patches and migrations; configuring and maintaining database reporting and integration environments.
- Working with vendors to resolve technical issues and implement system changes.
- Managing multiple assignments and priorities.
- Monitoring and responding to service requests incidents and system alerts.
- Preparing clear technical documentation.
- Communicating technical information to both technical and non-technical staff.
Ability to:
- Lead projects and coordinate work among IT staff and vendors.
- Serve as a senior resource for database and business intelligence systems.
- Act as backup for primary database administration functions; evaluate technical problems and develop effective solutions.
- Plan and carry out system upgrades and integration efforts.
- Work independently with limited supervision.
- Establish and maintain effective working relationships with staff supervisors and vendors.
- Learn and apply new technologies.
- Maintain accuracy and attention to detail while working on complex systems.
- Organize and prioritize work across multiple systems and projects.
- Communicate effectively both orally and in writing.
If youre currently employed by the State of Nebraska please dont apply through this external career site. Instead log in to Workday and open the Jobs Hub - Internal Apply app from your home landing page. You can access Workday anytime through the Link web page: offer a comprehensive package of pay benefits paid time off retirement and professional development opportunities to help you get the most out of your career and life. Your paycheck is just part of your total compensation.
Check out all that the State of Nebraska has to offer! Benefit eligibility may vary by position agency and employment status. For more information on benefits please visit: Opportunity Statement
The State of Nebraska values our teammates as well as a supportive environment that strives to promote diversity inclusion and belonging. We recruit hire train and promote in all job classifications and at all levels without regard to race color religion sex. age national origin disability marital status or genetics.
Required Experience:
IC
Key Skills
About Company
The Official Nebraska Government Website, Nebraska.gov is your link to all resources, news, statistics, & online services in the state of Nebraska. We enable citizens and businesses to interact with government, securely and efficiently.
