Logo
Insight Global

Data Architect

Insight Global, Memphis, Tennessee, us, 37544


We are seeking an experienced Data Architect to join our team, supporting one of our top clients in the Pharmacy Solutions industry. This role is pivotal in driving transformations for the BI team. Key responsibilities include: Transforming raw data into consumable formats for the BI team. Designing and implementing dynamic data ingestion processes for various data types and files. Optimizing data storage solutions to enhance query performance in Synapse. Continuously suggesting and implementing improvements. Work Breakdown: 30% Data Modeling: Document current data flows and structures. 30% Dynamic Data Ingestion: Develop new processes for ingesting diverse data types. 30% Innovation: Explore and integrate new technologies and methodologies. 10% Meetings: Collaborate with team members and stakeholders. Responsibilities: Develop and maintain data models. Provide fresh perspectives and innovative ideas. Design and build traditional data warehouses. Implement modern tools, patterns, and approaches. Utilize existing tools and infrastructure effectively. Model data for data warehouses, including table structures and data lakehouses. Apply modern data patterns and practices.

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

Experience with data lakes and data lakehouses. Proficiency in Azure services, including Azure Synapse and Azure Mesh. Strong SQL skills. Business Intelligence (BI) support, including data transformation for consumption.

Nice to Have Skills & Experience

Familiarity with Microsoft Medallion architecture (bronze/silver/gold). Experience with Snowflake.

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.