Data Warehouse Engineer

Title: Programmer Analyst

Loction: Remote

Duration: 05 months

Job description:

The successful candidate will be a part of the team that is responsible for Enterprise Data Warehouse. This position requires the candidate understands and applies technical standards principles theories concepts techniques and provides solutions to a variety of technical problems of moderate to high scope and complexity. The candidate develops deep knowledge and understanding of the data warehouse and data management assets available within our data platforms and act as the subject matter expert on the data and its utility for operational use. The candidate will regularly interact with the customers data management teammates and product development partners your expertise in large volume data in data lakes data warehouses or data marts using structured semistructured and unstructured formats will deliver on the BAEs Data and Analytics organizations mission to enable datadriven decisions within any action. The candidate will follow established procedures and contribute to the completion of milestones associated with specific projects and keep up to date with the technology shifts through training and development.

Skills Required:

Bachelors Degree in Computer Science Information Systems or similar

10 to 15 years of Data Warehousing and Data Modeling experience.

Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.

Strong experience working with ETL/ELT concepts of data integration consolidation enrichment and aggregation in large volume data sets.

Expert in SQL and/or SQLbased languages and performance tuning of SQL queries.

Working knowledge of Data Pipelines stream processing and highly scalable big data data stores.

Experience with various data storage technologies e.g. RDBMS (Oracle SQL Server etc.) columnar tabular document store NoSQL

Experience with various ETL/ ETL tools e.g. ODI SSIS Informatica Power Center Talend IICS etc.

Experience with cloudbased data warehouses e.g. Snowflake Big Query Azure Synapse RedShift etc.

Create supporting documentation such as metadata and diagrams of entity relationships business processes and process flow.

Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.

Data validation skills to verify data integrity understand discrepancies and resolve them with the highest sense of urgency.

Demonstrated ability to share findings with nontechnical or business stakeholders.

Familiarity with Analytical/Reporting Solutions like Tableau Power BI is a plus

Virtual team collaboration tools such as WebEx Zoom etc.

Excellent written verbal communication and Interpersonal skills

Excellent problemsolving skills

Experience Required:

Bachelors Degree in Computer Science Information Systems or similar

7 years of experience

Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques.

Strong experience working with ETL/ELT concepts of data integration consolidation enrichment and aggregation in large volume data sets.

Expert in SQL and/or SQLbased languages and performance tuning of SQL queries.

Working knowledge of Data Pipelines stream processing and highly scalable big data data stores.

Experience with various data storage technologies e.g. RDBMS (Oracle SQL Server etc.) columnar tabular document store NoSQL

Experience with various ETL/ ETL tools e.g. ODI SSIS Informatica Power Center Talend IICS etc.

Experience with cloudbased data warehouses e.g. Snowflake Big Query Azure Synapse RedShift etc.

Create supporting documentation such as metadata and diagrams of entity relationships business processes and process flow.

Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.

Data validation skills to verify data integrity understand discrepancies and resolve them with the highest sense of urgency.

Demonstrated ability to share findings with nontechnical or business stakeholders.

Familiarity with Analytical/Reporting Solutions like Tableau Power BI is a plus

Virtual team collaboration tools such as Webex Zoom etc.

Excellent written verbal communication and Interpersonal skills

Excellent problemsolving skills

Education Required:

Bachelors Degree in Computer Science Information Systems or similar





#Openroles #Urgenthiring #Hiring #USCitizen #Datawarehouse #Datamodel #Datamodelling #SQL #informatica #ETL #Oracle #Cloud #Azure #Tableau #PowerBI