Senior Data Engineer, Data Base Architect

Design, develop, and implement cloud-based data storage and processing solutions utilizing AWS/Azure platforms for enterprise analytics and integration projects. Create data pipelines to extract, transform, and load data from multiple sources into data lakes and warehouses using Data Factory, SSIS, and PySpark. Develop and maintain dimensional data models,technical documentation, and architecture for data warehousing and analytics systems. Migrate data between platforms, automate infrastructure deployments, and implement CI/CD pipelines in Agile environments. The position requires occasional travel to unanticipated client locations in major metropolitan areas throughout the United States depending on projects and client requirement. The position may require relocation for a temporary period of 6 months or more depending on projects and client requirement. Travel is required for client meetings to gather requirements, analysis of client business processes and functional requirements.

Special Software/Hardware Skills Needed: No

Special Skills:

Bachelor's degree or foreign equivalent in Computer Science, Computer Information Systems, Information Technology, or related plus at least three years of experience in Azure Data Factory, SQL Server, Azure SQL DW, Redshift, Data Lake, SSIS, Python, PySpark, SQL, R, Tableau, SSRS, SSAS, Star/Snowflake, Schema, Dimensional and Tabular Data Modeling