Sr. Data Engineer - Remote

Job Summary

Design, develop (code), test, and debug applications. Provide experienced Ready-to-Serve and development subject matter expertise. Maintain, enhance, and provide solutions for software applications. Provide development leadership in a functional area, module, or project. Major Tasks, Responsibilities and Key Accountabilities Works with stakeholders to perform application functionality gap analysis and feasibility studies. Leads development activities for a functional area, module, or project. Provides and documents technical design and specifications meeting business and functional requirements. Develops (code), implements, and maintains tools/applications. Ensures applications and systems possess sufficient controls. Performs unit testing prior to moving code/configuration to the QA process. Evaluates and researches upgrades, patches, and new functionality. Research defects and solve for root cause in applications. Assists in the development and definition of test plans and scripts for performance, regression, and user acceptance test plans; support QA activities as required. Builds and maintains templates, rules, style sheets, workflows, data extractions and imports, interfaces, and object models. Analyzes applications for compliance with security protocols. Trains team members on areas of expertise. Participate in and lead peer reviews. Career Level Dimensions Typical Training/Experience Typically requires BS/BA in a related discipline. Generally, 5-8 years of experience in a related field; certification is required in some areas OR MS/MA and generally 3-5 years of experience in a related field. Problem Complexity Identifies key barriers/core problems and applies problem solving skills to deal creatively with complex situations. Troubleshoots and resolves complex problems. Makes decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results. Autonomy Independently performs assignments with instruction limited to the results expected. Determines and develops an approach to solutions. Receives technical guidance only on unusual or complex problems or issues. Leadership May oversee the completion of projects and assignments, including planning, assigning, monitoring, and reviewing progress and accuracy of work, evaluating results, etc. Contributes to employees' professional development but does not have hiring or firing authority. Environmental Job Requirements Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable. Typically requires overnight travel less than 10% of the time. Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.Preferred Qualifications: Bachelor’s degree in Computer Science, Information Technology, or a related field. 5+ years of hands-on development experience in SQL and/or Python for data warehouse management, data integration, and data lake management Expert proficiency in Microsoft SQL Server OLAP solutions and/or Azure Synapse Analytics, Deep working knowledge in SQL development using T-SQL code to design, implement, and optimize complex database objects, such as tables, views, stored procedures, indexes, and functions, Experience working with Azure data architecture, including a solid understanding of tools for building data pipelines on cloud-based data platforms, such as Delta Lakehouse Medallion architecture and data warehousing solutions Exposure to modern Spark based data platforms like Databricks or Microsoft Fabric for data engineering tasks, including leveraging their capabilities for scalable data processing, analytics, and machine learning workflows in a cloud-based environment. Understanding of ELT vs ETL and how to build efficient data pipelines with modern Change Data Capture processes. Hands-on experience with CI/CD pipelines in Azure DevOps and understanding of Agile development methodologies. Familiarity with common data mapping and transformation techniques for Dynamics Data Entities and Data Management Framework for the Finance and Operations modules. #LI-Remote