Akkencloud - Nashua, NH
posted 2 months ago
As a Data Warehouse Developer at AkkenCloud, you will play a crucial role in the design, development, and administration of both transactional and analytical data constructs and structures. This position involves working with various data access and delivery technologies, primarily utilizing SAS to extract data from Teradata and other relational databases for comprehensive analysis. You will be responsible for creating SAS scripts and writing SQL queries based on input from the analytics and development teams, ensuring that the data is accurately represented and easily accessible for reporting and analysis purposes. Your responsibilities will include creating SAS data sets by extracting data from the Teradata database, SQL Server Management Studio, and flat files using Proc SQL, Proc Import, and SAS Data Step. You will also be tasked with cleaning, validating, and manipulating data using SAS and SQL to ensure high data quality. In addition, you will be involved in dashboarding, visualization, analysis, and Tableau reporting, which are essential for providing insights to various departments within the company. The role requires moving data between production systems and across multiple platforms while working with major querying tools. You will also be involved in data quality assurance, data organization, metadata management, and data profiling. Providing technical support to the data warehouse teams is a key aspect of this position, as you will actively support the development of systems that generate monthly and daily activity-based costing reports and profitability information for departments throughout the company using SAS and Teradata SQL. Troubleshooting job failures will also be part of your responsibilities, ensuring that data processes run smoothly and efficiently.