Entry Level Database Analyst

at  Taylor Corporation

Let Us Power Your Potential
Taylor Corporation is a dynamic, diversified company with big plans for the future ― and your career. We power our employees’ potential and strive to create opportunity and security for every member of the team. If you’re ready for something bigger ― more challenge, more variety, more pathways for professional growth ― we should talk. We’re passionate about our work, we believe there is always a better way, and we’re looking for people like you.
Ready to reach your potential? It’s time to look at Taylor.
Your Opportunity: Taylor Print & Visual Impressions (formerly Curtis 1000 Inc.) is seeking an entry level Database Analyst to assist in business systems design, analysis and programming services to modify existing programs, write new programs or processes that import, export, transform and/or visualize data. The Database Analyst will work with account managers, sales staff, and technology staff to successfully execute customer solutions.

Your Responsibilities:

• Develops, reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Imports data from a variety of sources and media and converts received data into usable formats that can be used with variable print software to produce customize print pieces.
• Writes codes for database access, modifications, and constructions including stored procedures.
• Creates new or transformed data and identifies data relationships through various processes and algorithms.
• Creates and maintain business logic for multiple data sets including direct mail address processing and standardization: merge / purge, ACE and grouping multiple addresses into a single household and so forth.
• Works with DBAs to design, correct and/or modify database schemas including creating tables and defining proper indexes and primary keys based on their entities, relations (normalization), expected volume and distribution of data.
• Collects specifications from project managers, sales staff, business analysts and account executives that support the overall customer program.
• Develops production schedules for use by production personnel.
• Develops applications that provide information to Pii’s internal departments.
• Develops queries, retrieves, manipulates and displays data from relational databases for the purpose of ad hoc reporting as requested by clients, account executives and other associated staff.
• Follow test scripts to test programs and processes to ensure they work properly and meet client requirements. Correct any problems encountered during testing.
• Provide technical documentation of applications including flow charts, specifications and end user documentation.
• Attention to details and ability to query and validate quality for large amount of complex data.

You Must Have:

• COMMUNICATION: Ability to effectively communicate orally and in written communication form information to internal/external vendors/clients, staff and management.
• TECHNICAL: Translate technology requirements from internal personnel to external customer and vice versa. Become familiar with basic creative design and layout as it relates to project and processes. Learn internal software applications as required by account. Learn, comprehend and utilize web and data development concepts to coordinate the development of technical solutions.
• DECISION MAKING: Ability to collect the necessary information and listen to others to make decisions regarding project(s) and processes.
• CUSTOMER SERVICE: Work with a variety of personalities and skill sets across Units and / or departments.
• MATHEMATICAL SKILLS: Ability to perform basic mathematical operations to include addition, subtraction, multiplication and division.
• PRIORITIZATION: Handle frequent interruptions yet refocus on the task at hand or determine the most important tasks. Adapt to a fast paced, high stress and changing environment.
• PROBLEM SOLVING: Take responsibility to find alternative approaches to solve or troubleshoot issues; Exhaust available resources to find solutions.
• ORGANIZATION: Ensure information can be found easily and tasks are completed on time. Pay attention to details. Maintain accuracy and quality.

We Would Also Prefer:

• Experience in MS SQL Server or similar DBMS
• Experience in .net/C# or similar programming language

About Taylor Corporation
One of the largest graphics communications firms in North America, Taylor’s family of companies provide a diverse set of products, services, and technologies addressing the toughest communication challenges. For nearly 50 years, Taylor has been a premier provider of powerful and innovative products, services, and expertise for individuals, businesses, and distributors large and small. Our 10,000+ employees spanning 26 states and seven countries work diligently to create the interactive, printing, and marketing solutions that have helped build some of the world’s more recognizable brands. Everything we do begins with identifying the unique priorities and needs of our customers and creating one-of-a-kind solutions. We offer a comprehensive benefit package including several health plans to choose from, dental, vision, wellness programs, life and disability coverage, flexible spending accounts, health savings accounts, 401(k) plan with company match, paid time off (PTO) and 64 hours of annual holiday pay.
The Employer retains the right to change or assign other duties to this position.
Taylor Corporation is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
Taylor Corporation including all partners and affiliates is an Equal Opportunity Employer/Veterans/Disabled

• Develops, reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Imports data from a variety of sources and media and converts received data into usable formats that can be used with variable print software to produce customize print pieces.
• Writes codes for database access, modifications, and constructions including stored procedures.
• Creates new or transformed data and identifies data relationships through various processes and algorithms.
• Creates and maintain business logic for multiple data sets including direct mail address processing and standardization: merge / purge, ACE and grouping multiple addresses into a single household and so forth.
• Works with DBAs to design, correct and/or modify database schemas including creating tables and defining proper indexes and primary keys based on their entities, relations (normalization), expected volume and distribution of data.
• Collects specifications from project managers, sales staff, business analysts and account executives that support the overall customer program.
• Develops production schedules for use by production personnel.
• Develops applications that provide information to Pii’s internal departments.
• Develops queries, retrieves, manipulates and displays data from relational databases for the purpose of ad hoc reporting as requested by clients, account executives and other associated staff.
• Follow test scripts to test programs and processes to ensure they work properly and meet client requirements. Correct any problems encountered during testing.
• Provide technical documentation of applications including flow charts, specifications and end user documentation.
• Attention to details and ability to query and validate quality for large amount of complex data