Sr. Datawarehouse Developer - REMOTE - Amtec Human Capital Inc

Sr. Data Warehouse Programmer Analyst

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, semi-structured, and unstructured formats - will deliver on the client's Data and Analytics organization’s mission to enable data-driven 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:

• Bachelor’s 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 SQL-based 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 cloud-based data warehouses - e.g. Snowflake, BigQuery, 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 non-technical 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 problem solving skills

Experience & Education Required:

• Bachelor’s 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 SQL-based 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 cloud-based data warehouses - e.g. Snowflake, BigQuery, 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 non-technical 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 problem solving skills

Skills Preferred:

Experience Preferred:

Note: This position can be remote for the right candidate!