The Database Analyst’s role is to gain an intimate understanding of the company’s data and related applications across the enterprise to support enterprise data warehouse, master data management, business intelligence, and in-house development efforts. These actions will be completed in conjunction with data and solutions architects as part of local, regional, and global teams. This position reports to the Manager of Data Systems.
Design and develop complex SQL queries, data table structures and appropriate database code such as stored procedures, triggers & functions to support business processes
Review and update queries and stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code
Recommend changes to the relational data model to address data issues with data warehouse, master data, and data mart environments
Actively participate in the resolution of production data issues
Perform data reviews, providing feedback in a timely manner
Participate in the review of database structures and identify impacts to existing environment
Maintain data quality through business process/policy and data governance standards
Adherence to change control and testing processes for modifications to data systems
Documentation of new processes, procedures, and diagrams
Ability to evaluate large data sets for data quality issues and assist in resolution
Work closely with applications, data, and BI teams to develop end to end solutions
Proficient with writing SQL Server queries
Familiarity with Data Warehousing, Master Data Management, and Business Intelligence disciplines
Strong troubleshooting and problem-solving skills
Technical writing skills preferred
Familiar with data-intensive business applications (i.e. ERP, CRM, CPM, HRIS)
Familiar with request, incident, and change management protocols preferred (i.e. ITIL)
Exceptional analytical, conceptual, and problem-solving abilities
Strong desire to learn from and contribute to a larger team
Strong technical documentation skills
Proven analytical and problem-solving abilities and keen attention to detail
Strong customer service orientation
Ability to conduct research into database issues, standards, and products
Ability to present ideas in user-friendly language
Able to prioritize and execute tasks in a dynamic business environment
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
OpenArc is a technology consulting firm providing industry-leading technical talent placement, software development, and technology strategy services to clients nationwide. Through a unique blending of people and software, OpenArc has a business practice that delivers amazing enterprise, mobile and consumer-facing apps and the best talent for contract, contract-to-hire and direct placements for clients and partners alike.
Staffed with the most-trusted recruiting experts, elite software developers, UI/UX designers and market experts, our team provides clients with the best resources, the right techniques and world-class support resulting in powerful measurable success.