Published date Posted on Indeed on Aug 05, 2022 (7 d ago)

Summary

The Data Analytics Architect will help design, implement, and support the organization's transactional and dimensional Data Warehouse development efforts, providing guidance and direction to clients and project team members. The Architect interacts with all technical and business resources levels to meet operational and strategic reporting and analytical needs. Provide warehouse design, architecture, reporting/analytics, implementation, and integration efforts, including data sourcing and transformation. Help define the process to ensure that the proposed data warehouse architecture and design meet the client's business goals and objectives. Leverage knowledge of current data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.

Responsibilities

  • Support database development and requests in MS SQL Server and DB2
  • Develop conceptual, logical, and physical data models
  • Design and develop new data structures in online transaction (OLTP) and data warehouse (OLAP) databases
  • Build and maintain ETL solutions (Current need in SSIS, but Azure Data Factory will be accepted)
  • Perform impact analysis on data structure changes
  • Define and enforce database standards, including sensitive personally identifiable information (SPII) and data security compliance
  • Review SQL for performance improvements
  • Manage automated database job schedules
  • Support global metadata data dictionary repository
  • Identify logical issues between database models and reports.
  • Follow change management procedures
  • Provide cross-training and mentor other team members as needed
  • Provide after-hours support based on the on-call rotation
  • Support infrastructure changes as needed
  • Advise on innovative technology trends and adoption to maintain competitive advantage
  • Other duties as assigned

Required Knowledge, Skills, and Abilities

  • Advanced experience with OLAP dimensional database design
  • Advanced SQL programming background
  • Experience in creating reports and dashboards in industry standard tools, PowerBI or Tableau (Preferred)
  • Expert experience with MS SQL Server and SSIS or Azure Data factory
  • Knowledge of the software development lifecycle, including systems analysis, design, development, testing, and deployment
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools
  • Effective communication skills include facilitation, presentation, and documentation.
  • Ability to capture and transform business requirements into functional and data specifications.
  • An elevated level of initiative, self-starter, flexible, proactive, and team player.
  • Experience in handling large data volumes, deep understanding of data marts, data warehouse architecture, multidimensional databases, data lakes, and data migration.
  • Mainframe and DB2 experience
  • Linux/Unix experience
  • Strong technical aptitude and professional maturity
  • A desire to learn and help the organization progress in these areas:
  • Azure Stack - Synapse, Data Lake, Data Factory, Databricks, Stream Analytics, EventHub, etc.
  • DevOps Mindset, Infrastructure as Code, and Data Ops for the data warehouse

Job Type: Full-time

Benefits:

  • 401(k)
  • Dental insurance
  • Health insurance
  • Paid time off
  • Vision insurance

Schedule:

  • 8 hour shift

Experience:

  • Data warehouse: 8 years (Required)
  • Azure Data Factory: 8 years (Preferred)
  • ETL: 8 years (Preferred)
  • Snowflake: 8 years (Preferred)
  • OLAP: 8 years (Preferred)

Work Location: Remote


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Piper Companies Piper Companies |
|
Yesterday

Piper Companies is looking for an IT Manager, Data for a leading pharmaceutical organization based in the Philadelphia, PA area.THIS IS A REMOTE OPPORTUNITYResponsibilities for the IT Manager, Data:You will lead developers, data engineers, DevOps, BA’s,.

Get To Know Us!GuideWell and its family of forward-thinking companies are focused on helping people and communities achieve better health and are at the forefront in the transformation of health care. We offer competitive salaries and benefits, work-life.

NeoGenomics Laboratories NeoGenomics Laboratories |
|
Yesterday

Are you motivated to participate in a dynamic, multi-tasking environment? Do you want to join a company that invests in its employees? Are you seeking a position where you can use your skills while continuing to be challenged and learn? Then we encourage.

Origami Risk Origami Risk |
|
Yesterday

Overview:The Software Implementation Specialist/Client Executive is part of the Professional Service team at Origami Risk. You will be a hands-on generalist focused on leading both technical and functional aspects of the full software implementation.

Tista Science and Technology Corporation Tista Science and Technology... |
|
3 d ago

Overview:The Senior Database Architect must have experience creating work breakdown structures and development of program schedules and assigning software development team personnel to tasks. Must have experience in the tracking resources and expenditures.

General Dynamics Information Technology General Dynamics Information... |
Today

Travel Required: 10-25%Public Trust: NACI (T1)Requisition Type: PipelineGDIT is seeking a Data Architect to support a mission-critical system modernization initiative in a highly complex information technology environment. We are looking for a technology.

Teleperformance Teleperformance |
5 d ago

Overview:Teleperformance is a strategic partner to the world's leading companies, bringing solutions and enhancing customer experience during each interaction. We are the largest interaction expert team in the market: multicultural, highly skilled, and.

itechedgecorp itechedgecorp |
7 d ago

No H1 Transfer PleaseHi,Hope you are doing great!!Please find the below job description and let me know your Interest.Job Title : Azure Databricks Architect / DeveloperLocation : RemoteExperience : 10+YearsDuration : - Long Term Contract Need LinkedIn.

Inviso partners closely with Microsoft’s rapidly growing SMB Evaluations team in the United States to support Microsoft customers’ journey to the cloud, providing a range of services across Program Management, Business Intelligence, Analytics, and Data.

RADCube RADCube |
7 d ago

Stored Procedures, SQL Server, Azure Advanced SQL Server 2012 skills should include: Designing, developing, testing and supporting large scale databases. Ability to do large scale Data Modeling - expertise in creating all key database objects, Tables,.