Sr. Data Engineer

Akkodis, Inc. is a billion dollar global employer headquartered in Cleveland, OH, seeking a full-time remote Sr. Data Engineer. The role involves providing technical leadership and strategic guidance for data warehousing systems, ensuring data quality, and enhancing data architecture.

Responsibilities:

• Provides strategy and vision for increasing the value of the data architecture platform and related data warehousing toolsets
• Participates in development and continuous improvement of strategies for data asset management and governance, including supporting requirements for security, accuracy, performance, and availability
• Participates in building and maintaining: Data Models, Data Naming Standards, Enterprise Data Dictionary, Data Asset Inventory, and Data/Information Flows
• Communicates with relevant data stakeholders to research and help resolve data anomalies and/or data quality issues
• Assists information workers and development teams with outcome-focused requirements gathering and design of supporting information delivery capabilities. Lead the design, implementation, and continuous delivery of a sophisticated data pipeline supporting applications and reporting
• Final validation of end-user data warehousing requirements, promoting awareness and understanding of the data available in the data estate by planning and leading effective socialization campaigns, designing, defining and implementing data quality assurance processes and leading the creation of standard data architecture including dimensional model design
• The Engineer is responsible for monitoring data warehouse loads during periods when successful loads are a requirement (e.g., Year End), working weekends, second shift and/or third shift, as necessary
• Designs and implements data models to support analytics and reporting initiatives
• Reviews current database architecture and propose solutions to scale processing and reporting functionality
• Prepares requirement analysis and documentation for new data and changes to existing data
• Performs logical and physical design of data warehouse elements
• Performs source to target mapping for data warehouse elements
• Maintains metadata information for data warehouse elements
• Maintains thorough documentation for data models, processes, and any changes made to the data warehouse
• Ensures seamless data flow between various systems and the data warehouse using data integration tools and techniques
• Enhances data analysis capabilities through familiarity with advanced analytics tools and techniques, such as machine learning, AI and GenAI

Requirements:

• 8+ years in data engineering within data warehouses
• In-depth knowledge of T-SQL and Microsoft SQL Server
• In-depth knowledge of SQL Server Reporting Services and Power BI
• In-depth knowledge of Microsoft Fabric
• In-depth knowledge of Azure Databricks and medallion architecture
• In-depth knowledge of Azure Data Factory
• In-depth knowledge of Azure storage accounts
• In-depth knowledge of Azure DevOps
• 8+ years in relational database design and data warehouse design skills
• Additional data warehousing related Azure resources and toolsets
• IaaS concepts
• BICEP scripting
• SQL PaaS
• Familiarity with DAX