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:

• Work individually and in a matrix environment • Work creatively and analytically in a problem-solving environment • Communicate (written and oral) effectively and demonstrate professional interpersonal skills • Interact professionally with clients and vendors • Build positive working relationships with employees at all levels within the organization • Meet deadlines as necessary • Effectively work with minimal supervision • “Can-do” attitude, pro-active and resourceful • Knowledge of CI/CD pipeline. • Experience with scripting languages – e.g. PowerShell, Python, etc

Experience Preferred:

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

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

About the Company:
Amtec Human Capital Inc

Our mission: Enriching lives by helping companies build high-performing teams and helping people find meaningful work. Since 1959, Amtec has been teaming up with business owners and leaders, with the relentless purpose of finding the best match or the right fit for each position. We're not just a staffing company--we're a people company. At Amtec, it's our purpose to enrich people's lives by helping them find meaningful work. We match candidates' character, competence, and culture with an organization that truly values what they have to offer.

Company Size:
50 to 99 employees

Industry:
Staffing/Employment Agencies

Founded:
1959

Website:
http://amtec.us.com