View Our Website View All Jobs

Lead Engineer, Database Developer

 

Responsibilities

As an engineer, the incumbent would be responsible for evaluating, developing, maintaining and testing database solutions for various analytics projects

Be responsible for building data warehouses, data marts & OLAP solutions preferably using SSAS

Organize and manage data architecture documentation

Define standards for data management, and train staff on principles of data architecture

Improve the maturity of data architecture and data governance across the enterprise

Plan data management scenarios to support the needs of the development, QA and production environments.

Create best practices for data loading and extraction (ETL framework).

Develop data architecture, data modeling, and ETL mapping solutions and data warehouse consistency.

Would have a strong focus on collecting, parsing, managing, analyzing and visualizing large sets of data to turn information into insights using multiple platforms

 

Qualification & Experience

Strong competency in data modeling and data design. This includes logical and physical modeling, partitioning strategies for large tables, and other database optimizations

Solid experience with Relational Databases, specifically SQL Server and Sybase, Data Warehousing, OLAP, and Business Intelligence Reporting. Must be able to write PL/SQL Stored Procedures

Solid understanding of pros and cons for different data warehouse methodologies and architectures (Kimball/Inmon/Data Lake/Hybrid)

Experience designing Star, Snowflake Schemas, Dimensional Data Modeling, SCD (Slowly Changing Dimensions), and CDC (Change Data Capture) preferably using SSIS

Exposure to emerging data technologies such as NoSQL; must understand them sufficiently to guide the organization in understanding and adopting them

Experience working with cloud platforms such as Amazon Web Services or Google Cloud Platform

Good communication skills

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file