JOB REQUIREMENTS: Position Summary: Seeking a motivated and experienced back end and ETL Business Intelligence Engineer Lead who will be responsible for integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions using technologies such as Microsoft, Snowflake and Informatica. Major Responsibilities: Responsible for working within the framework of a team and performing the following activities: Help stakeholders understand the data through exploration, building and maintaining secure and compliant data processing pipelines by using different tools and techniques to produce cleansed and enhanced datasets for analysis. Ensure that data pipelines and data stores are high-performing, efficient, organized, and reliable, given a specific set of business requirements and constraints. Deal with unanticipated issues swiftly and minimizes data loss by performing data analysis required to troubleshoot data related issues and assist in the resolution of data issues. Design, implement, monitor, and optimize data platforms to meet the data pipeline needs ensuring production data is always accurate and available for key stakeholders and business processes that depend on it. Provides bridge between existing SSIS DW and future of Azure Data Factory & Azure Synapse Analytics solutions. Support & maintenance of existing data flow solutions. Collaborates with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization. Writes unit/integration tests, contributes to engineering wiki, and documents work. Works closely with a team of frontend and backend engineers, product managers, and analysts. Design data integrations and data quality framework. Understanding of use cases for semi-structured & relational data tech a plus. Data modeling of combined business data (ERP) and specialty system data in Power BI to engineer shared datasets for self-service reporting via Power BI & Excel Critical Competencies Significant experience in developing and troubleshooting Azure Data Factory Gen 2 solutions from pipelines to integration runtimes, managing triggers, and logging integrations. Proficient in navigating the Azure Portal to review, configure and troubleshoot data platform and supporting resources such as Storage Containers, SQL Server Managed Instances, and Log Analytics workspaces. Strong understanding of Microsoft SQL Server and supporting tools including SQL Server Management Studio (SSMS), SQL Server data tools in Visual Studio, and Integration Services (SSIS). Enterprise experience in data warehouse development and management: ETL vs ELT, star schemas, incremental load... For full info follow application link. Equal Employment Opportunity Employer: Female/Sexual Orientation/Gender Identity/Minority/Veteran/Disabled ***** APPLICATION INSTRUCTIONS: Apply Online: ipc.us/t/2C71CB4150D9426A