Principal Database Engineer

Jobtailor

Massachusetts

On-site

USD 140,000 - 190,000

Full time

4 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Jobtailor in Massachusetts seeks a senior data architect to lead the design and delivery of database, BI, data warehouse, and data integration solutions. You will work with business users to extract complex requirements and propose optimal data-driven solutions.

You will establish development standards, mentor teams, and provide architectural guidance across multiple data platforms, leveraging Kimball/Dimensional modeling and modern ETL tools.

Qualifications

Bachelor’s degree in Computer Science, Electrical and Electronic Engineering, or related field; 10 years in related roles.
Master’s degree accepted as alternative with 8 years of experience.
6+ years of experience with relational databases, ETL, data warehouse and BI.

Responsibilities

Lead design, development, and delivery of database, BI, data warehouse and data integration solutions.
Provide cross-functional leadership and expert technical guidance during design, development and delivery.
Engage with business users to extract complex requirements and propose right solutions.
Champion development standards and best practices across BI and data warehouse.
Lead technical teams with architectural direction and data modeling responsibilities.

Skills

Database design

ETL development

Business intelligence

SQL programming

Data warehouse methodologies

Education

Bachelor’s degree in CS/Engineering

Master’s degree in relevant fields

Tools

Visual Studio

Team Foundation Server

SVN

SQL Developer

SQL Server Management Studio

Oracle Data Integrator

ODI Studio

OAS Enterprise Manager

Power BI

Job description

Lead all aspects of the design, development, and delivery of database, business intelligence, data warehouse, and data integration solutions
Partner cross-functionally to provide expert technical knowledge and leadership guidance during design, development, and delivery
Engage with business users to extract complex requirements and priorities and propose the right business solution
Champion and create Company development standards or industry best practices across business intelligence and data warehouse solutions
Assist the organization with understanding, testing, and incubating the newest technology advances and best practices to support future business drivers
Lead technical teams in designing and developing data solutions through expert technical and architectural guidance
Design logical and physical data models, ETL jobs, and repository metadata for functional departments using telecommunications or real estate industry data
Create and maintain all database models
Audit and review performance metrics for new and existing data integration solutions and database queries to ensure adherence to service level agreements and system health

Requirements

Bachelor’s degree (or foreign equivalent) in Computer Science, Electrical and Electronic Engineering, or a related field, plus 10 years of experience in the job offered or Technical Lead/Consultant/Principal/Senior Consultant
Master’s degree in the stated fields plus 8 years of experience in the job offered or Technical Lead/Consultant/Principal/Senior Consultant accepted as an alternative
6 years of experience using relational databases, ETL, data warehouse, and business intelligence
6 years of experience using Visual Studio, Team Foundation Server, or SVN
6 years of experience with SQL and PL/SQL programming language
6 years of experience with Kimball methodology, star or snowflake schemas, and semantic layer design
6 years of experience with SQL Developer, SQL Server Management Studio, and SQL Server Database
6 years of experience with Oracle 10g databases, Oracle GoldenGate, and Oracle Data Integrator Platform
6 years of experience designing and developing data integration solutions using ODI Studio
6 years of experience with Topology and ODI models
6 years of experience with Master and Work Repositories
6 years of experience with Business Intelligence Platform
6 years of experience with OAS Enterprise Manager
6 years of experience with OAS Repository Development or Enterprise BI Tool Metadata development
6 years of experience with OAS Data visualization
6 years of experience with Essbase Cubes development
6 years of experience with OAS Admin
6 years of experience with Power BI

Core Competencies

Demonstrates expertise in designing and developing data solutions, including database models, ETL processes, and business intelligence platforms. Proficient in utilizing industry best practices and methodologies such as Kimball for data warehousing and integration.

Highest-signal resume keywords