Senior SQL Data Warehouse Developer

Key Skills

Agile methodologies, ETL/ELT technologies, OLAP, PowerBI, RDBMS, SSIS, T-SQL, Tableau, Teradata

Job Description

Analog Devices, Inc. (NASDAQ: ADI) is a global semiconductor leader that bridges the physical and digital worlds to enable breakthroughs at the Intelligent Edge. ADI combines analog, digital, and software technologies into solutions that help drive advancements in digitized factories, mobility, and digital healthcare, combat climate change, and reliably connect humans and the world. With revenue of more than $12 billion in FY22 and approximately 25,000 people globally working alongside 125,000 global customers, ADI ensures today’s innovators stay Ahead of What’s Possible.

Responsibilities:

• Database modeling, including collaborative design and interpretation of ADI business models.
• Establish reporting hierarchies to support analytic solutions and enterprise master data management initiatives.
• Develop database objects, including tables, stored procedures, views, triggers, keys, and declarative integrity constraints
• Performance optimization, index design and management
• Design the lifecycle management for ADI’s BI solution
• Project testing and impact analysis
• Manage key data warehouse functions including data extraction and transformation logic
• Design and develop database level security
• Establish an administrative support model for ADI’s business intelligence solution, including the development life cycle management process
• Job design and server management
• Design and build OLAP reporting solutions
• Integrate data warehouse content with ADI’s reporting tools.
• Plan and manage DBMS upgrades and future application migrations.

Job Requirements:

• 8-12 years of progressive development experience in an enterprise data warehouse environment.
• Expert knowledge of T-SQL is a must
• Demonstrated experience building models for revenue, HR, financials, inventory, projects, and operational data sets.
• Expert knowledge of Microsoft SQL Server Data Tools, including SSIS and SSAS.
• Experience with data visualization tools such as Power BI, Tableau, or QlikView is a plus
• Experience with advanced analytic and ETL tools, including Teradata, BO Data Services and Informatica is a plus.
• Must be a proactive thinker with solid business judgment; communicate effectively with all levels of the organization
• Experience and enthusiasm for working in AGILE development environments.
• Bachelor's degree in computer science or finance is required. Master's degree is desired.

Job Req Type: Experienced

Required Travel: Yes, 10% of the time

Shift Type: 1st Shift/Days