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.
Ability to lead the development of Enterprise Data Systems and Enterprise Data Models
Design and develop complex SQL queries, data table structures and appropriate database code such as stored procedures and functions to support business processes
Review and update database code 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 schema and identify impacts to existing environment
Maintain data quality through business process/policy and data governance standards
Adhere to change control and testing processes for modifications to data systems
Documentation of new processes, procedures, code 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
Bachelor’s degree in Information Technology or related field
Proficient with writing SQL Server queries
Familiarity with Data Warehousing, Master Data Management, and Business Intelligence disciplines
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
Ability to conduct research into database issues, standards, and products
Ability to present ideas in user-friendly language
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.