Data Warehouse Architect

Greeting From Skysoft

Role: Data Warehouse Architect

Location: Albany, NY// Hybrid

Experience: 12+years Must

Only US Citizens

1. Perform data analysis of current and future WIC systems, including system comparison, to support ongoing and future data needs.

2. Collaborate with customers, vendors, and technical teams to gather requirements, perform gap analysis, and prioritize reporting needs.

3. Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema design.

4. Define and enforce data standards, naming conventions, governance practices, and ensure data quality, integrity, and consistency across all environments.

5. Develop and maintain documentation of business processes, workflows, and data flows using modeling techniques and flowcharts.

6. Develop, review, and optimize ETL processes and mappings for data migration (Sybase, MS Access to Oracle), improving performance and efficiency.

7. Design and support reporting solutions, including dashboards and prototypes, aligned with end-user requirements.

8. Develop and execute test plans, scripts, and validation scenarios to ensure data accuracy and compliance with business requirements.

9. Monitor and optimize database performance through query tuning, indexing, partitioning, and overall system optimization.

10. Implement and maintain database security, access controls, auditing, and compliance with organizational and state data privacy requirements.

What type of software is typically used by the Agency? Oracle, Informatica, ERWIN, MS Office, Visio, SharePoint, Remedy Force, OBIEE, SQL Developer, Linux operating system

• 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 Months Experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments.
• 72 Months Experience leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring for data warehouse initiatives.
• 72 Months Experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, optimization, and conversion of complex SQL, stored procedures, and SAS logic into Informatica mappings.
• 72 Months Experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD
• 84 Months Experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
• 48 Months Experience in data modeling and system analysis, including dimensional modeling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.
• 48 Months Experience in ETL and BI testing, including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution across BI and data warehouse systems.
• 48 Months Experience in advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.
• 48 Months Experience in end-to-end BI implementation and data governance, including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, and enterprise data governance, lineage, and quality frameworks.