A global technology and design manufacturing company is seeking a strong Data Solutions Architect to join their enterprise Analytics team. This team works closely with corporate strategy and executives to drive organic growth by leveraging big data and advanced analytics to meet the business' needs. Additionally, they are looking to build and scale their advanced analytics practice so this individual will play a key role in managing the existing cloud data platform to make it more scalable, reliable, and cost efficient. This is a fully remote position (EST hours) and is a one year contract.

Primary Responsibilities:
- Define and align on strategic initiatives pertaining to Data and Analytics Architecture
- Design and develop data lakes, manage data flows that integrate information from various sources into a common data lake platform through an ETL Tool and support near real time use cases as well.
- Design repeatable and reusable solution architectures and data ingestion pipelines for bringing in data from ERP source systems like SAP.
- Manage data integration with tools like Databricks and Snowflake or equivalent data lake and data warehouses.
- Design and Develop Data warehouses for Scale.
- Design and Evaluate Data Models (Star, Snowflake and Flattened)
- Design data access patterns for OLTP and OLAP based transactions.
- Triage, debug and fix technical issues related to Data Lakes and Data Warehouses.
- Serve and Share data through modern data warehousing tools and practices.
- Coordinate with Business and Technical teams through all the phases in the software development life cycle.
- Participate in making major technical and architectural decisions.
- Hands-on prototyping of new technology solutions by working with cross teams.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience
- 5+ Years of Experience operating on AWS Cloud with building Data Lake and data warehousing architectures
- Experience building Data Warehouses on Snowflake, Redshift, HANA, Teradata, Exasol etc.
- Experience with AWS Data services like S3, Glue, Lake Formation, EMR, Kinesis, RDS, DMS and others
- Experience with Data Modelling and working knowledge of big data technologies (Spark preferred)
- Strong hands on experience with ETL tools - Talend, Informatica, SAP Data Services
- Experience with Databricks
- Strong programming experience - Python, R, Scala, Java
- Experience working with ERP systems (SAP preferred) for data integration
- Experience working in an Agile environment
- Strong analytical problem solving skills, presentation skills, and communication skills

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.