BEH5I4-Data Solution Architect 4 - B58-Data Solution Architect B58-Data Solution Architect

Overview

Design and maintain ETL, data warehouse, and BI solutions using SQL Server and Power BI.

Key Responsibilities

• etl development
• power bi
• sql server
• data warehouse
• data pipeline
• monitoring

Tasks

-Conducts comparison processes to identify and develop process improvements; provides recommendations on next steps and manages deliverables. -Conducts or coordinates unit and system tests ensuring intelligence is consistent with defined needs. -Designs, develops, and maintains ETL routines and reporting using Microsoft SQL Server and Power BI. -Supports implemented BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues. -Documents specifications for Data Warehouse (DWH) extracts, reports, dashboards, or other outputs. -Work closely with AP Systems business intelligence experts to ensure data product attributes accurately represent business process outputs to drive actionable reporting and modeling insights. -Build repeatable data pipeline strategy across multi environments, leverage automation to make sure ETL solutions are repeatable and scalable -Identifies and recommends changes to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity. -Design, develop, maintain, and optimize current AP Systems Reporting infrastructure systems (Including on Prem SQL Db, data warehouses, and cloud lake house) -Designs and deploys database table structures, reports, and queries. -Facilitates and leads project planning and execution with cross functional teams across the organization. -Guides other data and analytics professionals on data standards and practices

Requirements

• ai
• rest api
• t-sql
• etl
• bachelor's
• 10+ yrs

What You Bring

-Familiarity with AI concepts and algorithms, with the ability to collaborate with data scientists in implementing AI models and integrating them into data systems. -Strong problem-solving and troubleshooting skills, with the ability to monitor and optimize the performance of data systems, ensuring data quality, integrity, and security. -Aviation Industry Experience Strongly Preferred. -Proficient in writing Rest API/mTLS to extract data from various physical and cloud databases/data lakes. -Bachelor’s degree in mathematics, Computer Science, or a related field. -Proficient in writing T-SQL code, SSIS packages, and Stored Procedures on Microsoft SQL Server. -Strong knowledge of data integration and ETL processes, with experience in designing and implementing efficient data pipelines. -Minimum of 5 years of relevant experience in developing data warehousing solutions, dashboards, scorecards, and analytics. -10-15+ years data engineering experience and transforming internal businesses through automation and other technologies. -Proficiency in system architecture design, including selecting appropriate database technologies, data warehousing solutions, and distributed computing frameworks. -Experience in Data Visualization / UX Designer skills - designs user flows and interfaces for data-driven applications and dashboards.

People Also Searched For

About Alten

-The company specializes in projects across various industries, including aeronautics, automotive, rail, energy, life sciences, telecommunications, and defense. -They utilize a hybrid delivery model, combining on-site consulting with offshore delivery centers across Europe, Asia, and the Americas. -The company's history is characterized by strategic acquisitions and international expansion, enhancing its offerings in IT services.

Sector Specialisms