Job Description:
Trigyn's direct government client has an immediate need for a Data Warehouse / BI Specialist in Albany, NY.
Description:
This Data warehouse and business intelligence position is required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements. This position will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and analytics. Additionally, This position respond to all data warehouse and BI related ad hoc inquiry requests, development of dashboard features, and development of BI technical solutions for continued reporting requirements.
• Gather and validate of BI and reporting requirements
• Document requirements & solutions
• Perform Data profiling on the source systems
• Design and review star schema dimensional model to support data warehouse and data marts
• Perform Source to Target Mapping between source system database and data warehouse target database
• Develop ETL transformations using the ETL tools like Pentaho Data Integration (PDI), or SQL Server Integration Services (SSIS)
• Develop reports and analytics using the tools like SQL Server Reporting Services (Pentaho or Tableau, Power BI)
• Develop complex queries using Transact-SQL leveraging analytic functions
• Perform necessary Testing
• Complete Documentation
Mandatory Qualification:
• Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 months experience in building extraction and transformation of transactional data to drive data warehouse loads and end user BI as well as reporting requirements using ETL tools like Pentaho Data Integration (PDI) or SQL Server Integration Services (SSIS)
• 84 months experience in reporting and analytics tools such as Pentaho or Tableau
• 84 months experience in complex SQL development leveraging analytics functions using in Sybase ASE or SQL Server
• 48 months experience in Pentaho Data Integration (PDI) development.
• 60 months experience in Star Schema / Dimensional Modeling to support data warehouse environments
• 84 months experience in doing data profiling and source to target mappings.
• 84 months experience in internal and external stakeholder communications and outreach, including the development of presentations and other materials.
For Immediate Response call 732-640-2404, or send your resume to RecruiterPK@Trigyn.com
For Immediate Response call 518-805-7401, or send your resume to RecruiterBP@Trigyn.com
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.