Must have a computer-related degree

Summary:

The entry to middle level SQL Developer will serve as a data steward towards development driver data systems and applications, with focus on accuracy, integrity, completeness, accessibility, validity and data security compliance. This role will learn and work towards deploying, designing, and implementing solutions using a diverse set of technologies in distribution and manufacturing environments. The SQL Developer will keep apprised of current technologies related to Analytics, Data Quality as well as report deployment solutions and assist leadership towards related goals while simultaneously having the ability to translate technical concepts to non-technical employees.

Essential Duties and Responsibilities:

• This position will work with teams in the design and implementation of the Data Flow Architecture from which future application data backend development will be patterned after.
• Provides technical assistance to data capture, integration and other development projects as may be assigned by IT Management.
• The position will assist in responsibilities related to resolving production issues, implementing enhancements, customizations, and major upgrades.
• Supports data strategy roadmaps, utilization of Master Data Management tools, Data Governance standards, and a data quality framework to ensure optimal utilization of data assets.
• Reports to the Data Operations & Development Manager, the position actively participates and works with Infrastructure and Application support teams as well as the various departments, customers and vendors.
• Provides support to ensure compliance with data standards and foster adherence to data privacy and availability requirements, benchmarked against industry best practices.
• Participates in Data Governance functions for cross-team data sharing, organizational performance management, data-collection best practices and dashboard creation.
• Write and optimize in-application SQL statements.
• Create and maintain stored procedures and triggers.
• Prepare documentation and specifications as required.
• Maintains a high level of commitment to improve data quality in support of strategic data needs and analytics.
• Maintains a business rule repository, metadata and a data dictionary.
• Create and/or maintain SQL reports within SSRS.
• Adheres to policies on data purges and retention cycles.
• Perform and execute data extraction, transformation and loading using ETL Tools.
• Assist in maintaining and managing all versions of data models for production, testing and developing databases.
• Assists in day to day operations to support centralized data processes.
• Adhere to all company policies, procedures and safety rules as stated in the Employee Handbook and otherwise posted or communicated.
• Exemplify the BakeMark core values of Partnership, Performance, Passion, and Initiative in all aspects of assigned duties.

COMPETENCY:

To perform the job successfully, an individual should demonstrate the following competencies:

Passion:

• Technical Skills – Strives to continuously build knowledge and skills; Shares expertise with others.
• Teamwork - Contributes to the building of a positive team spirit; Puts success of team above own interests.
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.
• Organizational Support - Supports organization's goals and values.
• Professionalism - Approaches others in a tactful manner.

Performance:

• Analytical - Collects and researches data; Uses intuition and experience to complement data.
• Problem Solving - Identifies and resolves problems in a timely manner.
• Technical Skills - Strives to continuously build knowledge and skills; Shares expertise with others.
• Organizational Support - Follows policies and procedures; Completes administrative tasks correctly and on time; Supports organization's goals and values.
• Planning/Organizing - Prioritizes and plans work activities; Uses time efficiently.
• Interpersonal Skills - Keeps emotions under control.
• Professionalism - Approaches others in a tactful manner.

Partnership:

• Interpersonal Skills - Maintains confidentiality; Listens to others without interrupting;

Keeps emotions under control; Remains open to others' ideas and tries new things.

• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Participates in meetings.
• Written Communication - Writes clearly and informatively; Able to read and interpret written information.
• Teamwork - Contributes to the building of a positive team spirit; Puts success of team above own interests.
• Technical Skills - Strives to continuously build knowledge and skills; Shares expertise with others.
• Professionalism - Approaches others in a tactful manner.

Initiative:

• Judgement - Evaluates, selects and acts on strategies for solving problems and meeting objectives. Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
• Influence - Begins actions to influence events and/or to achieve company goals. Sees opportunities for action and acts on them.
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; Listens and gets clarification; Responds well to questions; Participates in meetings.
• Written Communication - Writes clearly and informatively; Able to read and interpret written information.
• Teamwork - Contributes to the building of a positive team spirit; Puts success of team above own interests.
• Ethics - Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.

Qualifications:

• Bachelor's degree in Computer Science or related Information Technology area.
• 1-2 years of experience, working with SQL Server and relational database systems.
• Basic knowledge in integrated database systems, data integrity, and data lifecycle.
• Capable of troubleshooting common database issues.
• Excellent organizational skills.
• Excellent oral and written communication skills.
• One or More Databases (SQL and NoSQL)
• Familiar with Master Data Management Tools and scripting languages (e.g. Powershell, Python, Javascript, TSQL)
• Microsoft Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• Experience with Microsoft Visual Studio is a plus*

*Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future

Language Skills:

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Reasoning Ability:

Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.

Physical Demands:

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 the duties of this job, the employee must be able to stand, walk, reach with hands and arms, and talk or hear continuously for 8 or more hours at a time. The employee must be able to use hand to finger, handle, or feel; climb or balance, stoop, kneel, crouch, or crawl, taste or smell for 8 hours or more at a time.

Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception, and ability to adjust and focus.

Work Environment:

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.

While performing the duties of this Job, the employee may be exposed to moving mechanical parts. The employee may be exposed to risk of electrical shock and risk of radiation. The noise level in the work environment is usually moderate. Duties will be performed both indoors in a office-type environment and in a manufacturing and/or warehouse environment.

Job Type: Full-time

Benefits:

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Vision insurance

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Pico Rivera, CA 90660: Reliably commute or planning to relocate before starting work (Required)

Experience:

• Informatica: 1 year (Preferred)
• SQL: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)

Work Location: Hybrid remote in Pico Rivera, CA 90660

Please Note :
dgeus.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, dgeus.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.