Address
Form of workJob Description
About the Job
Create and maintain optimal data pipeline architecture that is coherent and scalable, based on best practices of integrating data into a consolidated repository.Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL, cloud, and big data technologies.
• End-to-end solutions architecture of enterprise data solutions and platforms
• 10+ years' experience architecting enterprise data solutions
• 5+ years of relevant data management consulting or industry experience (Enterprise Data Architecture, EDW, ETL, MDM, Data Catalogs and Lineage, Data Quality, Data Strategy
• Lead the design, development, deployment of solutions including data ingestion, storage and manipulation.
• Design the technology framework, including data streams, integrations, transformations, databases, and data warehouses
• Expertise in Data Platforms and technologies, including data lakes, data warehouses, data analytics, data management, data governance, business process automation
• Experience architecting and developing cloud data solutions especially in Azure
• 5+ years of hands-on experience building conceptual, logical, and physical data models
• Experience with data warehousing and data integration (ETL/ELT), using ETL tools.
• Knowledge of modeling database schemas for large datasets.
• Knowledge of metadata-driven enterprise reporting platforms.
Duties:
As a member of delivery team, supports new development/project and production support, as the highest-level technology domain expert. Assesses business requirements; collects and identifies technical specifications; and develops technology solutions. Envisions and creates solutions that meet requirements; models pieces an infrastructure and points of integration; proves feasibility of a design; creates design artifacts required to deliver and maintain infrastructure; guides solution through to completion, implementation, and support in production. With Enterprise Architecture team, ensures new technology solutions are designed for optimal access and usefulness, and leverages existing technologies for specific technical domain(s), and understands system-wide impacts. Assists in near/mid-term roadmap creation, to address gaps and move towards future state architecture to support growth, optimization and innovation. Understand and document high-level master data management (MDM) requirements of the business and drive the definition of data standards and implementation best practices working with the BI and enterprise architecture teams. Establish domain specific standards, near/mid-term strategy, and roadmaps (0-18 months), in adherence to, and in support of Enterprise standards, strategy and roadmaps. Assist in creating the vision for future state technologies and architecture and participate in setting Enterprise standards and mid/long-term strategy/roadmaps (18-60 months), acting as domain specific subject matter experts. Responsible for domain specific content/collateral, based on the EA standards/ methodologies, to document the current state and future state architecture. Develop technology specifications and ensure that new technology solutions are designed for optimal access and usefulness, and leverage existing technologies when possible. Apply architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability. Participate and lead research and development efforts (proofs of concept, prototypes), as subject matter experts, when introducing new technologies. Provide technical expertise to propose level of effort projections, work breakdown structures and technical resource planning for proposed and current work to support the Project Management Office (PMO) and Project Review Board (PRB) Processes. Educate and influence others in order to gain buy-in on proposed solutions. Provide input to management throughout the project management lifecycle (PMLC). Assists managers with developing the service level agreements (SLAs) and deployment of key performance measures. Participate in various phases of the SDLC to perform QA/architectural review functions and to ensure adherence to Enterprise Architecture (EA) technology standards and project specific solutions architecture. (i.e., design reviews). Ensures technology solutions are production ready and meet the defined specifications, and that the solution can be maintained via production support methodologies and resources. Assist in IS Service Management policy and processes to effectively support domain. Assisted processes would include Incident Management, Problem Management, Change Management, Knowledge Management and Performance Management. Review the ongoing implementation solution for improvement opportunities. Facilitate communications between IS workgroups and business stakeholders for technical issues and/or major changes; acting as the technical domain subject matter expert. Provide t
REQUIRED COMPETENCIES
1. Required Job Skills Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones Intermediate PC proficiency Intermediate proficiency in spreadsheet, database and word processing software
2. Required Professional Competencies Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise business intelligence platforms. Integrity and Trust Ability to utilize strong analytical skills, take appropriate risks, while dealing with ambiguity and make effective decisions using available data. Ability to be approachable, develop peer relationships and build synergy with a diverse team in an ever-changing environment Ability to take appropriate risks, using available information. Anticipate downstream technical needs and steer architectural designs to appropriately factor in considerations. Strong analytical skills to support independent and effective decisions.. Ability to be customer focused with strong verbal and written communications skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts. Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise business intelligence platforms. Knowledge and skills in data warehousing design, methodologies and tools. Be driven for results and work effectively with management, project managers, business analysts, developers, engineers, architects, system administrators, and QA to conceive, design, and deliver successful BI solutions. Able to operate at highly varying levels of abstraction including business strategy, product strategy, technical design and implementation Work with all levels of management and functional areas and understand the potential implications of system changes to those areas. Ability to be self-aware and emotionally intelligent, able to give and receive constructive feedback and continue self-development.
3. Required Leadership Experience and Competencies Provide leadership, promote teamwork, meet objectives and exercise independent judgment Experience leading and implementing projects and working collaboratively with other departments levels Ability to prioritize tasks and work with multiple priorities, sometimes under limited time contstraints. Ability to build synergy with a diverse team in an ever-changing environment
PREFERRED COMPETENCIES
1. Preferred Job Skills Expert knowledge designing highly redundant, scalable, multi-tier enterprise transaction processing systems from front end to back end. Knowledge of HIPAA security and privacy standards. In depth knowledge of healthcare and health plan data structures and business processes and workflows.
2. Preferred Professional Competencies N/A 3. Preferred Leadership Experience and Competencies N/A
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
Create and maintain optimal data pipeline architecture that is coherent and scalable, based on best practices of integrating data into a consolidated repository.Build the infrastructure required for optimal extraction, transformation, and loading (ETL) of data from a wide variety of data sources using SQL, cloud, and big data technologies.
• End-to-end solutions architecture of enterprise data solutions and platforms
• 10+ years' experience architecting enterprise data solutions
• 5+ years of relevant data management consulting or industry experience (Enterprise Data Architecture, EDW, ETL, MDM, Data Catalogs and Lineage, Data Quality, Data Strategy
• Lead the design, development, deployment of solutions including data ingestion, storage and manipulation.
• Design the technology framework, including data streams, integrations, transformations, databases, and data warehouses
• Expertise in Data Platforms and technologies, including data lakes, data warehouses, data analytics, data management, data governance, business process automation
• Experience architecting and developing cloud data solutions especially in Azure
• 5+ years of hands-on experience building conceptual, logical, and physical data models
• Experience with data warehousing and data integration (ETL/ELT), using ETL tools.
• Knowledge of modeling database schemas for large datasets.
• Knowledge of metadata-driven enterprise reporting platforms.
Duties:
As a member of delivery team, supports new development/project and production support, as the highest-level technology domain expert. Assesses business requirements; collects and identifies technical specifications; and develops technology solutions. Envisions and creates solutions that meet requirements; models pieces an infrastructure and points of integration; proves feasibility of a design; creates design artifacts required to deliver and maintain infrastructure; guides solution through to completion, implementation, and support in production. With Enterprise Architecture team, ensures new technology solutions are designed for optimal access and usefulness, and leverages existing technologies for specific technical domain(s), and understands system-wide impacts. Assists in near/mid-term roadmap creation, to address gaps and move towards future state architecture to support growth, optimization and innovation. Understand and document high-level master data management (MDM) requirements of the business and drive the definition of data standards and implementation best practices working with the BI and enterprise architecture teams. Establish domain specific standards, near/mid-term strategy, and roadmaps (0-18 months), in adherence to, and in support of Enterprise standards, strategy and roadmaps. Assist in creating the vision for future state technologies and architecture and participate in setting Enterprise standards and mid/long-term strategy/roadmaps (18-60 months), acting as domain specific subject matter experts. Responsible for domain specific content/collateral, based on the EA standards/ methodologies, to document the current state and future state architecture. Develop technology specifications and ensure that new technology solutions are designed for optimal access and usefulness, and leverage existing technologies when possible. Apply architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability. Participate and lead research and development efforts (proofs of concept, prototypes), as subject matter experts, when introducing new technologies. Provide technical expertise to propose level of effort projections, work breakdown structures and technical resource planning for proposed and current work to support the Project Management Office (PMO) and Project Review Board (PRB) Processes. Educate and influence others in order to gain buy-in on proposed solutions. Provide input to management throughout the project management lifecycle (PMLC). Assists managers with developing the service level agreements (SLAs) and deployment of key performance measures. Participate in various phases of the SDLC to perform QA/architectural review functions and to ensure adherence to Enterprise Architecture (EA) technology standards and project specific solutions architecture. (i.e., design reviews). Ensures technology solutions are production ready and meet the defined specifications, and that the solution can be maintained via production support methodologies and resources. Assist in IS Service Management policy and processes to effectively support domain. Assisted processes would include Incident Management, Problem Management, Change Management, Knowledge Management and Performance Management. Review the ongoing implementation solution for improvement opportunities. Facilitate communications between IS workgroups and business stakeholders for technical issues and/or major changes; acting as the technical domain subject matter expert. Provide t
REQUIRED COMPETENCIES
1. Required Job Skills Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones Intermediate PC proficiency Intermediate proficiency in spreadsheet, database and word processing software
2. Required Professional Competencies Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise business intelligence platforms. Integrity and Trust Ability to utilize strong analytical skills, take appropriate risks, while dealing with ambiguity and make effective decisions using available data. Ability to be approachable, develop peer relationships and build synergy with a diverse team in an ever-changing environment Ability to take appropriate risks, using available information. Anticipate downstream technical needs and steer architectural designs to appropriately factor in considerations. Strong analytical skills to support independent and effective decisions.. Ability to be customer focused with strong verbal and written communications skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts. Demonstrated thorough understanding of modern enterprise architecture, hands-on experience with enterprise business intelligence platforms. Knowledge and skills in data warehousing design, methodologies and tools. Be driven for results and work effectively with management, project managers, business analysts, developers, engineers, architects, system administrators, and QA to conceive, design, and deliver successful BI solutions. Able to operate at highly varying levels of abstraction including business strategy, product strategy, technical design and implementation Work with all levels of management and functional areas and understand the potential implications of system changes to those areas. Ability to be self-aware and emotionally intelligent, able to give and receive constructive feedback and continue self-development.
3. Required Leadership Experience and Competencies Provide leadership, promote teamwork, meet objectives and exercise independent judgment Experience leading and implementing projects and working collaboratively with other departments levels Ability to prioritize tasks and work with multiple priorities, sometimes under limited time contstraints. Ability to build synergy with a diverse team in an ever-changing environment
PREFERRED COMPETENCIES
1. Preferred Job Skills Expert knowledge designing highly redundant, scalable, multi-tier enterprise transaction processing systems from front end to back end. Knowledge of HIPAA security and privacy standards. In depth knowledge of healthcare and health plan data structures and business processes and workflows.
2. Preferred Professional Competencies N/A 3. Preferred Leadership Experience and Competencies N/A
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
