Sr. Data Warehouse Developer - (Azure)

Offer by Elan Partners

azure

sql

cloud

About this job

Job type: Full-time
Role: Database Administrator



Technologies

azure, sql, cloud



Job description

Title – Sr. Data Warehouse Developer (Azure)


As the Sr. Data Warehouse Developer for our downtown based client you will design, develop, and maintain operational data stores, data warehouses, data marts, data lakes and analytics and work closely with executive leadership to define, design and implement data and analytics strategy and deployment.  Ideal candidate will have experience migrating data from legacy systems to the cloud and designing/implementing flexible platforms.  This is a great opportunity for someone with strong analytical, consultative, and communication skills who enjoys working with technically astute teams, to get in on the ground floor of a cloud platform transformation. This is a Direct Hire position. Local candidates preferred.  Our client is unable to sponsor.


Required Skills & Experience

  • 2+ years performing data warehouse development and management.
  • High proficiency in dimensional modeling techniques and their applications including star- schemas
  • Extensive experience with SQL Server Platform, SSIS and stored procedures.
  • Demonstrated experience designing/developing/supporting new and existing ETL processes, testing/administering RDBMS, and monitoring of database.
  • Experience employing industry standards/best practices to optimize loading/transformation of data from various technologies and techniques in disparate source/destination systems
  • Experience with Tableau, Hana, Power-BI, SQL Server Reporting Services, and/or other reporting and analytical tools.
  • Must possess excellent communication and analytical skills.
  • Experience with Microsoft Azure computing platforms highly preferred


Responsibilities

Design and implement a flexible platform for operational data stores, data warehouses, data marts and data lakes using standard practices as well as documenting the systems of record, data dictionaries and data flow diagrams as well as other artifacts for strategic data management.

Delivering large data integration projects is a significant part of this position - leveraging best practices expertise and experience at implementation, including expert knowledge in data warehouse, star-schema design, snowflake schema design, slowly changing dimensions and effective dating of data to be able to analyze data at various points in time.


BENEFITS of working for our Client:

  • Growing, Dynamic, Collaborative Environment
  • Excellent Medical and 401K with matching
  • Tuition Reimbursement
  • Generous PTO
  • Flex Time and Work from Home Opportunities


A new version is available REFRESH