SoHo Dragon is looking to hire Lead Data Architect for a healthcare company in Rochester, NY. This is a contract to hire position. Visa sponsorship is not available.

This is 100% onsite position.

JOB DUTIES AND RESPONSIBILITIES:

• Designs and builds scalable and efficient data architectures for enterprise systems and databases. Develops roadmaps, architectures, and data models. Leads data modeling, database design, and metadata management. Monitors data quality and develops processes to ensure accuracy and integrity of data assets. Identifies root causes of data issues.
• Works with the user community and reporting team to understand business data and data transformation requirements. Converts requirements to functional/technical specifications for database and integration design.
• Develops data integration and transformation processes across on premise and cloud data sources.
• Leads data integration and transformation processes across on premise and cloud data sources.
• Collaborates with other team members using scrum processes or other project management disciplines. Follows best practices for change and code management. Provides supporting technical documentation.
• Participates in ongoing stabilization. Collaborates across technology, product, and business teams to understand data needs and designs solutions that enable business goals. Attends webinars, reads case studies and white papers. Participates in opportunities to further refine skills and stay apprised on functional area topics. Maintains current knowledge of technology, equipment, and/or systems and advises on newer technologies.
• Other duties as assigned

QUALIFICATIONS:

• Bachelor's degree in a related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required; Master's degree preferred.
• 7 years of related experience required or an equivalent combination of education and experience.
• Experience with data architecture patterns and distributed systems (e.g. Hadoop, Spark) required.
• Extensive hands-on experience with data warehouses, ETL processes, and data modeling required.
• Project experience with data warehouse design, dimensional data models and ETL technologies required.
• Experience with service-oriented architecture and enterprise information integration preferred.
• Experience with integrating data warehouses with business intelligence metadata tools preferred.
• Strong analytical and problem-solving abilities.
• Ability to actively participate and collaborate on a team.
• Excellent written communication skills.
• Ability to translate functional business requirements into documented system requirements and designs.
• Knowledge of Data Warehousing/Business Intelligence lifecycles.
• In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) and NoSQL databases.
• Knowledge of Health Care EHR systems and/or Health care industry data experience preferred.
• Epic Cogito Data Model(s) obtained within first year of employment required.
• Denodo Architecture Training and Certification obtained within first year of employment required.