PowayRecruiter Since 2001
the smart solution for Poway jobs

IT Senior Database Developer

Company: Corovan
Location: Poway
Posted on: August 2, 2022

Job Description:

At Corovan, we continue to grow on the momentum of a great reputation. Corovan has a proven track record for excellence and continually exceeding industry standards. Corovan is a privately held company with a management team that genuinely cares about their employees. Our values include growth, customer service, continual improvement, and employee development. As a company, we work with interesting work environments with some of the most dynamic companies in the world.The Senior Database/BI Developer position is responsible for helping transition Corovan to 3rd party ERP data models and maintaining business-critical data processing and business intelligence operations on an ongoing basis. The Senior Database Developer will work as a developer while also providing technical leadership in master data management and BI development.Information Technology (IT) is responsible for the full lifecycle of infrastructure and technology solutions supporting Corovan. IT is required to support end-user functions, desktop and laptop platforms, voice, mobility as well as custom software solutions, server and network infrastructure. The IT department's commitment is to maintain a robust, highly available and cost-effective platform that allows the business to be agile in response to market opportunities.ESSENTIAL DUTIES AND RESPONSIBILITIES:Business Intelligence Development:---Provide technical expertise using BI tools to help define, architect and build BI processes benefiting the entire organization.---Create informative, actionable and accurate reporting that highlights relevant business trends and opportunities for improvement.---Design and implement ongoing ETL processes supporting BI needs.---Promote improved data visibility with business intelligence solutions, and act as a thought leader in maturing Corovan's approach to BI. Strategic Planning and Analysis:---Help plan and implement the cleaning and migration of critical data between data models using ETL best practices.---Gather and document requirements for extensions to ERP data models based on business needs.---Act as a primary owner of the master data management architecture for the organization. ---Study system capabilities, construct data model visualizations, and write specifications.---Collaborate with the IT Director and application business owners to support existing applications and to design and implement new solutions to meet changing business needs.---Determine operational objectives by studying business functions; gathering information; evaluating output requirements and formats.---Participate in designing database backup and data-refresh procedures for on premise systems. Database Development:---Design and develop Microsoft SQL stored procedures, T-SQL, views, ETL solutions, as well as reports via SSRS and SSIS.---Maintain legacy data access code in stored procedures and other database objects as well as .Net web applications.---Maintain and document existing custom and third-party integrated solutions.---Collaborate and recommend design modifications and improvements with other software developers throughout the development process.---Gather and document business requirements and project scope, user stories, detail functional specifications and effectively communicate project deliverables.---Investigate gaps and inconsistencies in application and report data to determine root causes and propose remediation options.---Design, implement and document stopgap procedures needed for routine data cleaning or to maintain data integrity.---Review and approve other developers' scripts for making changes to database objects.---Assist with the improvement of our Agile SDLC, Scrum, and other processes.---Create and execute test plans and test cases to support the quality assurance process.---Maintain an understanding of the latest application and programming practices through education, study, and participation in conferences, workshops, and groups.---Confer with team to resolve conflicts, prioritize needs, develop content criteria, choose solutions, and share knowledge.Customer Relations:---Ability to have strong effective partnerships with senior leaders and functional leads to understand their business requirements and translate into project plans and create successful outcome.---Able to have discussions with senior leaders about project timelines, project priorities, trade-offs relating to project schedules and lead discussions to effective resolution of these important items.---Participate in meetings to coordinate service requirements, installations, and project milestones as required to achieve client expectations.---Respond to incoming help desk tickets, emails and phone calls. Ensure help desk tickets are created for all user support requests. Resolve help desk tickets. Log time worked for all help desk tickets and IT projects.---Participate in weekly on-call rotation for after-hours emergencies.---Ability to work effectively in a team environment as a positive team player.---Perform work with quality, efficiency and safety at all times.Training:---Promote Corovan's Mission and Vision Statements.---Continuously promotes compliance with company policies and procedures.QUALIFICATIONS:To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.COMPETENCIES:1. COMMUNICATION AND LEADERSHIP - Strong interpersonal and communication skills that allow this employee to effectively communicate with team members business partners. This person should be able to lead discussions to understand project direction, customer requirements, discuss trade-offs and solution approaches, and have discussions agreeing the priority of the projects in the portfolio. This person should also be able to communicate with external vendors and manage vendor relationships. Solid ability in both written and verbal communication. Effectively communicate with potentially stressful and/or emotional situations. Outstanding customer oriented skills.2. PROBLEM SOLVING AND DECISION MAKING SKILLS - Strong troubleshooting/problem solving/resolution skills and demonstrated resourcefulness. Organization skills, attention to details, and the ability to prioritize in a changing environment. Ability to be impartial and objective.3. CUSTOMER SERVICE - Manages difficult or emotional customer situations well; responds promptly to customer needs; solicits customer feedback to improve service; responds to requests for service and assistance; meets commitments.4. TEAMWORK - Dedicated team player. Strong collaboration skills, ability to work effectively in a team environment as a positive team player and provide superior customer support.5. ORGANIZATION SKILLS - Organization skills, attention to details, and the ability to prioritize in a changing environment.6. LANGUAGE SKILLS - Ability to read and interpret documents written in English such as procedures, work instructions, and timesheets. Ability to effectively communicate with customers and coworkers.7. MATHEMATICAL SKILLS - Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals.8. 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.9. OTHER DUTIES:a. Excellent customer service skills. Able to build good relationships with and relate well to end users.b. Extensive experience performing root cause analysis.c. Basic understanding of project management principles.d. Ability to thrive in a fast-paced environment.e. Able to solve complex problems.f. Ability to maintain confidentiality of sensitive information.g. Able to develop ideas and processes and clearly express them.h. Ability to work under pressure of deadlines of short term objectives while not losing sight of long term goals.i. Project and team management/leadership skills and experience. Proven ability to work effectively in a team environment with associates. Capability of effective planning and priority setting. Ability to manage several complex projects simultaneously while working under pressure to meet deadlines.EDUCATION and/or EXPERIENCE:---BA/BS degree or equivalent training in IT, computer science, data analysis or other related fields.---Minimum of 5 years of proven experience as a database developer, creating reports, and using BI tools such as Birst, Power BI, or Tableau for data analysis and reporting.---Expert level knowledge of TSQL and SQL Server tools for table design, writing and optimizing high performing queries, views, functions and stored procedures.---Significant expertise as a Microsoft SQL Server database developer.---Significant experience with master data management (MDM) principles and techniques---Significant experience with data cleaning and ETL solutions, SSMS, and SSRS.---Significant experience troubleshooting and improving database performance issues---Some experience integrating with third party applications at the database and web service layers.---Some experience in a senior or leadership role.---Some experience developing web applications and services with Microsoft Visual Studio---Familiarity with developing and implementing requirements for software financial systems (billing and accounting).---Proficiency with fundamental data representation concepts such as XML, JSON, Document Object Model (DOM), and RESTful services.---In-depth experience with cloud solutions from Azure and/or AWS.---Familiarity with low-code platforms such as OutSystems or Mongoose.---Familiarity with Cold Fusion, Entity framework, ADO.Net, Git, and KendoUI.---Familiarity with applications such as Jira, Confluence, ERP systems such as Great Plains.PRIMARY LOCATION:The primary location is Poway.TRAVEL:10% travel to various other offices may be required. A valid driver's license is required for this position.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. Individuals are required to be able to sit or stand for long periods as needed throughout the day.1. Walking: May require walking primarily on a level surface, but may include walking on uneven or inclined surfaces for lengthy periods throughout the day, often up and down stairs.2. Handling: Seizes, helps or works with hands.3. Lifting: Proper lifting techniques required. May include lifting up to 50 pounds, and pushing or pulling up to 50 pounds throughout the day.4. Reaching: Extends hands and arms in any direction, reaching above shoulder heights, below the waist or lifting as required.5. Standing: Remains in standing position if required to perform various functions of the job.6. Stooping: Bends body downward and forward by bending at knees or waist, including but not limited to, twisting, kneeling throughout the day.7. Vision: Reads paperwork and records on the computer.8. Talking: Communications by phone and in person.9. Sitting: Sits at desk.WORK ENVIRONMENT:The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. This list is not all inclusive.1. Temp/Weather: Works in either 1) Office environment - for the most part ambient room temperatures, lighting and traditional office equipment, and 2) Warehouse - may be exposed to cold temperature, and 3) Outside - may be exposed to wet and/or humid conditions, outside weather conditions and extreme cold.2. Noise: Works in office, warehouse or outside environment, with constant or intermittent noise.POSITION TYPE/EXPECTED HOURS OF WORK:1. This is a full-time exempt position. This is a mission-critical position and focus will be required2. Employees might be required to work late evenings or weekends depending on the business needs.AAP/EEO STATEMENT:The Company provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type, without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.OTHER DUTIES:Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.REASONABLE ACCOMMODATIONS:Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.Equal Opportunity Employer/Protected Veterans/Individuals with DisabilitiesThe contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Keywords: Corovan, Poway , IT Senior Database Developer, IT / Software / Systems , Poway, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Poway RSS job feeds