Senior Database Engineer - VERTICA Empirix
THIS JOB HAS EXPIRED The Senior Database Engineer will work within the Analytics and Prediction team to architect and manage data warehouse and operational data stores in support of Business Intelligence and Analytics. Primarily working with Vertica, but experience with other databases and NoSQL/NewSQL Databases is also preferred as the individual will be dealing with Big Data challenges around the volume, variety, velocity and complexity with data and analytics. The individual will work closely in a team consisting of Solutions Architects, BI Architects, Software Engineers, System Analysts, Quality Assurance Engineers and Database Administrators in developing data warehouse and operation data store solutions to support Business Intelligence activities with MicroStrategy, and help move forward our Analytics initiatives towards scalable, highly responsive, highly available, flexible and robust production grade solutions. A love of data, finding value in data, and architecting data solutions to provide and allow our end users to explore and discover insights with data in revealing data visualizations are part of the passion and adventure you will find here!
Design and implementation of data warehouse/operational data store strategy ensuring rapid delivery while taking responsibility for applying standards, principles, theories, and concepts.
Responsible for design and delivery of data models which power BI initiatives, dashboards, reporting, and ad-hoc data exploratory canvases for Empirix solutions.
Design logical data models and physical database designs optimized for performance, availability and reliability.
Tuning and optimization of backend and frontend data operations.
Design and develop ETL and master data management tools and processes.
Scripting and automation to support development, QA and production database environments and deployments at client sites.
Define and help enforce data governance and security policy.
Proactively helps to resolve difficult technical issues.
Provide technical knowledge to development teams during project planning phases.
Keep management informed of work activities and schedules.
Assess new initiatives to determine the work effort and estimate the necessary time-to-completion.
Document new development, procedures or test plans as needed.
Participate in data builds and deployment efforts.
Participate in projects through various phases.
Performs other related duties as assigned.
Must be passionate, flexible and innovative in utilizing the tools, their experience, and any other resources, to effectively deliver to very challenging and always changing business requirements with continuous success.
Must be able to interface with various solution areas to understand the requirements and prepare documentation to support development.
Must understand relational and dimensional modeling, star/snowflake schema design.
Must have a clear understanding of BI, Data Warehouse operating environments and related technologies.
Must understand ETL, MDM and data governance practices.
Minimum 1-3 years? experience in Vertica.
Familiarity with Java/ JEE.
Experience in Linux (SUSE or related distribution).
Exposure to MicroStrategy a plus.
Exposure to NoSQL/NewSQL and other database systems a plus.
Ability to coach and mentor others on the design, development, and usage of Vertica.
Strong native SQL skills.
Strong experience in database and data warehousing concepts and techniques.
Strong experience with low latency (near real time) systems and working with Tb data sets, loading and processing billions of records per day.
Ability to work in a fast-paced, team oriented environment.
Ability to complete the full lifecycle of software development and deliver on time.
Ability to work w/end users to gather requirements and convert that to working documents.
Strong interpersonal skills w/a heads-up solution oriented attitude.
Telecoms experience a plus.
Three to five years of experience in a related position demonstrating the position responsibilities outlined above.
Bachelor's Degree from four-year College or university; or eight years related experience and/or training; or equivalent combination of education and experience.
||20 Crosby Drive |
Bedford, MA 01730
THIS JOB HAS EXPIRED