Sr. Data Engineer

As a Sr. Data Engineer you will play a pivotal role in architecting, designing, and developing state-of-the-art data warehouse solutions for our enterprise. Your extensive leadership experience in data warehouse development, coupled with your strong management and interpersonal skills, will be instrumental in developing our team's intellectual capital and ensuring the success of our data initiatives.

Key Responsibilities:

• Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structure; establishing data integration specifications; examining data applications; examining data models and data warehouse schema; determining best-fit data interchange methods; assessing middleware tools for data integration, transformation, and routing; developing project scope and specifications; identifying factors that negatively impact integration; forecasting resource requirements; establishing delivery timetables.
• Analyze various data stores and database tables to establish knowledge of data for accurate retrieval and use.
• Implement stored procedures and effectively query data source.
• Experience designing and building complete ETL processes moving and transforming data for operational use.
• Validates data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
• Utilize available tools such as SQL, Power BI, Cognos, and Excel to provide technical reports for various requestors.
• Present data in a way that is most meaningful and readily accessible to the requestor using a combination of application solutions and system reports.
• Demonstrate outstanding communication skills to translate reporting requests in order to accurately meet the actual information and deadline needs of users.
• Educate requestors on appropriate and desirable parameters to ensure they get the information they need.
• Collaborate with end users to gather requirements and ensure proper testing and validation. Provide support to end users on standardized and ad hoc reports.
• Work closely with IT to ensure security enforcement when deploying reports.
• Programming custom solution tools as needed in an object oriented language of choice, along with documentation and training for those who will support the tools.

Qualifications:

• Training and direct experience in data engineering and using tools such as Azure Data Factory, MS SQL, Azure Synapse, SSIS, Power BI, SSRS, SQL Query Analyzer, Power BI, Cognos, and Excel. 
• Extensive working experience with MS SQL database and writing SQL and T-SQL queries and stored procedures
• Experience with other No-SQL databases like Cosmo and MongoDB a plus.
• Working experience with Azure environment a must, experience with other Azure tools like Logic Apps, Functions Apps, Power Automate/Apps, Azure Storage, App Services, a big plus
• Working knowledge of database architecture and design, data warehouse, data extraction, data modeling, and analysis.
• Communicate effectively verbally and in writing to technical and non-technical users. 
• Able to handle detail-oriented work while meeting schedules and deadlines.
• Ad-hoc reporting, Requirements analysis, Database management, Business Intelligence Tools, data modeling.