Sr. Data Architect

$150,000 - $180,000

Full Time

  • Work from home
  • No Travel Required

Skills

Denododata modelingSQLdenodo architectdenodo architecturedenodo administrationdata virtualizationinstallationconfigurationsecurity

Job Description

Role:                                              Sr. Data Architect Work Location:                             Houston, TX (4 days onsite, 1 day WFH) Number of Positions:                  1
Position Type:                               Fulltime
 
US CITIZENS AND HOLDERS ARE ENCOURAGED TO APPLY. WE ARE UNABLE TO PROVIDE SPONSORSHIP AT THIS TIME.
 
RELOCATION ASSISTANCE WILL BE PROVIDED FOR THE RIGHT CANDIDATE
 
JOB SUMMARY
The Sr. Data Architect oversees the execution of data delivery strategy utilizing Denodo. They are involved in all phases of the analytic projects, from requirements gathering, data architecture, integration guidance and developing support artifacts. This Sr. Architect demonstrates senior-level leadership skills and experience in guiding the team to build a self-sustainable BI platform. They will create best practices, define, and govern data architecture standards, lead, and support development efforts, manage BI demand, coordinate resource capacity, prioritize and lead the scoping effort. The ideal candidate can mentor others in maintainable development practices and code reviews and ensures correct capitalization / expense activities of the project team and can provide business insight across multiple domains. This Sr. Architect will demonstrate an ability to manage complex, high-quantity and potentially contradictory information to effectively solve problems, applies knowledge of the business to advance organizational goals, and intuitively navigates complex policy, people, and process-related organizational dynamics.


REQUIREMENTS:
·       Requires bachelors’ degree from a four-year college or university with 10+ plus years of in-depth hands-on experience in data modeling, SQL and 3+ years in Denodo. ·       Denodo platform certification (architect level).
  • Good understanding and experience in Data Virtualization At least 3+ yrs. of experience with Administration and development in Denodo Administration experience to include installation, configuration, security, cache management in a highly available enterprise environment.
  • Sound data architecture principles based on traditional data warehousing concepts and modern concepts
  • 3+ Years of data modeling experience, from business modeling to logical modeling
  • 6+ years of SQL experience with mastery on multitude of techniques to pull data based on requirements and data volume
  • Sound understanding of data virtualization principles. Denodo experience and certification is a huge plus
  • Understanding of LDAP, SSL and other security concepts.
  • Good knowledge of JDBC, XML and Web Services APIs.
  • SAP and general system knowledge of CDS views, BW queries and Hana database.
  • Working knowledge of combining Hana, SQL Server, Amazon S3 and APIs
  • Validate and ensure non-functional requirements (e.g. system performance) are in place
  • Access definitions - APIs, querying other access methods; ODATA standard protocols implementation, security.
  • Good knowledge of query optimization and analysis of SQL execution plans in context of heterogeneous joins.
  • Experience working with GIT or other version control systems is a plus

Soft Skills
  1. Manages complexity to effectively find solutions and solve problems
  2. Drives results by consistently achieving completion and closure of tasks, even in the face of obstacles and setbacks
  3. Adaptive personality and ability to function in a fast-paced environment
  4. A problem-solving attitude that can adapt to varying timelines
  5. A strong attention to detail combined with the ability to prioritize tasks
  6. Strong interpersonal skills; promoting healthy relationships and team dynamics
  7. Strong capability to plan and align work with regards to sense of urgency and priority
  8. Strong capability to provide Business Insight
  9. Strong ability to influence organization stakeholders
 
 
DUTIES & RESPONSIBILITIES:
·       Engagement o  Collect feedback and influence users and stakeholders to prioritize and develop data-centric work products and support requests. o  Work with internal (IT technical and functional) and external (vendor) partners to source, review, and deliver data-related solutions for projects. o  Create and track KPIs for enterprise data virtualization service capability to share with management and user community. o  Ability to drive the architecture, design along with experience in leading the team technically ·       Architecture o  Refine the current Denodo deployment with sound data architecture that delivers data for Analytics, BI and Applications via services o  Ensure data security is maintained throughout the user, application, platform, and data layers. o  Design integration with front-end tools (Tableau, custom apps) and back-end applications and data (e.g. SAP). ·       Process o  Establishes process for Architecture review, code review and development process for the Denodo engineers o  Continuously refines the processes by measuring process related KPIs ·       Development o  Maintain and extend agile data development methodology in support of both self-service and full-service models. o  Create reusable semantic and report-specific data layers that are secure and performant. o  Develop techniques for optimizing solutions, including caching, refactoring, performance, and testing. o  Define data catalogues. ·       Admin/Support o  Troubleshoot issues that may occur within the data platform or in consuming apps/tools and data sources. o  Ensure SLAs are developed and met for response and resolution times for business-critical data platform. o  Establish and implement operations (e.g. monitoring and logging) to keep platform (multiple Windows servers) stable and up-to-date (i.e. quarterly updates and periodic upgrades). ·       Works under minimal supervision ·       Other duties as assigned. ·       Responsibly receive, transmit, and handle consumer and customer data per applicable policies and procedures. ·       Review and follow data privacy practices, policies, and guidelines.


Benefits:
Competitive benefits include Medical, Dental, Vision, 401k with matching, PTO and an opportunity for long-term stability and growth in a company that truly values its’ employees