Job Description

• Good working knowledge of data warehouse, database and business intelligence environments, concepts and techniques

• Strong understanding of concepts and techniques for design, development and implementation of ETL and data quality

• Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions

• Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)

• Ability to perform problem analysis, structured analysis, design and programming techniques

• Use of Data Modeling, Database Query Optimization and Data Access techniques and concepts

• Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc.

• Code, maintain, test and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.)

• Strong performance tuning knowledge in SQL and ability to interpret plans, identify bottlenecks in queries and remediate them

• Work proactively to solve issues and problems

• Create use cases and assist in UAT testing efforts for the developed solutions

• Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)

Job Requirements

• 3+ years SQL Server database knowledge (SQL, PL/SQL, basic administration

• Experience in Oracle / PostgreSQL / MySQL / DB2 is advantage

• Solid understanding of SQL and SQL optimization techniques

• Experience with Data warehousing methodologies and development. These includes DW data modeling, Star Schema design, Hierarchy structures, Aggregation methodologies

• Experience in building production grade data architectures leveraging the latest on-prem technologies (or cloud)

• Working knowledge of data storage and processing formats for data integration and data warehousing solutions

• Worked in Agile environment and familiar with Waterfall & Agile development methods

• Good documentation skills, excellent written and verbal communication skills

Company Benefits

Additional Info