Data architect

Job Description

An Insight Global Client is looking for a Senior Data Architect

Hybrid 3 days onsite in midtown

JOB PURPOSE:

Design, implement, and manage the enterprise data management platform that supports Business Intelligence (BI), analytical and reporting needs across various business functions. This position will lead (hands on) a comprehensive current state assessment of the data warehouse environment, including data sources, pipelines (ETL/ELT), and storage layers (staging, data stores, data marts)-and deliver a gap analysis using industry maturity models. The analysis will identify improvement areas across people, processes, and technology, and include recommended strategies for modernizing the data architecture. The architect will also assess current data inventories such as master/reference data, data dictionaries, standards, and metadata policies.

____

Primary Job Responsibilities:

• Lead (hands on) a current state assessment of data warehouse ecosystem, including:

o Source systems

o ETL/ELT pipelines (e.g., IBM DataStage)

o Data staging, operational data stores, and data marts

• Conduct a gap analysis based on industry-standard data architecture maturity models (e.g., DAMA-DMBOK, TDWI, Gartner).

• Develop actionable recommendations across people, processes, and technologies to evolve the data environment toward greater scalability, automation, quality, and governance.

• Create and implement short-term and long-term data strategy roadmaps aligned with strategic initiatives.

• Maintain and evolve reference architectures for current, transitional, and future states of the enterprise data platform.

• Design enterprise-level conceptual and logical data models and flow diagrams.

• Recommend modern data platform technologies (e.g., cloud-based data warehouses, data lakehouses).

• Collaborate with ETL, database, reporting, and security teams to ensure data integration, access control, and data quality practices are effective and scalable.

• Integrate data visualization tools (e.g., Tableau, Cognos) with Oracle databases, IBM DataStage, and other platforms.

• Support enterprise information governance, including metadata management, classification, sensitivity analysis, and compliance with privacy/security standards.

Compensation:

$110/hr

Exact compensation may vary based on several factors, including skills, experience, and education.

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.

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 [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

• 10+ years of experience architecting on-prem and cloud-based enterprise data solutions.

• Demonstrated experience leading a current state assessment and maturity gap analysis of a data warehouse or enterprise data platform, including recommendations and implementation planning.

• Proven expertise in designing and delivering enterprise data warehouse, analytics, and business intelligence solutions.

• Strong knowledge of data architecture models (conceptual, logical, physical) and industry maturity frameworks.

• Experience developing data governance and metadata management practices aligned with enterprise frameworks.

• Familiarity with BI and visualization tools (e.g., Tableau, PowerBI, Cognos).

• Experience with ETL platforms (especially IBM DataStage), integration tools (e.g., MuleSoft), and modern cloud platforms (e.g., Snowflake, Azure, AWS).

• Expertise in batch and real-time data integration, structured/unstructured data, and scalable data pipelines.

• Strong skills in data modeling, data quality management, and documentation standards. - Bachelor's or Master's degree in Computer Science or related technology field.

• Relevant industry certifications (e.g., CDMP, TOGAF, AWS/Azure Data Architect) are a plus.