Location: Albany, NY- Onsite (with some remote work after a few months)
Only Local
Interview: Video
Duration: 30 month+
Key Responsibilities
Daily activities will include, but are not limited to:
Lead efforts in identification and analysis of Data Requirements to drive data models and data structures.
Identify business rules that govern how data is transformed, integrated and used.
Develop data architecture and architectural considerations supporting IES Projects.
Develops database solutions by designing proposed system; defining database physical structures and functional capabilities, security, back-up, and recovery specifications
Ensure architectural rules and design of the MDM process are documented and best practices are adhered to
Design and develop data architecture for scalable technical solutions in the areas of data optimization, data management, performance and efficiency
Assist in establishment of policies, procedures and guidelines regarding all aspects of Master Data Management
Work with ETL Developers and DBA teams to determine best practices as it relates to data transformations, data movement and derivations.
Collaborate with ITS, NYSOH and NYC technical resources on continuous assessment of existing solutions for reuse on IES projects.
Collaborate with IES Technical Architects to develop data management strategies.
Collaborate with ITS Chief Technology Office to align with enterprise standards.
Collaborate with internal and external partners ensuring technology decisions and data designs align with overall stewardship model.
Participate in technical discussions with state, local and vendor implementation teams and technical deliverables to ensure alignment between proposed solutions and the program's data standards.
Other duties as assigned
Mandatory Qualifications
Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as an Architect
Five or more years experience with Master Data Management, Meta Data Management, and Enterprise Data Integration.
Four or more years of experience in designing or reviewing data architecture of an eligibility and enrollment, case management, financial management, or claims systems.
Desirable Qualifications
Five or more years of experience in Data architecture and designs across multiple IT Functional Areas.
Five or more years of experience with enterprise data management technologies, including database platforms, ETL tools, Analytics & Reporting tools.
Four or more years of experience in designing and developing ETL workflows.
Working experience in enforcing standards for database security and configuration for all production databases and for non-production databases that may contain PHI or other sensitive data protected under HIPAA, Sarbanes Oxley, or other state or federal regulatory requirements.
Working knowledge of Enterprise Architecture documentation of various business processes and modeling to build data flow diagrams, process models, ER diagrams, dimensional data models, and event modeling.
Three or more years of experience with ERWin or other data modeling tools.
Working knowledge of Oracle & SQL Server architecture and database design.
Working experience working with different databases structures for OLTP, OLAP & high-volume transaction systems.
Knowledge with data visualization tools (e.g. Tableau).
Working experience with Health & Human services applications.
If you are interested, share your resume to a.singh@tekintegral.com
Seniority level
Mid-Senior level
Employment type
Contract
Job function
Engineering and Information Technology
Industries
Government Administration
Referrals increase your chances of interviewing at TekIntegral by 2x