You will design, build, and enhance our SQL data warehouse, ETL processes, and Azure environments, as well as troubleshoot data and database issues. To excel in this role, you need a keen eye for detail, experience with the Azure data stack, and a deep understanding of data architecture fundamentals.

Responsibilities:

• Implement new or upgraded cloud data strategies and Azure platforms.
• Create Entity Relationship diagrams and write relational database queries.
• Create database objects and maintain referential integrity.
• Manage master data, including creation, updates, and deletion.
• Design, implement, and help maintain ETL migrations to Azure Data Factory.
• Process confidential data and information according to strict guidelines defined by the subject area owners.
• Provide quality assurance of imported data, working with business stakeholders and analysts.
• Participate in peer design reviews and development sessions within the team.
• Develop data models and is responsible for data acquisition, access analysis, archive, recovery, load design, and implementation.
• Support initiatives for data integrity and normalization.
• Collaborates with internal customers to capture requirements.
• Design, create, document, manage, and fulfill user requests for new or existing datasets.
• Adhere to SDLC processes and standards to ensure proper coding practices are followed.
• Provide technical expertise on data storage structures, mining, and cleansing.
• Apply best-of-breed data pipeline and data model design patterns to achieve robust and flexible data solutions.

Qualifications :

• Bachelor’s degree or equivalent from an accredited institution in computer science.
• 8 years of Work experience as a data architect or in a related field.
• Strong Azure data stack experience.
• Well-versed in Data Structure algorithms, Ability to analyze existing tools and databases and provide software solution recommendations.
• Ability to translate business requirements into non-technical, lay terms.
• Demonstrated experience in handling large data sets and relational databases.
• Build modern data reporting solutions in cloud technologies including Power BI a plus
• Expert in Enterprise Data, Data Warehousing, Azure Cloud Data platforms
• Integration experience with multiple source systems such as Salesforce, and custom-developed systems using REST API.
• Modeling warehousing and ETL methodology making use of cloud-based technologies in the Microsoft Stack (Microsoft SQL Server along with complementary technologies such as Azure Data Studio, Azure Data Factory, Blob Storage.