Immediate Need for a Federal Civilian Client:Resumes to:A' recruiting@A' Preferable US CITIZEN OR GREEN CARD HOLDERA' Senior Data Engineer and BI Developer11-15 years of experience of working on large enterprise-wide data-driven Data transformation programs/projects (Data Transformation, Data Warehousing, and Analytics). Ideally someone who has evolved from strong Data Architect, wide range of ETL tools, MS Stack, Reports and Dashboards Designer backgrounds. Data driven reports/analytics with ability to transform data in its current legacy systems. Proven experience as a BI Developer or Data ScientistBackground in data warehouse design (eg dimensional modeling) and data mining preferredIn-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. Familiarity with BI technologies (Microsoft Power BI preferred) Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). Proven abilities to take initiative and be innovative strong analytical problem solving skills. Ability to identify data trends, and recommend solutions for creating meaningful ways report and visualize data Excellent communication (written and oral) and interpersonal skills, skills and experience working with diverse, cross functional teamsAbility to provide assessments of technical and operational practices based on leading industry standards specific to the requested technology. Must be able to gather requirements, be able to utilize Power BI / Tableau to provide analysis and build sophisticated (but user-friendly) dashboards for senior leadership. Should be comfortable to work with and provide strategic direction to Agency leadership and other stakeholders (including vendors) to develop advanced analytics capabilities, such as trends, business intelligence, data management and predictive analytics.Responsibilities:Have the ability to work independently and to proactively seek guidance from others as neededTranslate business requirements into ETL designs and mapping specifications. Design and develop enterprise data warehousing and ETL solutions.Coordinate activities with data source application owners to ensure integration, data integrity and data quality. Work independently, preparing project status reports & formal presentations as required. Create and update ETL specificationsCreate and maintain ETL codeWork with federal and contractor staff to identify ETL requirementsParticipate in system related walkthroughsPerform data profiling to identify quality and standardization issues in data sourcesCreate, maintain and execute test plans for ETL streamsAssist architects in development of algorithms used to perform data matchingCapability to manage and handle escalations by liaising with the internal & external stakeholders of the businessHighly organized, motivated and solution oriented, accepting responsibilities and challenges that take them outside their comfort zoneExcellent time management skills and the ability to prioritize tasksExcellent written and communication skills, ability and working experience across all leadership levels, preferably in the Federal Government space.Minimum Education/Certification Requirements:Master's degree in Information Technology or related field or equivalent experienceRequired Experience:A cents € cents A' A' A' A' A' A' 6-8 years of experience in software development a must.A cents € cents A' A' A' A' A' A' Senior level ETL expert with hands on experience managing data transformations - transactional data into a star schema or de-normalized format.A cents € cents A' A' A' Strong experience developing ETLs for a Data Warehouse and the nuances of establishing Enterprise wide EDW.A cents € cents A' A' A' A' A' A' 5 + years of ETL experience using Talend Data Integration, SSIS and Store Procedure based data transformation. Strong knowledge of relational databases and OLAP databasesA cents € cents A' A' A' Strong proficiency in SSIS with ETL processing utilizing MS SQL Server 2008/R2/2012/2014.A cents € cents A' A' A' A' Excellent SQL and T-SQL development skills and store procedures.A cents € cents A' A' A' A' A' A' Ability to work through the SDLC to create new or migrate from existing environment to establish tool agnostic Metadata Layer to support report development.A cents € cents A' A' A' A' A' A' Ability to analyze and profile data, and develop functional requirements is a must.A cents € cents A' A' A' A' A' A' Expert at developing and testing SSIS packages in SQL Server 2012 and 2008r2A cents € cents A' A' A' A' A' A' Strong understanding of database schema, object management, data modeling and architecture, and data warehouse designA cents € cents A' A' A' A' A' A' Experience with installing/maintaining/ administering an ETL environmentA cents € cents A' A' A' A' A' A' Excellent communication and client management skills. Past experience with a large consulting firm would be nice to have.A cents € cents A' A' A' A' A' A' Roll up sleeves kind of mentality and flexibility to changing requirements in a fast paced environment.A cents € cents A' A' A' A' A' A' Must be comfortable with ambiguity and present complex analysis with ease across Agency users - ranging from IT, data experts or program leadership.