Data Architect – Data Warehouse/Analytics (Remote)

MSRcosmos LLC; United States; Remote; USD 150,000 - 210,000; Full time

Job summary

MSRcosmos LLC is seeking a Data Architect // Senior Application & Technical Architect – Data Warehouse/Analytics (Remote) to lead end-to-end architecture for reporting, analytics, data integration, and transactional processing across on-premises and cloud services.

You will translate requirements into scalable designs, modernize ETL and SQL logic, lead BI/reporting with Power BI/Tableau, and mentor a team of engineers and analysts while collaborating with leadership and customers.

Qualifications

• Bachelor’s degree or equivalent professional experience.
• 10+ years IT experience with senior-level architecture.
• Experience building enterprise data warehouses and analytics solutions.
• Proficiency in Python and advanced SQL.
• Experience with APIs, services, security, scheduling, monitoring.
• BI/reporting experience with Power BI or Tableau.
• CI/CD and source control in Azure DevOps.

Responsibilities

• Own end-to-end architecture for reporting and analytics.
• Translate requirements into maintainable designs with governance.
• Modernize ETL and SQL logic with Python-based automation.
• Provide hands-on leadership across development, testing, deployment.
• Lead BI delivery including enterprise report design and data quality.
• Present architecture options and risk assessments to stakeholders.

Skills

Leadership

Analytical thinking

Communication

Architectural vision

Education

Bachelor's degree in CS/Engineering/IS or related field

Tools

Power BI

Tableau

Azure DevOps

Python

Job description

Data Architect // Senior Application & Technical Architect – Data Warehouse/Analytics (Remote)

Primary Responsibilities

• Own end-to-end application and technical architecture for reporting, analytics, data integration, and transaction-based processing solutions across on-premises platforms and future cloud services.
• Translate business, operational, and regulatory requirements into maintainable system designs, including configurable business rules, effective-dated reference data, traceability, auditability, and reconciliation.
• Design and lead modernization of legacy ETL, SQL logic, Linux/Unix scripts, and manual processing into Python-based applications and automation, using enterprise data platforms efficiently for high-volume processing.
• Provide hands-on technical leadership across architecture, development, code review, testing, deployment, performance tuning, and production support to unblock the team.
• Build proof-of-concepts that compare solution options, document measurable results, and support architecture decisions with the customer and leadership.
• Define technical architecture across web/UI, API and service layers, processing engines, databases, orchestration, scheduling, security, identity/access, monitoring, and backup/recovery, in partnership with infrastructure, security, cloud, and data peers.
• Lead BI and analytics delivery including enterprise report design, drill-down and detail reporting, reconciliation, data quality, and modernization of legacy reporting capabilities.
• Establish engineering practices using Azure DevOps or equivalent – epics and user stories, repositories, branching, pull requests, CI/CD, release traceability, and production deployment – and apply AI and automation with appropriate governance to accelerate analysis, conversion, documentation, and testing.
• Produce architecture diagrams, solution designs, technical specifications, dataflow and interface documentation, implementation of roadmaps, estimates, risks, and operational support models.
• Lead and mentor architects, data engineers, ETL and BI developers, modelers, analysts, and testers; build backup coverage and develop team capability.
• Present architecture, options, risks, and recommendations concisely to customer stakeholders and Optum leadership, creating clarity across ambiguous scope, legacy constraints, and accelerated timelines.

Required Qualifications

• Bachelor’s degree in computer science, engineering, information systems, or related field, or equivalent professional experience.
• 10+ years of information technology experience, including senior-level application, solution, technical, or data architecture for large enterprise systems.
• Proven experience architecting enterprise data warehouse, reporting, analytics, and claims or transaction-processing solutions from the ground up – architecture, infrastructure, design, development, proof-of-concept, testing, implementation, and support.
• Hands-on development experience with Python and advanced SQL, including automation, data processing, troubleshooting, and code review.
• Experience designing application architecture including APIs, services, web components, databases, security, identity/access, job scheduling, monitoring, and environment management.
• Hands-on BI/reporting experience with BusinessObjects, Power BI, Tableau, SAS, or comparable enterprise reporting tools.
• Experience implementing source control, branching, pull requests, CI/CD, and automated deployment in Azure DevOps or a similar platform.
• People leadership experience leading BI, data, and engineering staff, with strong written, verbal, and presentation skills for customer and executive audiences.