IT Development Analyst

JOB DESCRIPTION
This position is for a Data Systems Analyst with strong skills in SQL development. The person will also provide technical support and would be expected to have the skills and experience needed to provide 3rd tier support. This is a position for an individual with a natural drive for success in a demanding environment. Interested candidates should be professional, self-motivated, and interested in working in a fast-paced environment as part of a diverse team of fellow application and technology experts.
The position will support Infinity, Corporate View and related applications.
This is a hybrid role.

• Analyzes system requirements, preparing of specifications, designing, coding, testing, debugging and documenting.
• Implements complex requirement for multiple platforms, operating systems, and applications.
• Resolves problems by devising or modifying procedures.
• Considers equipment capacity and limitations, operating time, and form of desired results when developing resolutions.
• Supports the identification of system requirements by interviewing users, interviewing and selecting vendors (if applicable), analyzing applications, evaluating existing and proposed systems, and recommending solutions.
• Independently analyzes and isolates application issues and performs problem resolution.
• Monitors progress of software-based projects by tracking activity, resolving problems, publishing progress reports, and recommending actions.
• Improves systems performance by investigating problems, developing specifications, identifying trends in technology, and recommending solutions.
• Assists with formulating and defining specifications for software programming applications and modifies existing applications.
• Reads and follows the Underwriters Laboratories Code of Conduct and follow all physical and digital security practices.
• Performs other duties as directed.

RESPONSIBILITIES

• Develop and maintain database stored procedures, triggers and views.
• Analyze and define logical and physical database structure based on project requirements.
• Work directly with other IS team members and user community to define critical business requirements.
• Maintain and enforce standards, security procedures, and controls for access to ensure database system integrity.
• Define and participate in conceptual database design and specifications.
• Perform database administration activities including but not limited to installation, configuration, backup and maintenance.
• Perform database optimization, troubleshooting and tuning activities in a development/production environment.
• Ensure the reliability, serviceability, and maintainability of database systems with demonstrable accuracy and security.
• Develop test plans and test data for database systems.

#LI-BW1 #LI-Hybrid
QUALIFICATIONS
What makes you a great fit?

• Required: University degree in Computer Science or a related discipline, plus generally four years of directly-related experience.
• Required: Strong working technical knowledge and/or IT development experience.
• Required: Strong working knowledge in Enterprise application or specific program language requirements of IT work.
• Required: Detailed knowledge and understanding of SQL development and administration.
• Required: Proficiency in writing complex SQL queries/stored procedures.
• Highly preferred: 4-8 years experience in designing and implementing relational databases.
• Highly preferred: Strong analytical and communication skills.
• Highly preferred: Knowledge of software development life-cycle.
• Highly preferred: Ability to work independently with minimal guidance; and comfortable interacting with individuals of both technical and non-technical backgrounds.

What makes you stand out?

• Bachelor's degree in computer science, systems analysis, information systems management, software engineering, statistics, mathematics or related discipline; or professional certification and in-depth knowledge of database technology and DBA tools.
• Recent design and development experience with Microsoft SQL Server, MySql or related relational database technology (i.e. Oracle, DB2, PostGres SQL, MariaDB, Informix, Ingres).
• Experience with PowerShell/Batch files is a plus.
• Experience with QlikView, Tableau or Power BI software solutions is a plus.
• Experience with utilization of XML and JSON in SQL Server environments.
• Reporting experience including statistical analysis, data visualization, and experience in support systems desirable but not a requirement.

What you'll experience working at UL:
Mission: For UL, corporate and social responsibility isn't new. Making the world a safer, more secure and sustainable place has been our business model for the last 130 years and is deeply engrained in everything we do.
People: Ask any UL employee what they love most about working here, and you'll almost always hear, "the people." Going beyond what is possible is the standard at UL. We're able to deliver the best because we employ the best.
Interesting work: Every day is different for us here as we eagerly anticipate the next innovation that our customers create. We're inspired to take on the challenge that will transform how people live, work and play. And as a global company, in many roles, you will get international experience working with colleagues around the world.
Grow & Achieve: We learn, work and grow together with targeted development, reward and recognition programs as well as our very own UL University that offers extensive training programs for employees at all stages, including a technical training track for applicable roles.
ABOUT US
A global leader in applied safety science, UL Solutions (NYSE: ULS) transforms safety, security and sustainability challenges into opportunities for customers in more than 110 countries. UL Solutions delivers testing, inspection and certification services, together with software products and advisory offerings, that support our customers' product innovation and business growth. The UL Mark serves as a recognized symbol of trust in our customers' products and reflects an unwavering commitment to advancing our safety mission. We help our customers innovate, launch new products and services, navigate global markets and complex supply chains, and grow sustainably and responsibly into the future. Our science is your advantage.
ABOUT THE TEAM
UL Solutions' Retail and Consumer Products business helps retailers and consumer goods manufacturers meet increasingly complex challenges with its expertise in quality, chemistry and sustainability. Global well-known retailers have trusted UL Solutions to help it deal with major business risks and opportunities in the retail environment, including product quality and sustainability, materials and chemicals, global supply chain and omni-channel sales, so as to help enterprises bring products to the market faster and control changing regulatory requirements.